SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source and cross-platform software released under MIT license. SQLAlchemy is famous for its object-relational mapper (ORM), using which classes can be mapped to the database, thereby allowing the object model and database schema to develop in a cleanly decoupled way from the beginning.

This tutorial is designed for all those Python programmers who would like to understand the ORM framework with SQLAlchemy and its API.

Before you start proceeding with this tutorial, we assume you have a good understanding of the Python programming language. A basic understanding of relational databases, DB-API, and SQL is desired to understand this tutorial.

Course Content

SQLAlchemy Tutorial
SQLAlchemy Home
SQLAlchemy Introduction
SQLAlchemy Core
SQLAlchemy Core – Expression Language
SQLAlchemy Core Connecting to Database
SQLAlchemy Core Creating Table
SQLAlchemy Core SQL Expressions
SQLAlchemy Core Executing Expression
SQLAlchemy Core Selecting Rows
SQLAlchemy Core Using Textual SQL
SQLAlchemy Core Using Aliases
Using UPDATE Expression
Using DELETE Expression
SQLAlchemy Core Using Multiple Tables
Using Multiple Table Updates
ParameterOrdered Updates
SQLAlchemy Core Multiple Table Deletes
SQLAlchemy Core Using Joins
SQLAlchemy Core Using Conjunctions
SQLAlchemy Core Using Functions
SQLAlchemy Core Using Set Operations
SQLAlchemy ORM
SQLAlchemy ORM Declaring Mapping
SQLAlchemy ORM Creating Session
SQLAlchemy ORM Adding Objects
SQLAlchemy ORM Using Query
SQLAlchemy ORM Updating Objects
SQLAlchemy ORM Applying Filter
SQLAlchemy ORM Filter Operators
Returning List and Scalars
SQLAlchemy ORM Textual SQL
SQLAlchemy ORM Building Relationship
Working with Related Objects
SQLAlchemy ORM Working with Joins
Common Relationship Operators
SQLAlchemy ORM Eager Loading
SQLAlchemy ORM Deleting Related Objects
Many to Many Relationships
SQLAlchemy Dialects
SQLAlchemy Quick Guide
SQLAlchemy Useful Resources
Discuss SQLAlchemy

Student Feedback

Course Rating