Database Transactions

Oracle 12c    |    Beginner
  • 10 Videos | 45m 48s
  • Includes Assessment
  • Earns a Badge
Likes 46 Likes 46
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.

YOU MIGHT ALSO LIKE

BOOK Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency, Second Edition
CHANNEL Database Performance Tuning
Likes 32 Likes 32  
COURSE Database Fundamentals: Understanding Relational Database Management Systems

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Substitution
Likes 146 Likes 146  
COURSE Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 72 Likes 72  
COURSE SQL*Plus Commands
Likes 90 Likes 90