Brewing with SQLAlchemy

In this series, we don't just write code; we brew it. This is your personal workshop for mastering the magic of SQLAlchemy. We'll guide you from the core fundamentals to crafting complex queries and advanced data models. By the end, you'll have the confidence to solve any data challenge and build powerful, scalable applications.

Introduction to SQLAlchemy

SQLAlchemy Installation and Setup

Brewing with SQLAlchemy

Objectifying our database with SQLAlchemy ORM

Making SQLAlchemy Queries

Using SQL Functions and More in SQLAlchemy ORM

The SQLAlchemy Session Class

Getting Attached to SQLAlchemy Using Relationships

SQLAlchemy ORM Relationship Loading Techniques

Filtering Relationship Collections

Integrating Dataclasses with SQLAlchemy Tables

Casting our Own Types for SQLAlchemy

Polymorphic Tables in SQLAlchemy

Delving into the Hybrid Declarative Approach in SQLAlchemy

Working with JSON and JSONB in SQLAlchemy ORM