SQLAlchemy & Migrations

What you will be able to do

• Map classes to tables with SQLAlchemy 2.0
• Manage schema changes with Alembic
• Avoid the N+1 query problem

What you will learn

1. 16.1SQLAlchemy Core Ideas4 lessons

   Connect Python to the database. Engines and sessions, Declarative models, Queries with select().

   1. Engines and Sessions24 min
   2. Declarative Models (2.0 Style)26 min
   3. Queries with select()26 min
   4. SQLAlchemy Core Ideas Checkpoint25 min
2. 16.2Relationships & Performance4 lessons

   Load related data well. One-to-many and many-to-many, Lazy and eager loading, The N+1 problem.

   1. One-to-Many and Many-to-Many26 min
   2. Lazy and Eager Loading26 min
   3. The N+1 Problem26 min
   4. Relationships & Performance Checkpoint25 min
3. 16.3Alembic Migrations4 lessons

   Change the schema safely. Creating migrations, Upgrade and downgrade, Migrating with live data.

   1. Creating Migrations26 min
   2. Upgrade and Downgrade26 min
   3. Migrating with Live Data28 min
   4. Alembic Migrations Checkpoint25 min