MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Advanced SQL Queries in Oracle and SQL Server

Course Summary

This course provides an overview of the recent additions to the SQL language that have been added over the last few years, but that may have slipped under your radar. We will describe Analytic Functions, extensions to GROUP BY, the WITH Clause (Oracle's S


  • +

    Course Syllabus

    ● Analytic Functions - Part 1
        ◦ Course Introduction
        ◦ Introduction to Part I
        ◦ What are Analytic Functions?
        ◦ Motivational Examples
        ◦ PARTITION BY Clause
        ◦ PARTITION BY Examples
        ◦ RATIO_TO_REPORT Function
        ◦ Summary
    ● Analytic Functions - Part 2
        ◦ Introduction to Part II
        ◦ ORDER BY Clause
        ◦ ROW_NUMBER Function
        ◦ LISTAGG Function
        ◦ LEAD and LAG Functions
        ◦ LEAD and LAG Examples 1
        ◦ LEAD and LAG Examples 2
        ◦ RANK and DENSE_RANK Functions
        ◦ FIRST_VALUE and LAST_VALUE Functions
        ◦ Summary
    ● Analytic Functions - Part 3
        ◦ Introduction to Part III
        ◦ Window Clause
        ◦ Window Clause Syntax
        ◦ Window Clause Examples 1
        ◦ Window Clause Examples 2
        ◦ NTH_VALUE Function
        ◦ NTH_VALUE Examples
        ◦ Summary
    ● Analytic Functions - Part 4
        ◦ Introduction to Part IV
        ◦ KEEP Clause
        ◦ KEEP Clause Examples
        ◦ Statistics-Related Analytic Functions
        ◦ MEDIAN Function and Examples
        ◦ NTILE Function and Examples
        ◦ CUME_DIST Function and Examples
        ◦ PERCENT_RANK Function and Examples
        ◦ PERCENTILE_DISC Function and Examples
        ◦ PERCENTILE_CONT Function and Examples
        ◦ Summary
        ◦ Extensions to GROUP BY
        ◦ Introduction
        ◦ A Comment about SQL Server 2005
        ◦ A Warning about Temporary Space
        ◦ Motivational Example
        ◦ GROUPING SETS
        ◦ ROLLUP
        ◦ CUBE
        ◦ Composite Columns
        ◦ Using Multiple Extensions
        ◦ GROUPING Function
        ◦ GROUPING_ID Function
        ◦ GROUP_ID Function
        ◦ Summary
    ● The WITH Clause - Part 1
        ◦ Introduction to Part I
        ◦ Non-Recursive WITH Clause
        ◦ Non-Recursive WITH Syntax
       ◦ CREATE TABLE and The WITH Clause
        ◦ Using Previously Defined WITH Clauses
        ◦ Summary
    ● The WITH Clause - Part 2
        ◦ Introduction to Part II
        ◦ Recursive WITH Clause
        ◦ Anchor and Recursive Queries
        ◦ Recursive WITH Example #1
        ◦ Recursive WITH Example #2
        ◦ Recursive WITH Example #3
        ◦ MAXRECURSION Option
        ◦ SEARCH and SET Options
        ◦ Cycle Option and Summary
    ● The PIVOT and UNPIVOT Features
        ◦ Introduction
        ◦ Vintage Data Transposition Introduct


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top