Oracle APPS Functional online training course content:

Oracle Database 11g: Analytic SQL for Data Warehousing Content Details

Introduction

Course Objectives

Grouping and Aggregating Data Using SQL

 What is Analytic SQL?

Analyzing and Reporting Data Using SQL

Overview of SQL for Analysis and Reporting Functions

Modeling Data Using SQL

Overview of SQL for Modeling Data

Hierarchical Retrieval

Hierarchical Retrieval: Overview

Analyzing Data Using Regular Expressions

Using the Regular Expressions Functions and Conditions in SQL