D79991 - Oracle Database 12c: Analytic SQL for Data Warehousing
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.
Upon completing this course, the learner will be able to meet these overall 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
- Application Developers
- Database Designers
- Support Engineer
- Data Warehouse Analyst
- Data Warehouse Developer
- Module 1: Introduction
- Module 2: Grouping and Aggregating Data Using SQL
- Module 3: Hierarchical Retrieval
- Module 4: Working with Regular Expressions
- Module 5: Analyzing and Reporting Data Using SQL
- Module 6: Performing Pivoting and Unpivoting Operations
- Module 7: Pattern Matching using SQL
- Module 8: Modeling Data Using SQL
- Module 9: Oracle Business Intelligence Cloud Service Overview
- 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
- Oracle Database 11g: Data Warehousing Fundamentals
- Oracle Database: Introduction to SQL Ed 2
Suggested Prerequisites:
- Conceptual experience designing data warehouses
- Practical experience implementing data warehouses
- Good understanding of relational technology
- Oracle Database 11g: Administer a Data Warehouse
- Oracle Database 12c: Introduction for Experienced SQL Users
- Using Java – for PL/SQL and Database Developers
This course is not associated with any Certification.