Oracle Database 11g: Subqueries and Regular Expressions

Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisite
Familiarity with data processing concepts and techniques

Expected Duration
110 minutes

Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Objective

Oracle Database 11g: Subqueries and Regular Expressions

  • identify the steps for writing multiple-column and scalar subqueries.
  • recognize the steps for solving problems by using correlated subqueries and the WITH clause.
  • write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
  • recognize the benefits of implementing complex match logic in the database, using regular expressions.
  • identify the steps for using regular expressions functions and for accessing subexpressions.
  • use regular expressions functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.