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.
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.
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.
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.
This is the easiest way to download Postgres if you have a Mac. Go ahead and download it.
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.
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.
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.
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.
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.
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.
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.