Analytic SQL Training Training In Chennai Adyar With Placement - Greens Technology

Sponsored Ads

Price: Check with seller

Oracle Analytic SQL for Data Warehousing Training Course ContentsIntroductionCourse Objectives, Course Agenda and Class ...

  • Category: Language Classes
  • Published: 30/10/2014
  • Current Rating: /5 0 Vote


    Oracle Analytic SQL for Data Warehousing Training Course Contents


    • Course Objectives, Course Agenda and Class Account Information

    • Describe the Schemas and Appendices used in the Lesson

    • Overview of SQL*Plus Environment

    • Overview of SQL Developer

    • Overview of Analytic SQL

    • Oracle Database SQL and Data Warehousing Documentation

    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

    Related Ads

    Leave your comment

    Copyright © 2017 |   All Rights Reserved | |   24x7 support |   Email us: query[at]