This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze, report and model data. Interact with expert Oracle University instructors. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.
1 Introduction
2 Using SQL to Group and Aggregate Data
3 Hierarchical Retrieval
4 Working with Regular Expressions
5 Analyzing and Reporting Data by Using SQL
6 Analytic Views
7 Performing Pivoting and Unpivoting Operations
8 Pattern Matching Using SQL
9 Modeling Data by Using SQL
A Table Descriptions
B Using SQL Developer
C Using SQL*Plus
D Manipulating Large Data Sets
E Densifying Data and Performing Time Period Comparison
F General Reference