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.
Course info
Rating
(518)
Level
Intermediate
Updated
Oct 31, 2013
Duration
4h 25m
Table of contents
Analytic Functions - Part 1
Analytic Functions - Part 2
Analytic Functions - Part 3
Analytic Functions - Part 4
Extensions to GROUP BY
The WITH Clause - Part 1
The WITH Clause - Part 2
The PIVOT and UNPIVOT Features
The MERGE Statement
PARTITION BY/RIGHT OUTER JOIN
Description
Course info
Rating
(518)
Level
Intermediate
Updated
Oct 31, 2013
Duration
4h 25m
Description

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 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.
About the author
About the author

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!

More from the author
SQL Data Wrangling in Oracle: Table Data
Intermediate
5h 16m
Nov 27, 2014
Optimizing SQL Queries in Oracle
Intermediate
3h 45m
Apr 15, 2014
Introduction to Dates and Times in SQL Server
Intermediate
2h 58m
Jan 14, 2014
More courses by Scott Hecht