← Courses
PostgreSQL & SQLAlchemy Guide
IntermediatecourseBootcamp access

PostgreSQL & SQLAlchemy Guide

48

Lessons

6

Modules

🎓

Bootcamp access

Lo que aprenderás

✓Install and configure PostgreSQL locally and with Docker, master psql and pgAdmin
✓Design schemas with advanced types (UUID, JSONB, TIMESTAMP) and constraints
✓Write complex SQL queries with JOINs, subqueries, CTEs and aggregations
✓Model 1:N and N:M relationships with foreign keys and junction tables
✓Optimize performance with B-tree indexes and EXPLAIN ANALYZE
✓Ensure data integrity with ACID transactions and isolation levels
✓Model data in Python with SQLAlchemy 2.0 ORM (Mapped, mapped_column, relationships)
✓Run CRUD with Sessions and queries with eager/lazy loading
✓Version your schema with Alembic: autogenerate, upgrade/downgrade, data migrations
✓Integrate PostgreSQL with FastAPI using AsyncSession, dependency injection and connection pooling

¿Para quién es?

  • •Developers who completed FastAPI Fundamentals and FastAPI Advanced and need real persistence
  • •Backend developers from other languages (Node, Java, Go) who want to master the PostgreSQL + Python stack
  • •Programmers who have used basic SQL but never designed schemas with complex relationships or versioned migrations
  • •Students of the Backend Python Developer Path building the Blog Platform API project
  • •Developers who want to learn SQLAlchemy 2.0 (the modern, typed API), not the legacy one

Requisitos

  • •Intermediate Python (classes, async/await, type hints, decorators)
  • •FastAPI Fundamentals completed (path operations, Pydantic, basic dependency injection)
  • •FastAPI Advanced Features completed (advanced Depends, APIRouter, response models)
  • •Familiarity with the command line (terminal/shell)
  • •Docker installed (recommended to skip local install friction)

Course content

1Módulo 1: PostgreSQL Fundamentals — Guía para el Creador8 lessons
2Módulo 2: SQL Queries y Relationships — Guía para el Creador8 lessons
3Módulo 3: Indexes y Transactions — Guía para el Creador8 lessons
4Módulo 4: SQLAlchemy ORM — Guía para el Creador8 lessons
5Módulo 5: Alembic Migrations — Guía para el Creador8 lessons
6Módulo 6: FastAPI + Async SQLAlchemy — Guía para el Creador8 lessons
Reviews

What students say

These reviews are from enrolled students who completed at least 50% of the course. We moderate reviews only on content grounds (spam, offensive language, personal data), never for being critical or negative.

No approved reviews yet.

Be the first to share your experience!