4Geeks logo
4Geeks logo

Courses

Explore our extensive collection of courses designed to help you master various subjects and skills. Whether you're a beginner or an advanced learner, there's something here for everyone.

Coding Bootcamp

Learn live

Join us for our free workshops, webinars, and other events to learn more about our programs and get started on your journey to becoming a developer.

Upcoming live events

Learning library

For all the self-taught geeks out there, here is our content library with most of the learning materials we have produced throughout the years.

It makes sense to start learning by reading and watching videos about fundamentals and how things work.

Data Science and Machine Learning - 16 wks

Full-Stack Software Developer - 16w

Search from all Lessons

LoginGet Started
← Back to Projects

Connecting to a SQL Database Project Tutorial

Goal

4Geeks Coding Projects tutorials and exercises for people learning to code or improving their coding skills

Difficulty

beginner

Repository

Click to open

Video

Click to open

Live demo

Not available

Average duration

2 hrs

Technologies

  • Create a SQL database localy using the psql command.
  • Understand and get used to the most basic profesional python project structure with PIP and .env file.
  • Use SQLAlchemy 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:

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

πŸ‘‰ Please follow these steps on how to start a coding project.

Once Gitpod VSCode has finished opening you can go ahead and open the problems.ipynb file and start solving each exercise inside the notebook.

πŸš› How to deliver this project

Once you are finished solving the exercises make sure to make your changes, then push to your repository fork 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 30min or if you have already finished and want to compare it with your approach.

Goal

4Geeks Coding Projects tutorials and exercises for people learning to code or improving their coding skills

Difficulty

beginner

Repository

Click to open

Live demo

Not available

Average duration

2 hrs

Technologies