Py
Py
Run
What do you want to learn?
Lessons
⌄
Browse the curriculum
Find your level
Practice problems
Interview prep
Cheat sheets
Career paths
Explore by role
All lessons
Fundamentals
Web development
Data
Engineering
Data science
Machine learning
GenAI & RAG
Automation
DSA / interview
Tools
new
⌄
Online compiler
Playground
Revise
Terminal
SQL playground
Notebook
Build
⌄
Workspaces
Guided projects
My published sites
Blog
Pricing
AI
en
Sign in
Start free
→
Start free
→
loading…
Feedback
💬
Ask PyRun
Home
›
All lessons
›
Data
›
SQLAlchemy Core — SQL as Python
SQLAlchemy Core — SQL as Python
Advanced
15 min
Data
data · sql · sqlalchemy · database
Try it
↓
Lesson
3
of
10
In this track
▾
1
SQLite with Python's sqlite3
12 min
2
SQL joins that actually make sense
15 min
3
SQLAlchemy Core — SQL as Python
15 min
4
SQLAlchemy ORM — objects that persist
18 min
5
Database migrations with Alembic
15 min
6
Series & DataFrame: the two shapes of pandas
12 min
7
Cleaning messy data
14 min
8
Filtering, querying & top-N
12 min
9
groupby & aggregation
15 min
10
Combining tables: merge, join & concat
15 min
←
→
Loading lesson…
←
Previous lesson
SQL joins that actually make sense
Advanced · 15 min
Next lesson
→
SQLAlchemy ORM — objects that persist
Advanced · 18 min
Related lessons
Advanced · 15 min
Database migrations with Alembic
Python database migrations with Alembic and SQLAlchemy: evolve schemas safely with revisions, autogenerate, and an audit trail.
Advanced · 18 min
SQLAlchemy ORM — objects that persist
Declare Python classes, get automatic CRUD, relationships, and lazy loading.
Advanced · 15 min
SQL joins that actually make sense
INNER, LEFT, RIGHT, FULL — with a concrete users-and-orders example.