Connecting to a SQL Database Project Tutorial

Create a SQL database locally using the psql command.
Understand and get used to the most basic professional Python project structure with PIP and .env file.
Use SQL Alchemy, the most popular library in the industry for connecting to SQL databases.
Use Pandas to display SQL Tables as dataframes.

Inside this repository, you will find a file called ./INSTRUCTIONS.md with the steps needed to complete it.

🌱 How to start this project

This project comes with the necessary files to start working immediately.

We recommend opening this very same repository using a provisioning tool like Codespaces (recommended) or Gitpod. Alternatively, you can clone it on your local computer using the git clone command.

This is the repository you need to fork and open:

1https://github.com/4GeeksAcademy/connecting-to-a-sql-database-project-tutorial

👉 Please follow these steps on how to start a coding project.

Once your project and code have finished opening, you can go ahead and open the app.py file and start solving each exercise inside the notebook.

🚛 How to deliver this project

Once you have finished solving the exercises, be sure to commit your changes, push them to your repository, and go to 4Geeks.com to upload the repository link.

Solutions

We also incorporated the solution samples on ./src/solution.py that we strongly suggest you only use if you are stuck for more than 30 min or if you have already finished and want to compare it with your approach.

Sign up and get access to solution files and videos for free

Difficulty

easy

Average duration

2 hrs

Technologies

postgre

Back End

Data Science

mysql

SQL

databases

psycopg2
dotenv

Pandas

Machine Learning

Python

SQL Alchemy

Difficulty

easy

Average duration

2 hrs

Technologies

postgre

Back End

Data Science

mysql

SQL

databases

psycopg2
dotenv

Pandas

Machine Learning

Python

SQL Alchemy

Start interactive tutorial

Connecting to a SQL Database Project Tutorial

🌱 How to start this project

🚛 How to deliver this project

Solutions

Sign up and get access to solution files and videos for free

Sign up and get access to solution files and videos for free