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