D79991 - Oracle Database 12c: Analytic SQL for Data Warehousing

Overview

Duration: 2 days

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.

Learn To:

Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
Perform advanced pattern matching.
Use regular expressions to search for, match and replace strings.
Gain an understanding of the Oracle Business Intelligence Cloud Service.

Objectives

Upon completing this course, the learner will be able to meet these overall 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 aggregation, Analyze and Reporting, 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

Audience

Application Developers
Database Designers
Support Engineer
Data Warehouse Analyst
Data Warehouse Developer

Content

Module 1: Introduction
Module 2: Grouping and Aggregating Data Using SQL
Module 3: Hierarchical Retrieval
Module 4: Working with Regular Expressions
Module 5: Analyzing and Reporting Data Using SQL
Module 6: Performing Pivoting and Unpivoting Operations
Module 7: Pattern Matching using SQL
Module 8: Modeling Data Using SQL
Module 9: Oracle Business Intelligence Cloud Service Overview

Prerequisites

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
Oracle Database 11g: Data Warehousing Fundamentals
Oracle Database: Introduction to SQL Ed 2

Suggested Prerequisites:

Conceptual experience designing data warehouses
Practical experience implementing data warehouses
Good understanding of relational technology
Oracle Database 11g: Administer a Data Warehouse
Oracle Database 12c: Introduction for Experienced SQL Users
Using Java – for PL/SQL and Database Developers

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: