• 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

Prerequisiti obbligatori:

• 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

Prerequisiti suggeriti:

• 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