Mastering SQLAlchemy

Mastering SQLAlchemy

Interact with databases with Python's "batteries included" library: SQLAlchemy. Managing database connections & sessions with minimal boilerplate, creating data models, and querying your data using the built-in ORM. Learn to leverage built-in integrations with popular libraries such as Flask and Pandas to make database interactions trivial.

What You'll Learn

Spin up database connections with minimal effort.
Write data models for MVC applications.
Fetch and modify data via the ORM or plaintext SQL queries.
Define one-to-one, one-to-many, and many-to-many relationships via the ORM.
Perform JOINs and aggregations on data models.

For those who...

Have an understanding of Python.
Grasp the underlying concepts of relational databases.
Prefer to handle application data layers via an ORM.

Databases in Python Made Easy with SQLAlchemy

Leverage the iconic SQLAlchemy Python library to effortlessly handle database connections and queries in software.

Implement ORM Data Models with SQLAlchemy

Handle your application's data layer with SQLAlchemy's powerful ORM. Define data models, add/remove records, and execute queries purely in Python.

Queries as Python Code with SQLAlchemy's Expression Language

Work with your app's data entirely in Python by defining data models and using the session object from SQLAlchemy's ORM.

Relationships Between SQLAlchemy Data Models

Create database table models & relationships with SQLAlchemy's ORM. Create one-to-one, one-to-many, many-to-one, and many-to-many relationships.