Oracle Database 11g: Subqueries, Set Operators, and Data Manipul

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
1.9

Lesson Objectives

Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation

• Recognize the steps for using subqueries inside other queries to perform various actions.
• Identify the steps for using set operators to combine the results of two or more queries.
• Write queries using set operators.
• Identify the steps for adding new rows to a table, modifying table data, and removing rows.
• Recognize the steps for controlling database transactions, and implementing read consistency.
• Insert, update and delete rows in a table, and control data transactions to it.