- Create a SQL database using the MariaDB endine on top Heroku.com.
- Undertand 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.
The easiest way to start working on this project is by using Gitpod:
- Make a fork of this repository into your github account.
- Open the recently created fork on Gitpod by using the Gitpod button extension.
- Once Gitpod VSCode has finished opening you can go ahead and open the
problems.ipynb
file and start solving each exercise inside the notebook.
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.
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.