Oracle Database: Analytic SQL for Data Warehousing



Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates3$3,600 USDPurchase


Oracle Database: Analytic SQL for Data Warehousing

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze, report and model data. Be introduced to Oracle Business Intelligence Cloud Service.

Duration: 3 Days


  • Experience with data warehouse design, implementation, and maintenance
  • Familiarity with SQL
  • Good working knowledge of the SQL language
  • Familiarity with Oracle SQL Developer and SQL*Plus
  • Oracle Database 11g: Data Warehousing Fundamentals Ed 1
  • Conceptual experience designing data warehouses (suggested)
  • Practical experience implementing data warehouses (suggested)
  • Good understanding of relational technology (suggested)
  • Oracle Database 11g: Administer a Data Warehouse Ed 2 (suggested)
  • Oracle Database 12c: Introduction for Experienced SQL Users Ed 1 (suggested)
  • Using Java - for PL/SQL and Database Developers Ed 1 (suggested)


  • Administrators
  • Analysts
  • Architects
  • Developers

Learning Objectives

  • Group and aggregate data using the ROLLUP and CUBE operators
  • Analyze and report data using Ranking, LAG/LEAD, and FIRST/LAST functions
  • Use the MODEL clause to create a multidimensional array from query results
  • Use Analytic SQL to aggregate, analyze and report, and model data
  • Interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure
  • Gain an understanding of the Oracle Business Intelligence Cloud Service
  • Use regular expressions to search for, match, and replace strings
  • Perform pattern matching using the MATCH_RECOGNIZE clause


  • Using SQL to Group and Aggregate Data
  • Hierarchal Retrieval
  • Working with Regular Expressions
  • Analyzing and Reporting Data by Using SQL
  • Analytic Views
  • Performing Pivoting and Unpivoting Operations
  • Pattern Matching Using SQL
  • Modeling Data Using SQL
Right Menu IconMENU