Oracle Database 12c: Analytic SQL for Data Warehousing

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. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.


  • Database Designers
  • Data Warehouse-Analysts

Erforderliche Vorkenntnisse

  • Familiarity with SQL
  • Data Warehouse design, implementation, and maintenance experience
  • Good working knowledge of the SQL language
  • Familiarity with Oracle SQL Developer and SQL*Plus


  • 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
  • Oracle Business Intelligence Cloud Service Overview
  • 1. Tag 10.00 - 17.00 Uhr,
    Folgetage 09.00 - 17.00 Uhr
  • 2 Tage
  • Durchführungsgarantie
  • D79991GC10
  • Oracle Technologien
  • Languages
  • Oracle
  • 1.422 € pro Teilnehmer