Overview
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.
Skills Covered
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
Who Should Attend
- Application Developers
- Database Designers
- Support Engineer
- Data Warehouse Analyst
- Data Warehouse Developer
Course Curriculum
Prerequisites
- 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
Course Modules
Exam & Certification
This course is not associated with any Certification.
