Database Transactions
Oracle 12c
| Beginner
- 10 Videos | 45m 48s
- 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 databasedescribe the COMMIT, SAVEPOINT, and ROLLBACK SQL statementsdescribe the control of the logic within transactionsuse the ROLLBACK SQL command to undo changes to a defined markerdescribe 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 databasedescribe the state of the database before a ROLLBACK SQL command within the databasedescribe read consistency and its role in the databasedescribe using the FOR UPDATE clause in a SQL statementprocess 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.