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 details recent additions to the standard SQL language and includes topics such as Analytic Functions and Extensions to GROUP BY, to name a few.


  • +

    Course Syllabus

    Analytic Functions - Part 1
    - 25m 22s

    —Course Introduction 2m 41s
    —Introduction to Part I 0m 49s
    —What are Analytic Functions? 4m 56s
    —Motivational Examples 6m 12s
    —PARTITION BY Clause 1m 39s
    —PARTITION BY Examples 5m 9s
    —RATIO_TO_REPORT Function 3m 30s
    —Summary 0m 26s
    Analytic Functions - Part 2
    - 25m 58s

    —Introduction to Part II 0m 45s
    —ORDER BY Clause 1m 54s
    —ROW_NUMBER Function 2m 39s
    —LISTAGG Function 3m 25s
    —LEAD and LAG Functions 3m 4s
    —LEAD and LAG Examples 1 3m 26s
    —LEAD and LAG Examples 2 2m 57s
    —RANK and DENSE_RANK Functions 4m 0s
    —FIRST_VALUE and LAST_VALUE Functions 3m 28s
    —Summary 0m 20s
    Analytic Functions - Part 3
    - 27m 12s
    Analytic Functions - Part 4
    - 30m 7s
    Extensions to GROUP BY
    - 36m 18s
    The WITH Clause - Part 1
    - 11m 52s
    The WITH Clause - Part 2
    - 45m 39s
    The PIVOT and UNPIVOT Features
    - 29m 22s
    The MERGE Statement
    - 17m 56s
    PARTITION BY/RIGHT OUTER JOIN
    - 16m 1s


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