SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM

SQLAlchemy 1.3
  • 8 Videos | 1h 7m 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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 13s
    UP NEXT
  • Playable
    2. 
    Implementing Check Constraints
    5m 10s
  • Locked
    3. 
    Creating Custom Foreign Key Constraints
    10m
  • Locked
    4. 
    Creating Tables Using the SQLAlchemy ORM
    11m 53s
  • Locked
    5. 
    Querying Data Using the SQLAlchemy ORM
    11m 2s
  • Locked
    6. 
    Using Automap Base to Convert Tables to Classes
    9m 33s
  • Locked
    7. 
    Inserting Data into Tables Using the ORM
    11m 47s
  • Locked
    8. 
    Course Summary
    2m 36s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.