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

This course is included in our On-demand training solution.

Overview

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

120 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?