When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Advanced SQL Queries in Oracle and SQL Server
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.
This Course Includes
pluralsight
4 (595 reviews )
4 hour 25 minutes 
english
Online - Self Paced
core courses
pluralsight
About Advanced SQL Queries in Oracle and SQL Server
This Oracle advanced SQL 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 BYThe 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.If you aren't familiar with Oracle or Oracle databases, you may want to take this course beforehand.
What You Will Learn?
- 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.