Python SQL Toolkit & ORM
Widely used ORM library providing a full suite of enterprise-level persistence patterns. Designed for efficient, high-performing database access with flexible SQL abstraction.
Explore hands-on projects that use SQLAlchemy to build real-world data engineering solutions.
Learn the most popular Python ORM by building a complete database application with SQLAlchemy. Master model definitions, database sessions, CRUD operations, and query building. Essential skills for any data engineer working with relational databases in Python.
Learn how to use Alembic, the standalone database migration tool for SQLAlchemy, to manage schema changes over time. This project demonstrates creating initial migrations, adding columns, creating new tables, and rolling back changes - essential skills for maintaining database schemas in production.
Master Flask-Migrate, the Flask extension that integrates Alembic for database migrations. Learn to manage schema changes in Flask applications, add fields to models, create new tables, and maintain database version control - essential for Flask-based data applications.
Django's Built-in ORM
Part of Django web framework, allows defining data models entirely in Python. Provides powerful abstraction layer to translate Python code to SQL seamlessly.