SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM

SQLAlchemy 1.3    |    Expert
  • 8 videos | 1h 4m 14s
  • Includes Assessment
  • Earns a Badge
The SQLAlchemy Object Relational Mapping (ORM) module treats each database table as a class, and each row in that table as an instance or object of that class. These classes are very easy to define and use via base classes provided in the ORM API. In this course, you'll start by defining check constraints and using them to enforce generic conditions on data in a column. You'll then use cascading update and delete with foreign keys to propagate changes from the parent table to child table. Next, you'll illustrate how the SQLAlchemy ORM treats each table in a database as a class, and rows in that table as objects of that class. You'll identify how the declarative_base class is suitable for creating new tables, while the automap_base is ideal for reading in pre-existing tables from a database. Upon finishing this course, you'll be able to create and enforce check constraints, enable cascading delete and update on foreign key constraints, use the ORM API to model tables as classes, correctly extend the declarative_base and automap_base classes from the ORM API and use them to perform SQL commands.


  • Discover the key concepts covered in this course
    Implement check constraints
    Create custom foreign key constraints using cascade options
    Create tables using object relational mapping
  • Query data using object relational mapping
    Use the automap_base function to convert tables to classes
    Perform insert operations using object relational mapping
    Summarize the key concepts covered in this course


  • 2m 13s
  • 5m 10s
    In this video, learn how to implement check constraints. FREE ACCESS
  • Locked
    3.  Creating Custom Foreign Key Constraints
    During this video, you will learn how to create custom foreign key constraints with cascade options. FREE ACCESS
  • Locked
    4.  Creating Tables Using the SQLAlchemy ORM
    11m 53s
    In this video, learn how to create tables using object-relational mapping. FREE ACCESS
  • Locked
    5.  Querying Data Using the SQLAlchemy ORM
    11m 2s
    Find out how to query data using object-relational mapping. FREE ACCESS
  • Locked
    6.  Using Automap Base to Convert Tables to Classes
    9m 33s
    Learn how to use the automap_base function to convert tables to standard classes. FREE ACCESS
  • Locked
    7.  Inserting Data into Tables Using the ORM
    11m 47s
    In this video, find out how to perform insert operations using an object relational mapper. FREE ACCESS
  • Locked
    8.  Course Summary
    2m 36s


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.