Oracle Database 12c: Analytic SQL for Data Warehousing/D79991GC10


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 Course schedule & Prices

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








Client's Location
As per mutual convenience
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients. Click here

Get Quote

Course Prerequisites
  • No formal pre-requisites for this course.

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