Oracle Database 11g: Analytic SQL For Data Warehousing

Product Description

In this course students use Analytic SQL to aggregate, analyze & report, & model data. Students learn to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, & exclude branches from the tree structure. Students also learn to use regular expressions & subexpressions to search for, match, & replace strings.

Before attending this course, students should be familiar with relational database concepts, data warehouse theory & implementation, Oracle server concepts including application & server tuning, & the operating system environment on which the Oracle Database Server is running. Students use Oracle SQL Developer to develop these program units. SQL* Plus & JDeveloper are introduced as optional tools.

This course is intended for data warehouse builders & implementers, database administrators, system administrators, & database application developers who design, maintain, & use data warehouses.

Learn to:

• Use Analytic SQL to aggregation, Analyze & Reporting, & Model Data
• Group & aggregate data using the ROLLUP & CUBE operators
• Analyze & report data using Ranking, LAG/LEAD, & FIRST/LAST functions
• Use the MODEL clause to create a multidimensional array from query results
• Interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, & exclude branches from the tree structure
• Use regular expressions to search for, match, & replace strings

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.