Start Here
Learn Python
Python Tutorials →
In-depth articles and video courses Learning Paths →
Guided study plans for accelerated learning Quizzes & Exercises →
Check your learning progress Browse Topics →
Focus on a specific area or skill level Community Chat →
Learn with other Pythonistas Office Hours →
Live Q&A calls with Python experts Live Courses →
Live, instructor-led Python courses Podcast →
Hear what’s new in the world of Python Books →
Round out your knowledge and learn offline Reference →
Concise definitions for common Python terms Code Mentor →Beta
Personalized code assistance & learning tools Unlock All Content →
More
Learner Stories Python Newsletter Python Job Board Meet the Team Become a Contributor

Search

/

Join
Sign‑In

Loading exercise...

Exercise: Model a Many-to-Many With Genres

Christopher Trudeau

SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat Files Christopher Trudeau 12:00

Recommended Tutorial Course Slides (.pdf) Sample Code (.zip) Ask a Question

Discussion

Become a Member to join the conversation.

Course Contents

Overview

91%

SQLite and SQLAlchemy in Python (Overview) 02:44

Flat CSV Files 04:28

Relational Databases 13:52

SQLAlchemy: Core Text 14:13

Exercise: Run a SELECT With Raw SQL 08:00

SQLAlchemy: Core Statements 10:14

Exercise: Filter With a Core select() Statement 08:00

SQLAlchemy: ORM 10:37

Exercise: Declare Director and Movie ORM Models 08:30

Many-to-Many Relationships 12:07

Exercise: Model a Many-to-Many With Genres 12:00

SQLite and SQLAlchemy in Python (Summary) 03:54

© 2012–2026 Real Python ⋅ Privacy Policy