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

Overview/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.

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

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Conversion Functions, Conditional Expressions, 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.