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

Oracle SQL 12c    |    Beginner
  • 12 Videos | 1h 4m 30s
  • Includes Assessment
  • Earns a Badge
Likes 47 Likes 47
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

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE