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

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

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

Expected Duration
115 minutes

Description
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.

Objective

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.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.