HONE YOUR SKILLS AND UPGRADE YOUR STATUS AND INCOME. EARN MINIMUM £30K WITH  YOUR DATA WAREHOUSING AND  ANALYTICS SKILLS.

VERY GOOD HANDS-ON INTERACTIVE TRAINING MATERIAL WITH REAL-LIFE BASED SCENARIOS. PACKED WITH TASKS, ACTIVITIES AND EXERCISES.

PERFECT INTERACTIVE SELF-TEACH TRAINING COURSE FOR THOSE WORKING IN A DATA WAREHOUSING, ANALYTICS,  AND BUSINESS INTELLIGENCE ENVIRONMENT AS WELL AS THOSE WHO WORK IN TRADITIONAL BUSINESS REPORTING BUT LOOKING TO UPSKILL TO AN ANALYTICS PLATFORM. ALSO GOOD FOR THOSE COMPLETELY NEW  TO  DATA  WAREHOUSING,  ANALYTICS OR WISH TO CROSS-TRAIN TO A DATA WAREHOUSING AND ANALYTICS ENVIRONMENT.


Oracle Database 21c: Analytic SQL for Data Warehousing Self-Study CBT

How This Course Is Organised

This Oracle Database 21c: 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.



Audience:
Application Developers
Data Warehouse Analyst
Data Warehouse Developer
Database Administrators
Database Designers
Support Engineer



Prerequisites
Data Warehouse design, implementation, and maintenance experience
Familiarity with Oracle SQL Developer and SQL*Plus
Familiarity with SQL
Good working knowledge of the SQL language
Oracle Data Warehousing Fundamentals
Oracle Database: Introduction to SQL



Objectives:
After completing this course, students will be able to:

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
Use regular expressions to search for, match, and replace strings
Perform pattern matching using the MATCH_RECOGNIZE clause



Course Outline

Introduction

Overview of Oracle Database 21c
Overview of SQL*Plus Environment
Overview of SQL Developer
Overview of Analytic SQL
Overview of Business Intelligence
Oracle Information Reference Architecture
Overview of Oracle Data Warehouse Reference Architecture

Introduction to Oracle Advanced Analytics Tools
Introducing Oracle Database 21c
Introducing Oracle Data Miner
Introducing Oracle R Enterprise
Oracle Machine Learning for R (OML4R)
Introducing Oracle Big Data SQL

Analytics and Warehouse Architecture Framework
Data Sources
Data Access, Transformation, Cleansing
Staged Data
Business Subject Data
Multidimensional Data
Backup, Archive Data
Structured Query Language and OLAP Engine
Business Intelligence Applications
Administration, Automation, Operation, Control
Metadata Repository
Visualisation and Publishing

Grouping and Aggregating Data Using SQL
Generating Reports by Grouping Related Data
Review of Group Functions
Reviewing GROUP BY and HAVING Clause
Using the ROLLUP and CUBE Operators
Using the GROUPING Function
Working with GROUPING SET Operators and Composite Columns
Using Concatenated Groupings with Example

Hierarchical Retrieval
Using Hierarchical Queries
Sample Data from the EMPLOYEES Table
Natural Tree Structure
Hierarchical Queries: Syntax
Walking the Tree: Specifying the Starting Point
Walking the Tree: Specifying the Direction of the Query
Using the WITH Clause
Hierarchical Query Example: Using the CONNECT BY Clause

Working with Regular Expressions
Introducing Regular Expressions
Using the Regular Expressions Functions and Conditions in SQL and PL/SQL
Introducing Metacharacters
Using Metacharacters with Regular Expressions
Regular Expressions Functions and Conditions: Syntax
Performing a Basic Search Using the REGEXP_LIKE Condition
Finding Patterns Using the REGEXP_INSTR Function
Extracting Substrings Using the REGEXP_SUBSTR Function

Analyzing and Reporting Data Using SQL
Overview of SQL for Analysis and Reporting Functions
Using Analytic Functions
Using the Ranking Functions
Using Reporting Functions

Performing Pivoting and Unpivoting Operations
Performing Pivoting Operations
Using the PIVOT and UNPIVOT Clauses
Pivoting on the QUARTER Column: Conceptual Example
Performing Unpivoting Operations
Using the UNPIVOT Clause Columns in an UNPIVOT Operation
Creating a New Pivot Table: Example

Pattern Matching using SQL
Row Pattern Navigation Operations
Handling Empty Matches or Unmatched Rows
Excluding Portions of the Pattern from the Output
Expressing All Permutations
Rules and Restrictions in Pattern Matching
Examples of Pattern Matching

Modeling Data Using SQL
Using the MODEL clause
Demonstrating Cell and Range References
Using the CV Function
Using FOR Construct with IN List Operator, incremental values and Subqueries
Using Analytic Functions in the SQL MODEL Clause
Distinguishing Missing Cells from NULLs
Using the UPDATE, UPSERT and UPSERT ALL Options
Reference Models


NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY TRAINING GUIDE OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE EARNING  FORMATS. PRICES DIFFER 


What is Computer Based Training - CBT?

Computer Based Training - CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice..


Generally, CBT's tend to be more expensive. WebLearning CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT Learning formats are delivered with FULL LICENCE KEY.


Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.


CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.


The WebLearning unique Methodology

All WebLearning®  courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning.



 

FACT:

  • · Material retention with CBT's are 45% better than with conventional training method
  • · Your learning curve with CBT is 25%-55% less than conventional method
  • · The cost of CBT training is over 75% less than Classroom training
  • · CBT’S are self pacing and Interactive
  • · CBT’S simulate the actual software being studied so there is no need to have the actual software installed 


TRY WEBLEARNING E-LEARNING DEMOS TODAY:: CLICK HERE

LOOKING FOR A TRAINING GUIDE DEMO? THEN CLICK HERE

LOOKING FOR A CBT DEMO? THEN CLICK HERE