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

Instructor - Led Online Training Fee For Both Group Training & 1-on-1 Training 2300
Group Training

19,20 Apr
09:00 AM - 05:00 PM CST
(8 Hours/Day)

03,04 May
09:00 AM - 05:00 PM CST
(8 Hours/Day)

07,08 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)

GTR=Guaranteed to Run
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End


Available

Not Available

Booked By You

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