4Geeks logo
4Geeks logo
About us

Learning library

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

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

Full-Stack Software Developer

Data Science and Machine Learning - 16 wks

Search from all Lessons

Social & live learning

The most efficient way to learn: Join a cohort with classmates just like you, live streams, impromptu coding sessions, live tutorials with real experts, and stay motivated.

← Back to Projects

Continue learning for free about:

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 using the MariaDB endine on top Heroku.com.
  • 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

The easiest way to start working on this project is by using Gitpod:

  1. Make a fork of this repository into your github account.
  2. Open the recently created fork on Gitpod by using the Gitpod button extension.
  3. 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 commit your changes, 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