Oracle Database 12c - Introduction to SQL: Data Manipulation Language


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Once an Oracle 12c relational database has been created with objects, the data in these objects need to be managed. In this course you will learn how to insert, update, delete, and truncate rows. The course will teach the concepts of database transaction control using COMMIT, ROLLBACK, and SAVEPOINT. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Target Audience
Functional Implementer, Forms Developer, System Analysts, Application Developers, PL/SQL Developer and learners looking to obtain the Oracle Database 12c Administrator Certified Associated designation or to become an OPN Certified Specialist.

Prerequisites
None

Expected Duration (hours)
1.9

Lesson Objectives

Oracle Database 12c - Introduction to SQL: Data Manipulation Language

  • start the course
  • define the Data Manipulation Language in SQL
  • add rows to a table in the database by using the INSERT SQL statement
  • work with NULL values during the INSERT SQL statement when adding rows to a table
  • work with SPECIAL values during the INSERT SQL statement when adding rows to a table
  • work with specific DATE and TIME values during the INSERT SQL statement when adding rows to a table
  • save commands with substitution variables to a file and execute the commands in the file
  • use the INSERT SQL statement to copy rows from one table to another
  • change data in a table using the UPDATE SQL statement
  • change data into two columns using a subquery to update the two columns using the UPDATE SQL statement
  • change the rows in a table based on a different table using the UPDATE SQL statement
  • remove rows from a table using the DELETE SQL statement
  • remove rows from a table based on a different table using the DELETE SQL statement
  • use the TRUNCATE SQL statement to delete all rows from a table
  • insert and update rows in a table
  • describe database transactions and how to ensure data consistency during DML, DDL and DCL activity on the database
  • describe the COMMIT 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
  • Course Number:
    od_insq_a06_it_enus

    Expertise Level
    Beginner