← Cursos
🎓
IntermediocourseAcceso por bootcamp

PostgreSQL & SQLAlchemy Guide

48

Lecciones

6

Módulos

🎓

Acceso por bootcamp

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)

Contenido del curso

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

What students say

Sign in to leave a review.

No approved reviews yet.

Be the first to share your experience!