Overview
A big part of creating web applications is storing and managing data. Learn how to model your data, store it, and manage it with one of the most powerful databases professional developers use. This is the natural next step after the Backend track, and it is a prerequisite for this track. If you are interested in data science, you can also go through part of this track to deepen your skills.
Who curated this track
Intro to Relational Databases
(www.youtube.com)
Watch this series of videos to learn about how relational databases work. This will give you a solid foundation in how data is managed in your web applciation.
Introduction to SQL
(www.w3schools.com)
You've had some exposure to SQL in the foundations section of this track, but learn the ins and outs of the language. This is an old, but still excellent tutorial on SQL from w3schools.
SQLZoo
(sqlzoo.net)
Now that you know the basics of SQL, it's time to try some exercises and get your hands dirty. Go through these interactive tutorials to get through the motions.
Postgres.app
(postgresapp.com)
This is the easiest way to download Postgres if you have a Mac. Go ahead and download it.
Top 10 Psql Commands I Use
(www.chesnok.com)
Once you install Postgres, you should have access to the command 'psql' in your terminal to interact with Postgres. Learn how to use some basic commands in this article.
Use PostgreSQL with Flask
(killtheyak.com)
This is a very quick guide to getting your Postgres database connected to Flask. To start using SQLAlchemy, you're going to need to do this. Try it with your own Flask application.
Flask-SQLAlchemy Quickstart
(flask-sqlalchemy.pocoo.org)
Download the Flask-SQLAlchemy package using Python's pip and go through this tutorial. Try going through it using your Postgres database instead of a SQLite database.
Python SQLAlchemy Tutorial
(www.pythoncentral.io)
This is a pretty extensive tutorial that will show you how Python works together with SQLAlchemy. Go through all the articles in this series, using Postgres as your database instead of SQLite.
Object Relational Tutorial
(docs.sqlalchemy.org)
This is the official documentation for SQLAlchemy. It's the most comprehensive tutorial on their platform as you'll get and it's worth spending time studying it. Go through the whole thing.
Alembic Tutorial
(alembic.readthedocs.org)
Even with a practical understanding of Alembic, it's still very important to get a comprehensive understanding of the technology. This is Alembic's official tutorial. Go through the whole thing.
How Flask, Heroku & Alembic Play Together
(nyghtowl.io)
Read this short tutorial on how Alembic can help you manage database changes, in addition to how it works with Flask and Heroku. Try it with your own application.
