Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language

Oracle SQL 12c    |    Beginner
  • 12 videos | 59m
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 76 users Rating 4.6 of 76 users (76)
Once an Oracle 12c relational database has been created with objects, the data in these objects needs to be managed. Discover how to insert, update, delete, and truncate rows.

WHAT YOU WILL LEARN

  • Define the data manipulation language in sql
    Add rows to a table in the database by using the insert sql statement
    Insert rows with null values
    Insert a special value in a table
    Change data in a table using the update statement
    Remove rows from a table using the delete and truncate statement
  • Use the commit and rollback statements
    Use the savepoint statement
    Describe a statement level rollback
    Guarantee consistent view of data at all times
    Demonstrate when to use the for update and lock table statements
    Insert and update rows in a table

IN THIS COURSE

  • 2m 7s
    In this video, you will learn how to define the Data Manipulation Language in Structured Query Language. FREE ACCESS
  • 5m 47s
    In this video, find out how to add rows to a table in the database by using the INSERT SQL statement. FREE ACCESS
  • Locked
    3.  Inserting Rows with NULL Values
    4m 26s
    Learn how to insert rows with no values. FREE ACCESS
  • Locked
    4.  Inserting Special Values
    3m 53s
    In this video, you will learn how to insert a special value into a table. FREE ACCESS
  • Locked
    5.  UPDATE Statement
    3m 13s
    In this video, learn how to change data in a table using the UPDATE statement. FREE ACCESS
  • Locked
    6.  TRUNCATE Statement
    7m 41s
    Find out how to remove rows from a table using the DELETE and TRUNCATE statements. FREE ACCESS
  • Locked
    7.  Transactions
    4m 55s
    During this video, you will learn how to use the COMMIT and ROLLBACK statements. FREE ACCESS
  • Locked
    8.  SAVEPOINT
    5m 7s
    In this video, you will learn how to use the SAVEPOINT statement. FREE ACCESS
  • Locked
    9.  Statement-level Rollback
    2m 14s
    Upon completion of this video, you will be able to describe a statement-level rollback. FREE ACCESS
  • Locked
    10.  Read Consistency
    5m 37s
    In this video, you will learn how to ensure a consistent view of data at all times. FREE ACCESS
  • Locked
    11.  Manual Data Locking
    7m 56s
    Learn how and when to use the FOR UPDATE and LOCK IN SHARE MODE statements. FREE ACCESS
  • Locked
    12.  Exercise: Manipulate Data in a Table
    6m 3s
    Learn how to insert and update rows in a table. 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)
Channel Oracle Database Administration
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course Oracle Database 12c R2 SQL: Managing Schema Objects
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Creating Other Schema Objects
Rating 4.4 of 48 users Rating 4.4 of 48 users (48)
Course Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Rating 4.7 of 40 users Rating 4.7 of 40 users (40)
Course Oracle Database 12c R2 SQL: Using the Set Operators
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)