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.