> > > D79991GC10

Analytic SQL for Data Warehousing (D79991GC10)

Описание Курса Даты и регистрация Содержание Курса
 

Course Overview

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze, report and model data. Interact with expert Oracle University instructors. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.

Кому следует посетить

  • Administrator
  • Analyst
  • Architect
  • Developer

Предварительные требования

  • 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

Цели курса

  • 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
Classroom training
Modality: C

Длительность 2 дня

Цена (без учета НДС)
  • Украина: 12 000,- грн.
Даты проведения
 
Для регистрации на курс нажмите на название города Даты и регистрация
Украина
10.05. - 11.05.2019 Київ гарантирован!