Oracle Database: Analytic SQL for Data Warehousing Ed 1

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