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

SQLAlchemy 1.3
  • 10 Videos | 1h 18m 33s
  • 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 24s
    UP NEXT
  • Playable
    2. 
    Using Triggers to Automate Tasks in SQL
    8m 17s
  • Locked
    3. 
    Creating Complex Triggers in SQL
    9m 17s
  • Locked
    4. 
    Creating and Invoking Stored Procedures
    11m 59s
  • Locked
    5. 
    Creating Stored Procedures with Input Arguments
    7m 44s
  • Locked
    6. 
    Querying SQL Views Using the Where Clause
    8m 3s
  • Locked
    7. 
    Working with Transactions
    9m 58s
  • Locked
    8. 
    Using Python with Blocks for Transactions
    9m 54s
  • Locked
    9. 
    Working with Transaction Aborts
    7m 58s
  • Locked
    10. 
    Course Summary
    3m

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.