- Course
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.
Intermediate
- Course
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
Advanced SQL Queries in Oracle and SQL Server
Intermediate
Table of contents
-
Introduction to Part II | 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
-
FIRST_VALUE and LAST_VALUE Functions | 3m 28s
-
Summary | 20s
Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!