SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions
SQLAlchemy 1.3
| Expert
- 10 Videos | 1h 18m 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 courseautomate operations using triggerscreate complex triggerscreate and invoke stored procedurescustomize stored procedures using input arguments
-
query views using the where clausestart, commit, and rollback a transactionuse Python with blocks for transactionswork with transaction abortssummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 21sUP NEXT
-
2.Using Triggers to Automate Tasks in SQL8m 14s
-
3.Creating Complex Triggers in SQL9m 14s
-
4.Creating and Invoking Stored Procedures11m 56s
-
5.Creating Stored Procedures with Input Arguments7m 41s
-
6.Querying SQL Views Using the Where Clause8m
-
7.Working with Transactions9m 55s
-
8.Using Python with Blocks for Transactions9m 51s
-
9.Working with Transaction Aborts7m 55s
-
10.Course Summary2m 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.