SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions

SQLAlchemy 1.3    |    Expert
  • 10 Videos | 1h 22m 4s
  • Includes Assessment
  • Earns a Badge
Triggers are used for asynchronous execution and react to specific conditions in your database. Stored procedures can be used to achieve code reuse and code composition of SQL commands. In ths course, you'll learn about some of these procedural constructs of SQL, including triggers, stored procedures, and transactions. You'll start by learn how to define triggers to perform specific operations before or after insert, update, or delete operations on specific tables. You'll also define stored procedures and invoke them using raw DBAPI connection objects. Moving forward, you'll define and invoke stored procedures that take in input arguments. You'll also create, commit, and rollback transactions to enforce all-or-nothing execution of a group of SQL commands. To finish up, you'll learn how DDL operations, such as create, drop, and alter operations, are not reversed by transaction rollback. By the end of this course, you'll be able to create and test trigger executions, correctly invoke stored procedures using DBAPI connections, achieve code re-use with parameterized stored procedures, and work with transactions from Python using with blocks and transaction objects.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    automate operations using triggers
    create complex triggers
    create and invoke stored procedures
    customize stored procedures using input arguments
  • query views using the where clause
    start, commit, and rollback a transaction
    use Python with blocks for transactions
    work with transaction aborts
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 21s
    UP NEXT
  • Playable
    2. 
    Using Triggers to Automate Tasks in SQL
    8m 14s
  • Locked
    3. 
    Creating Complex Triggers in SQL
    9m 14s
  • Locked
    4. 
    Creating and Invoking Stored Procedures
    11m 56s
  • Locked
    5. 
    Creating Stored Procedures with Input Arguments
    7m 41s
  • Locked
    6. 
    Querying SQL Views Using the Where Clause
    8m
  • Locked
    7. 
    Working with Transactions
    9m 55s
  • Locked
    8. 
    Using Python with Blocks for Transactions
    9m 51s
  • Locked
    9. 
    Working with Transaction Aborts
    7m 55s
  • Locked
    10. 
    Course Summary
    2m 57s

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.