Oracle Database: Analytic SQL for Data Warehousing Ed 1


Oracle Database: Analytic SQL for Data Warehousing Ed 1 Certification Training Course Overview

Enroll for the 2-day Oracle Database: Analytic SQL for Data Warehousing Ed 1 from Koenig Solutions accredited by Oracle. In this course will learn 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.

Through a blend of hands-on labs and interactive lectures you will also learn:

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

Target Audience:

  • Administrator
  • Analyst
  • Architect
  • Developer

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

 


Oracle Database: Analytic SQL for Data Warehousing Ed 1 (16 Hours) Download Course Contents

Live Virtual Classroom (Instructor-Led)

Fee : On Request
9 AM - 5 PM (Flexible Time Slots for 4 hours option)




May
8 Hours/Day
03-04
09-10
10-11
17-18
03-06
09-12
10-13
17-20
June
8 Hours/Day
07-08
13-14
14-15
21-22
07-10
13-16
14-17
21-24
July
8 Hours/Day
05-06
11-12
12-13
05-08
11-14
12-15
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Request More Information

Course Prerequisites

Suggested Prerequisite:

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

Required Prerequisite:

  • Oracle Database 11g: Data Warehousing Fundamentals Ed 1
  • 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