Database Transactions

Oracle 12c
  • 10 Videos | 50m 18s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
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

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 37 Likes 37  
Likes 45 Likes 45