Advanced Python: Working with Databases

Explore the database options for powering your Python apps. Learn how to create and connect to different types of databases, including SQLite, MySQL, and PostgreSQL.

Introduction

• Using databases to level up your Python applications

1. Introduction to Databases in Python

• What is a database?
• Relational databases
• Non-relational databases
• Python Database API

2. Using SQLite in Python

• What is SQLite?
• Creating an SQLite database
• Inserting your first record into an SQLite database
• Adding multiple records at a time to an SQLite database
• Filtering records in an SQLite database
• What is SQLAlchemy?
• Setting up a virtual environment for SQLAlchemy
• Executing a SQL query with SQLAlchemy
• Using the SQL expression language to write maintainable code
• Challenge: Create an SQLite database
• Solution: Create an SQLite database

3. Using MySQL in Python

• What is MySQL?
• Creating a MySQL database
• Building tables in a MySQL database
• Adding data to a MySQL database
• Connecting a Python application to a MySQL database
• Encapsulating database operations
• Setting up MySQL in Python using SQLAlchemy
• Building a model with SQLAlchemy ORM
• Adding up a foreign key with SQLAlchemy ORM
• Using SQLAlchemy Sessions to transact on a MySQL database
• Retrieving data using SQLAlchemy ORM
• Challenge: Create a MySQL database
• Solution: Create a MySQL database

4. Using PostgreSQL in Python

• What is PostgreSQL?
• Creating a PostgreSQL database
• Creating a table in Postgres using Python
• Inserting data into a Postgres database
• Interacting with a Postgres database using Python
• Setting up SQLAlchemy Core to connect to a Postgres database
• Manipulating with Postgres data using SQLAlchemy Core
• Setting up SQLAlchemy ORM to connect to a Postgres database
• Manipulating with Postgres data using SQLAlchemy ORM
• Challenge: Create a Postgres database
• Solution: Create a Postgres database

Conclusion

• Continue using databases in Python applications