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.
Overview
Syllabus
Introduction
- Using databases to level up your Python applications
- What is a database?
- Relational databases
- Non-relational databases
- Python Database API
- 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
- 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
- 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
- Continue using databases in Python applications
Taught by
Kathryn Hodge