Oracle Database 11g: Conversion Functions, Group Functions, and Joins

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
120 minutes

Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.

Objective

Oracle Database 11g: Conversion Functions, Group Functions, and Joins

  • identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.
  • recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.
  • identify and write queries that convert data types and implement conditional processing, in a given scenario.
  • recognize the benefits of using group functions to return values for groups of rows.
  • identify the steps for creating, restricting, and nesting group functions.
  • identify the steps for using joins to return data from more than one table.
  • write queries that calculate values for groups of data and return values from multiple tables in a given scenario.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.