Advanced SQL Queries in Oracle and SQL Server

This course is an overview of recent additions to the SQL language: Analytic Functions, extensions to GROUP BY, the WITH Clause, the PIVOT and UNPIVOT Features, the MERGE Statement and, more.

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 Subquery Factoring Clause/SQL Server's Common Table Expressions), the PIVOT and UNPIVOT Features, the MERGE Statement and, finally, the PARTITION BY/RIGHT OUTER JOIN syntax.

• Analytic Functions - Part 1 25mins
• Analytic Functions - Part 2 25mins
• Analytic Functions - Part 3 27mins
• Analytic Functions - Part 4 30mins
• Extensions to GROUP BY 36mins
• The WITH Clause - Part 1 11mins
• The WITH Clause - Part 2 45mins
• The PIVOT and UNPIVOT Features 29mins
• The MERGE Statement 17mins
• PARTITION BY/RIGHT OUTER JOIN 16mins