This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you 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.

Learn To:

• 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.

• 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