Database Transactions

Oracle 12c    |    Beginner
  • 10 videos | 45m 48s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 230 users Rating 4.6 of 230 users (230)
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

  • 2m 45s
    After completing this video, you will be able to describe database transactions and how to ensure data consistency during DML, DDL, and DCL activity on the database. FREE ACCESS
  • 5m
    After completing this video, you will be able to describe the COMMIT, SAVEPOINT, and ROLLBACK SQL statements. FREE ACCESS
  • Locked
    3.  Explicit Transaction Control Statements
    2m 25s
    Upon completion of this video, you will be able to describe the control of the logic within transactions. FREE ACCESS
  • Locked
    4.  Using ROLLBACK
    5m 54s
    In this video, learn how to use the ROLLBACK SQL command to undo changes to a defined marker. FREE ACCESS
  • Locked
    5.  Implicit Transaction Processing
    4m 17s
    Upon completion of this video, you will be able to describe the conditions under which an automatic commit statement is issued and the impact on the database. FREE ACCESS
  • Locked
    6.  Database State before and after COMMIT
    4m 41s
    After completing this video, you will be able to describe the state of the database before and after a COMMIT SQL command. FREE ACCESS
  • Locked
    7.  Database State before and after ROLLBACK
    5m 21s
    After completing this video, you will be able to describe the state of the database before a ROLLBACK SQL command is executed within the database. FREE ACCESS
  • Locked
    8.  Implementing Read Consistency
    3m 54s
    After completing this video, you will be able to describe read consistency and its role in databases. FREE ACCESS
  • Locked
    9.  FOR UPDATE Clause in a SELECT statement
    5m 24s
    Upon completion of this video, you will be able to describe how to use the FOR UPDATE clause in a SQL statement. FREE ACCESS
  • Locked
    10.  Exercise: Process a Database Transaction
    6m 8s
    In this video, find out how to process a transaction using standard transaction control statements. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)
Channel Oracle RAC

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL*Plus Commands
Rating 4.5 of 285 users Rating 4.5 of 285 users (285)
Course MySQL: Getting Started
Rating 4.6 of 363 users Rating 4.6 of 363 users (363)
Course Data Conversion
Rating 4.6 of 203 users Rating 4.6 of 203 users (203)