Oracle Database: Analytic SQL for Data Warehousing

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

Prerequisites

• 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)

Audience

• 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

Topics

• 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