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 exam can be taken from home.

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 : USD 700 (Includes Taxes) 



July
8 Hours/Day
12-13
13-14
20-21
12-15
13-16
20-23
August
8 Hours/Day
03-04
09-10
10-11
17-18
03-06
09-12
10-13
17-20
September
8 Hours/Day
07-08
13-14
14-15
21-22
07-10
13-16
14-17
21-24
October
8 Hours/Day
05-06
05-08
Fly-Me-a-Trainer
Duration : 2 Days
Fee : On Request
Client's Location
As per mutual convenience
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : 2 Days
Fee : On Request
On Request

Enquire Now




Input symbols

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