Oracle Database 12c: Analytic SQL for Data Warehousing


Oracle Database 12c: Analytic SQL for Data Warehousing Certification Training Course Overview

Oracle Database 12c: Analytic SQL for Data Warehousing training course is designed to learn about Oracle Business Intelligence Cloud Service and how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. In this training class, you will also learn how to use regular expressions and sub-expressions to search for, match, and replace strings.

Target Audience:

  • Administrator
  • Analyst
  • Architect
  • Developer

Oracle Database 12c: Analytic SQL for Data Warehousing (16 Hours) Download Course Contents

Course Details Schedule
Live Virtual Classroom (Instructor-Led)
Duration : 2 Days (4 Days for 4 Hours/Day)
Fee : 2,100 (Includes Taxes) 
9 AM - 5 PM (Flexible Time Slots for 4 hours option)






February
8 Hours/Day
01-02
07-08
08-09
01-04
07-10
08-11
March
8 Hours/Day
01-02
07-08
08-09
01-04
07-10
08-11
April
8 Hours/Day
05-06
11-12
12-13
19-20
05-08
11-14
12-15
19-22
Client's Location
As per mutual convenience

Classroom training is available in select Cities

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
  • Basic Computer Knowledge.

  • 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