Oracle Database: Analytic SQL for Data Warehousing Ed 1
Course code
D105108GC10
Duration
3 Days, 24 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
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.
Objectives
Prerequisites
Course Outline
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
Request the training
Oracle Database: Analytic SQL for Data Warehousing Ed 1
Course code:
D105108GC10
Duration:
3 Days, 24 Acad. Hours
