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

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)
2.0

Lesson Objectives

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.