Programm

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You'll also learn to use regular expressions and sub-expressions to search for, match, and replace strings.

Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:

Aggregat Operationen,
ROLLUP, CUBE und GROUPING,
LAG/LEAD,
PIVOT und UNPIVOT
die MODEL Klausel
PARTITION BY und Windowing Kalsuel
BUCKET_WIDTH
und viele andere

Ziele

Introduction
Grouping and Aggregating Data Using SQL
Hierarchical Retrieval
Working with Regular Expressions
Analyzing and Reporting Data Using SQL
Performing Pivoting and Unpivoting Operations
Pattern Matching using SQL
Modeling Data Using SQL

Voraussetzungen

Für dieses Seminar werden folgende Kenntnisse empfohlen:

Data Warehouse design, implementation, and maintenance experience
Good working knowledge of the SQL language
Familiarity with Oracle SQL Developer and SQL*Plus
Familiarity with SQL
Oracle Database 11g: Data Warehousing Fundamentals

#Oracle #Datenbanken