Description

In this course, you will :

• 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.