Advanced SQL Queries in Oracle and SQL Server | 8E899EF75E44ED3D3389EE97D33AF42905BD889B

Advanced SQL Queries in Oracle and SQL Server

Name	Advanced SQL Queries in Oracle and SQL Server	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	496.9 MB
Total Files	90
Hash	8E899EF75E44ED3D3389EE97D33AF42905BD889B

/01.Analytic Functions - Part 1/
01.Course Introduction.wmv	4.3 MB
02.Introduction to Part I.wmv	1.6 MB
03.What are Analytic Functions.wmv	8.4 MB
04.Motivational Examples.wmv	11.4 MB
05.PARTITION BY Clause.wmv	2.8 MB
06.PARTITION BY Examples.wmv	9.8 MB
07.RATIO_TO_REPORT Function.wmv	6.6 MB
08.Summary.wmv	750.6 KB
/02.Analytic Functions - Part 2/
01.Introduction to Part II.wmv	1.5 MB
02.ORDER BY Clause.wmv	3.3 MB
03.ROW_NUMBER Function.wmv	5.1 MB
04.LISTAGG Function.wmv	6.4 MB
05.LEAD and LAG Functions.wmv	5.4 MB
06.LEAD and LAG Examples 1.wmv	6.3 MB
07.LEAD and LAG Examples 2.wmv	5.5 MB
08.RANK and DENSE_RANK Functions.wmv	7.2 MB
09.FIRST_VALUE and LAST_VALUE Functions.wmv	6.5 MB
10.Summary.wmv	600.5 KB
/03.Analytic Functions - Part 3/
01.Introduction to Part III.wmv	1.6 MB
02.Window Clause.wmv	11.2 MB
03.Window Clause Syntax.wmv	15.6 MB
04.Window Clause Examples 1.wmv	4.2 MB
05.Window Clause Examples 2.wmv	10.0 MB
06.NTH_VALUE Function.wmv	3.6 MB
07.NTH_VALUE Examples.wmv	4.7 MB
08.Summary.wmv	762.8 KB
/04.Analytic Functions - Part 4/
01.Introduction to Part IV.wmv	1.8 MB
02.KEEP Clause.wmv	8.5 MB
03.KEEP Clause Examples.wmv	8.3 MB
04.Statistics-Related Analytic Functions.wmv	5.0 MB
05.MEDIAN Function and Examples.wmv	2.7 MB
06.NTILE Function and Examples.wmv	7.4 MB
07.CUME_DIST Function and Examples.wmv	5.8 MB
08.PERCENT_RANK Function and Examples.wmv	4.5 MB
09.PERCENTILE_DISC Function and Examples.wmv	6.6 MB
10.PERCENTILE_CONT Function and Examples.wmv	4.6 MB
11.Summary.wmv	375.2 KB
/05.Extensions to GROUP BY/
01.Introduction.wmv	6.6 MB
02.A Comment about SQL Server 2005.wmv	2.1 MB
03.A Warning about Temporary Space.wmv	4.1 MB
04.Motivational Example.wmv	7.0 MB
05.GROUPING SETS.wmv	6.2 MB
06.ROLLUP.wmv	7.8 MB
07.CUBE.wmv	5.3 MB
08.Composite Columns.wmv	4.0 MB
09.Using Multiple Extensions.wmv	5.8 MB
10.GROUPING Function.wmv	8.6 MB
11.GROUPING_ID Function.wmv	5.7 MB
12.GROUP_ID Function.wmv	5.5 MB
13.Summary.wmv	1.2 MB
/06.The WITH Clause - Part 1/
01.Introduction to Part I.wmv	3.3 MB
02.Non-Recursive WITH Clause.wmv	11.1 MB
03.Non-Recursive WITH Syntax.wmv	2.3 MB
04.CREATE TABLE and The WITH Clause.wmv	1.2 MB
05.Using Previously Defined WITH Clauses.wmv	4.5 MB
06.Summary.wmv	498.4 KB
/07.The WITH Clause - Part 2/
01.Introduction to Part II.wmv	6.7 MB
02.Recursive WITH Clause.wmv	14.0 MB
03.Anchor and Recursive Queries.wmv	8.3 MB
04.Recursive WITH Example #1.wmv	15.9 MB
05.Recursive WITH Example #2.wmv	10.1 MB
06.Recursive WITH Example #3.wmv	7.2 MB
07.MAXRECURSION Option.wmv	2.8 MB
08.SEARCH and SET Options.wmv	10.2 MB
09.Cycle Option and Summary.wmv	7.1 MB
/08.The PIVOT and UNPIVOT Features/
01.Introduction.wmv	3.6 MB
02.Vintage Data Transposition Introduction.wmv	904.0 KB
03.Vintage Data Transposition Columns to Rows.wmv	9.8 MB
04.Vintage Data Transposition Rows to Columns.wmv	4.8 MB
05.Modern Data Transposition Introduction.wmv	777.8 KB
06.Modern Data Transposition Columns to Rows.wmv	13.6 MB
07.Modern Data Transposition Rows to Columns.wmv	8.5 MB
08.Oracle-Specific Extensions.wmv	3.6 MB
09.Multi-Column PIVOT Introduction.wmv	1.9 MB
10.Oracle Extension to IN Function.wmv	4.6 MB
11.Multi-Column PIVOT Examples.wmv	3.9 MB
12.Summary.wmv	375.2 KB
/09.The MERGE Statement/
01.Introduction.wmv	9.1 MB
02.Reminder of Old Friends.wmv	4.3 MB
03.Life without The MERGE Statement.wmv	2.0 MB
04.MERGE Syntax.wmv	6.7 MB
05.MERGE Example.wmv	4.2 MB
06.Additional Conditions.wmv	2.7 MB
07.DELETE and Summary.wmv	4.6 MB
/10.PARTITION BY-RIGHT OUTER JOIN/
01.Introduction.wmv	8.8 MB
02.Why Joins Won't Work.wmv	4.6 MB
03.Tried and True Method.wmv	4.5 MB
04.Syntax.wmv	3.5 MB
05.Examples and Summary.wmv	7.0 MB
/
adv-sql-queries-oracle-sql-server.zip	3.1 MB
Total files 90