SQL Databases Using SQLAlchemy: Using Triggers Stored Procedures & Transactions

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 youll learn about some of these procedural constructs of SQL including triggers stored procedures and transactions. Youll start by learn how to define triggers to perform specific operations before or after insert update or delete operations on specific tables. Youll also define stored procedures and invoke them using raw DBAPI connection objects. Moving forward youll define and invoke stored procedures that take in input arguments. Youll also create commit and rollback transactions to enforce all-or-nothing execution of a group of SQL commands. To finish up youll learn how DDL operations such as create drop and alter operations are not reversed by transaction rollback. By the end of this course youll 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.