Oracle Database 12c: Analytic SQL for Data Warehousing (D79991)

Oracle Database 12c: Analytic SQL for Data Warehousing (D79991)

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
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
N/A
  • 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
Course ID:
D79991


Show Schedule for: