Database Transactions
Oracle 12c
10 Videos | 50m 18s - Includes Assessment
- Earns a Badge
It's important to ensure that the SQL statements that make up a transaction succeed or fail as a group. Explore the concepts of database transaction control using the COMMIT, ROLLBACK, and SAVEPOINT commands.
WHAT YOU WILL LEARN
-
describe database transactions and how to ensure data consistency during DML, DDL and DCL activity on the database
describe the COMMIT, SAVEPOINT, and ROLLBACK SQL statements
describe the control of the logic within transactions
use the ROLLBACK SQL command to undo changes to a defined marker
describe the conditions in which an automatic commit statement is issued and the impact on the database -
describe the state of the database before and after a COMMIT SQL command within the database
describe the state of the database before a ROLLBACK SQL command within the database
describe read consistency and its role in the database
describe using the FOR UPDATE clause in a SQL statement
process a transaction using explicit transaction control statements
IN THIS COURSE
-
1.Database Transactions2m 45s
-
2.COMMIT and ROLLBACK Statements5m
-
3.Explicit Transaction Control Statements2m 25s
-
4.Using ROLLBACK5m 54s
-
5.Implicit Transaction Processing4m 17s
-
6.Database State before and after COMMIT4m 41s
-
7.Database State before and after ROLLBACK5m 21s
-
8.Implementing Read Consistency3m 54s
-
9.FOR UPDATE Clause in a SELECT statement5m 24s
-
10.Exercise: Process a Database Transaction6m 8s
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.
