Oracle Database: Analytic SQL for Data Warehousing Ed 1

Enroll for the 2-day Oracle Database: Analytic SQL for Data Warehousing Ed 1 from Koenig Solutions accredited by Oracle. In this course will learn how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You'll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.

Through a blend of hands-on labs and interactive lectures you will also learn:

• Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
• Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
• Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
• Perform advanced pattern matching.
• Use regular expressions to search for, match and replace strings.
• Gain an understanding of the Oracle Business Intelligence Cloud Service.

Target Audience:

• Administrator
• Analyst
• Architect
• Developer

Learning Objectives:

• 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