Buy and Download - Pluralsight Advanced SQL Queries in Oracle and SQL Server

2013
Pluralsight
Scott Hecht
4h 25m
English

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

FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Course Introduction 4.10 MB 0:02:41 128kbps 164.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
02.Introduction to Part I 1.55 MB 0:00:48 128kbps 159.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
03.What are Analytic Functions 7.97 MB 0:04:55 128kbps 141.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
04.Motivational Examples 10.8 MB 0:06:11 128kbps 186.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
05.PARTITION BY Clause 2.65 MB 0:01:38 128kbps 111.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
06.PARTITION BY Examples 9.34 MB 0:05:09 128kbps 236.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
07.RATIO_TO_REPORT Function 6.24 MB 0:03:29 128kbps 178.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
08.Summary 733 KB 0:00:25 128kbps 44.00 1024x768 15 frames/second 01.Analytic Functions - Part 1
01.Introduction to Part II 1.45 MB 0:00:45 128kbps 161.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
02.ORDER BY Clause 3.19 MB 0:01:53 128kbps 135.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
03.ROW_NUMBER Function 4.85 MB 0:02:38 128kbps 220.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
04.LISTAGG Function 6.08 MB 0:03:25 128kbps 235.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
05.LEAD and LAG Functions 5.12 MB 0:03:03 128kbps 146.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
06.LEAD and LAG Examples 1 5.96 MB 0:03:26 128kbps 141.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
07.LEAD and LAG Examples 2 5.20 MB 0:02:57 128kbps 161.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
08.RANK and DENSE_RANK Functions 6.89 MB 0:04:00 128kbps 180.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
09.FIRST_VALUE and LAST_VALUE Functions 6.17 MB 0:03:27 128kbps 280.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
10.Summary 586 KB 0:00:20 128kbps 60.00 1024x768 15 frames/second 02.Analytic Functions - Part 2
01.Introduction to Part III 1.56 MB 0:00:49 128kbps 159.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
02.Window Clause 10.6 MB 0:06:01 128kbps 292.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
03.Window Clause Syntax 14.8 MB 0:08:03 128kbps 301.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
04.Window Clause Examples 1 3.99 MB 0:02:18 128kbps 148.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
05.Window Clause Examples 2 9.51 MB 0:05:20 128kbps 185.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
06.NTH_VALUE Function 3.39 MB 0:01:54 128kbps 169.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
07.NTH_VALUE Examples 4.44 MB 0:02:20 128kbps 283.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
08.Summary 744 KB 0:00:25 128kbps 57.00 1024x768 15 frames/second 03.Analytic Functions - Part 3
01.Introduction to Part IV 1.76 MB 0:00:54 128kbps 155.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
02.KEEP Clause 8.14 MB 0:04:52 128kbps 147.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
03.KEEP Clause Examples 7.94 MB 0:04:08 128kbps 290.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
04.Statistics-Related Analytic Functions 4.76 MB 0:02:46 128kbps 152.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
05.MEDIAN Function and Examples 2.60 MB 0:01:25 128kbps 186.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
06.NTILE Function and Examples 7.07 MB 0:04:06 128kbps 227.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
07.CUME_DIST Function and Examples 5.50 MB 0:03:19 128kbps 167.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
08.PERCENT_RANK Function and Examples 4.26 MB 0:02:23 128kbps 222.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
09.PERCENTILE_DISC Function and Examples 6.25 MB 0:03:31 128kbps 207.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
10.PERCENTILE_CONT Function and Examples 4.37 MB 0:02:26 128kbps 286.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
11.Summary 366 KB 0:00:12 128kbps 42.00 1024x768 15 frames/second 04.Analytic Functions - Part 4
01.Introduction 6.33 MB 0:03:20 128kbps 422.00 1024x768 15 frames/second 05.Extensions to GROUP BY
02.A Comment about SQL Server 2005 1.96 MB 0:01:03 128kbps 194.00 1024x768 15 frames/second 05.Extensions to GROUP BY
03.A Warning about Temporary Space 3.87 MB 0:02:14 128kbps 179.00 1024x768 15 frames/second 05.Extensions to GROUP BY
04.Motivational Example 6.68 MB 0:02:56 128kbps 419.00 1024x768 15 frames/second 05.Extensions to GROUP BY
05.GROUPING SETS 5.94 MB 0:03:16 128kbps 351.00 1024x768 15 frames/second 05.Extensions to GROUP BY
06.ROLLUP 7.40 MB 0:03:59 128kbps 303.00 1024x768 15 frames/second 05.Extensions to GROUP BY
07.CUBE 5.03 MB 0:02:40 128kbps 329.00 1024x768 15 frames/second 05.Extensions to GROUP BY
08.Composite Columns 3.79 MB 0:02:14 128kbps 192.00 1024x768 15 frames/second 05.Extensions to GROUP BY
09.Using Multiple Extensions 5.54 MB 0:02:50 128kbps 472.00 1024x768 15 frames/second 05.Extensions to GROUP BY
10.GROUPING Function 8.17 MB 0:04:51 128kbps 304.00 1024x768 15 frames/second 05.Extensions to GROUP BY
11.GROUPING_ID Function 5.40 MB 0:03:04 128kbps 224.00 1024x768 15 frames/second 05.Extensions to GROUP BY
12.GROUP_ID Function 5.25 MB 0:03:01 128kbps 214.00 1024x768 15 frames/second 05.Extensions to GROUP BY
13.Summary 1.14 MB 0:00:41 128kbps 72.00 1024x768 15 frames/second 05.Extensions to GROUP BY
01.Introduction to Part I 3.16 MB 0:01:44 128kbps 176.00 1024x768 15 frames/second 06.The WITH Clause - Part 1
02.Non-Recursive WITH Clause 10.6 MB 0:05:31 128kbps 493.00 1024x768 15 frames/second 06.The WITH Clause - Part 1
03.Non-Recursive WITH Syntax 2.21 MB 0:01:20 128kbps 85.00 1024x768 15 frames/second 06.The WITH Clause - Part 1
04.CREATE TABLE and The WITH Clause 1.15 MB 0:00:35 128kbps 202.00 1024x768 15 frames/second 06.The WITH Clause - Part 1
05.Using Previously Defined WITH Clauses 4.25 MB 0:02:22 128kbps 147.00 1024x768 15 frames/second 06.The WITH Clause - Part 1
06.Summary 486 KB 0:00:18 128kbps 32.00 1024x768 15 frames/second 06.The WITH Clause - Part 1
01.Introduction to Part II 6.40 MB 0:03:41 128kbps 177.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
02.Recursive WITH Clause 13.3 MB 0:07:43 128kbps 233.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
03.Anchor and Recursive Queries 7.94 MB 0:04:46 128kbps 143.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
04.Recursive WITH Example #1 15.2 MB 0:08:56 128kbps 269.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
05.Recursive WITH Example #2 9.67 MB 0:05:35 128kbps 197.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
06.Recursive WITH Example #3 6.85 MB 0:03:54 128kbps 172.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
07.MAXRECURSION Option 2.69 MB 0:01:30 128kbps 152.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
08.SEARCH and SET Options 9.74 MB 0:05:34 128kbps 261.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
09.Cycle Option and Summary 6.80 MB 0:03:55 128kbps 313.00 1024x768 15 frames/second 07.The WITH Clause - Part 2
01.Introduction 3.39 MB 0:01:33 128kbps 431.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
02.Vintage Data Transposition Introduction 882 KB 0:00:31 128kbps 60.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
03.Vintage Data Transposition Columns to Rows 9.30 MB 0:04:59 128kbps 263.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
04.Vintage Data Transposition Rows to Columns 4.58 MB 0:02:23 128kbps 228.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
05.Modern Data Transposition Introduction 759 KB 0:00:28 128kbps 45.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
06.Modern Data Transposition Columns to Rows 12.9 MB 0:07:11 128kbps 253.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
07.Modern Data Transposition Rows to Columns 8.07 MB 0:04:39 128kbps 197.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
08.Oracle-Specific Extensions 3.42 MB 0:01:43 128kbps 189.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
09.Multi-Column PIVOT Introduction 1.78 MB 0:01:00 128kbps 133.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
10.Oracle Extension to IN Function 4.40 MB 0:02:28 128kbps 181.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
11.Multi-Column PIVOT Examples 3.68 MB 0:02:05 128kbps 223.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
12.Summary 366 KB 0:00:13 128kbps 34.00 1024x768 15 frames/second 08.The PIVOT and UNPIVOT Features
01.Introduction 8.65 MB 0:04:47 128kbps 226.00 1024x768 15 frames/second 09.The MERGE Statement
02.Reminder of Old Friends 4.07 MB 0:02:26 128kbps 139.00 1024x768 15 frames/second 09.The MERGE Statement
03.Life without The MERGE Statement 1.91 MB 0:01:06 128kbps 126.00 1024x768 15 frames/second 09.The MERGE Statement
04.MERGE Syntax 6.34 MB 0:03:45 128kbps 241.00 1024x768 15 frames/second 09.The MERGE Statement
05.MERGE Example 3.96 MB 0:02:12 128kbps 320.00 1024x768 15 frames/second 09.The MERGE Statement
06.Additional Conditions 2.53 MB 0:01:14 128kbps 306.00 1024x768 15 frames/second 09.The MERGE Statement
07.DELETE and Summary 4.34 MB 0:02:24 128kbps 277.00 1024x768 15 frames/second 09.The MERGE Statement
01.Introduction 8.42 MB 0:05:05 128kbps 167.00 1024x768 15 frames/second 10.PARTITION BY-RIGHT OUTER JOIN
02.Why Joins Won't Work 4.38 MB 0:02:33 128kbps 144.00 1024x768 15 frames/second 10.PARTITION BY-RIGHT OUTER JOIN
03.Tried and True Method 4.27 MB 0:02:22 128kbps 250.00 1024x768 15 frames/second 10.PARTITION BY-RIGHT OUTER JOIN
04.Syntax 3.36 MB 0:02:02 128kbps 105.00 1024x768 15 frames/second 10.PARTITION BY-RIGHT OUTER JOIN
05.Examples and Summary 6.68 MB 0:03:57 128kbps 195.00 1024x768 15 frames/second 10.PARTITION BY-RIGHT OUTER JOIN