Home > Vendors > Red-Hat > JB183

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

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

Audience

Who Should Attend

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

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

N/A

Schedule

Course ID:

D79991

Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.

First Name*

Last Name *

E-mail address *

Phone No*

Company

Enter your message*

Have an Account ?

Need an Account ?