TorBT - Torrents and Magnet Links Search Engine

Advanced SQL Queries in Oracle and SQL Server

File Name
Size
01.Analytic Functions - Part 1/01.Course Introduction.wmv
4.1 MB
01.Analytic Functions - Part 1/02.Introduction to Part I.wmv
1.6 MB
01.Analytic Functions - Part 1/03.What are Analytic Functions.wmv
8.0 MB
01.Analytic Functions - Part 1/04.Motivational Examples.wmv
11 MB
01.Analytic Functions - Part 1/05.PARTITION BY Clause.wmv
2.7 MB
01.Analytic Functions - Part 1/06.PARTITION BY Examples.wmv
9.3 MB
01.Analytic Functions - Part 1/07.RATIO_TO_REPORT Function.wmv
6.2 MB
01.Analytic Functions - Part 1/08.Summary.wmv
733 kB
02.Analytic Functions - Part 2/01.Introduction to Part II.wmv
1.5 MB
02.Analytic Functions - Part 2/02.ORDER BY Clause.wmv
3.2 MB
02.Analytic Functions - Part 2/03.ROW_NUMBER Function.wmv
4.9 MB
02.Analytic Functions - Part 2/04.LISTAGG Function.wmv
6.1 MB
02.Analytic Functions - Part 2/05.LEAD and LAG Functions.wmv
5.1 MB
02.Analytic Functions - Part 2/06.LEAD and LAG Examples 1.wmv
6.0 MB
02.Analytic Functions - Part 2/07.LEAD and LAG Examples 2.wmv
5.2 MB
02.Analytic Functions - Part 2/08.RANK and DENSE_RANK Functions.wmv
6.9 MB
02.Analytic Functions - Part 2/09.FIRST_VALUE and LAST_VALUE Functions.wmv
6.2 MB
02.Analytic Functions - Part 2/10.Summary.wmv
586 kB
03.Analytic Functions - Part 3/01.Introduction to Part III.wmv
1.6 MB
03.Analytic Functions - Part 3/02.Window Clause.wmv
11 MB
03.Analytic Functions - Part 3/03.Window Clause Syntax.wmv
15 MB
03.Analytic Functions - Part 3/04.Window Clause Examples 1.wmv
4.0 MB
03.Analytic Functions - Part 3/05.Window Clause Examples 2.wmv
9.5 MB
03.Analytic Functions - Part 3/06.NTH_VALUE Function.wmv
3.4 MB
03.Analytic Functions - Part 3/07.NTH_VALUE Examples.wmv
4.4 MB
03.Analytic Functions - Part 3/08.Summary.wmv
745 kB
04.Analytic Functions - Part 4/01.Introduction to Part IV.wmv
1.8 MB
04.Analytic Functions - Part 4/02.KEEP Clause.wmv
8.1 MB
04.Analytic Functions - Part 4/03.KEEP Clause Examples.wmv
7.9 MB
04.Analytic Functions - Part 4/04.Statistics-Related Analytic Functions.wmv
4.8 MB
04.Analytic Functions - Part 4/05.MEDIAN Function and Examples.wmv
2.6 MB
04.Analytic Functions - Part 4/06.NTILE Function and Examples.wmv
7.1 MB
04.Analytic Functions - Part 4/07.CUME_DIST Function and Examples.wmv
5.5 MB
04.Analytic Functions - Part 4/08.PERCENT_RANK Function and Examples.wmv
4.3 MB
04.Analytic Functions - Part 4/09.PERCENTILE_DISC Function and Examples.wmv
6.3 MB
04.Analytic Functions - Part 4/10.PERCENTILE_CONT Function and Examples.wmv
4.4 MB
04.Analytic Functions - Part 4/11.Summary.wmv
366 kB
05.Extensions to GROUP BY/01.Introduction.wmv
6.3 MB
05.Extensions to GROUP BY/02.A Comment about SQL Server 2005.wmv
2.0 MB
05.Extensions to GROUP BY/03.A Warning about Temporary Space.wmv
3.9 MB
05.Extensions to GROUP BY/04.Motivational Example.wmv
6.7 MB
05.Extensions to GROUP BY/05.GROUPING SETS.wmv
5.9 MB
05.Extensions to GROUP BY/06.ROLLUP.wmv
7.4 MB
05.Extensions to GROUP BY/07.CUBE.wmv
5.0 MB
05.Extensions to GROUP BY/08.Composite Columns.wmv
3.8 MB
05.Extensions to GROUP BY/09.Using Multiple Extensions.wmv
5.5 MB
05.Extensions to GROUP BY/10.GROUPING Function.wmv
8.2 MB
05.Extensions to GROUP BY/11.GROUPING_ID Function.wmv
5.4 MB
05.Extensions to GROUP BY/12.GROUP_ID Function.wmv
5.3 MB
05.Extensions to GROUP BY/13.Summary.wmv
1.1 MB
06.The WITH Clause - Part 1/01.Introduction to Part I.wmv
3.2 MB
06.The WITH Clause - Part 1/02.Non-Recursive WITH Clause.wmv
11 MB
06.The WITH Clause - Part 1/03.Non-Recursive WITH Syntax.wmv
2.2 MB
06.The WITH Clause - Part 1/04.CREATE TABLE and The WITH Clause.wmv
1.2 MB
06.The WITH Clause - Part 1/05.Using Previously Defined WITH Clauses.wmv
4.3 MB
06.The WITH Clause - Part 1/06.Summary.wmv
487 kB
07.The WITH Clause - Part 2/01.Introduction to Part II.wmv
6.4 MB
07.The WITH Clause - Part 2/02.Recursive WITH Clause.wmv
13 MB
07.The WITH Clause - Part 2/03.Anchor and Recursive Queries.wmv
7.9 MB
07.The WITH Clause - Part 2/04.Recursive WITH Example #1.wmv
15 MB
07.The WITH Clause - Part 2/05.Recursive WITH Example #2.wmv
9.7 MB
07.The WITH Clause - Part 2/06.Recursive WITH Example #3.wmv
6.9 MB
07.The WITH Clause - Part 2/07.MAXRECURSION Option.wmv
2.7 MB
07.The WITH Clause - Part 2/08.SEARCH and SET Options.wmv
9.7 MB
07.The WITH Clause - Part 2/09.Cycle Option and Summary.wmv
6.8 MB
08.The PIVOT and UNPIVOT Features/01.Introduction.wmv
3.4 MB
08.The PIVOT and UNPIVOT Features/02.Vintage Data Transposition Introduction.wmv
883 kB
08.The PIVOT and UNPIVOT Features/03.Vintage Data Transposition Columns to Rows.wmv
9.3 MB
08.The PIVOT and UNPIVOT Features/04.Vintage Data Transposition Rows to Columns.wmv
4.6 MB
08.The PIVOT and UNPIVOT Features/05.Modern Data Transposition Introduction.wmv
760 kB
08.The PIVOT and UNPIVOT Features/06.Modern Data Transposition Columns to Rows.wmv
13 MB
08.The PIVOT and UNPIVOT Features/07.Modern Data Transposition Rows to Columns.wmv
8.1 MB
08.The PIVOT and UNPIVOT Features/08.Oracle-Specific Extensions.wmv
3.4 MB
08.The PIVOT and UNPIVOT Features/09.Multi-Column PIVOT Introduction.wmv
1.8 MB
08.The PIVOT and UNPIVOT Features/10.Oracle Extension to IN Function.wmv
4.4 MB
08.The PIVOT and UNPIVOT Features/11.Multi-Column PIVOT Examples.wmv
3.7 MB
08.The PIVOT and UNPIVOT Features/12.Summary.wmv
366 kB
09.The MERGE Statement/01.Introduction.wmv
8.7 MB
09.The MERGE Statement/02.Reminder of Old Friends.wmv
4.1 MB
09.The MERGE Statement/03.Life without The MERGE Statement.wmv
1.9 MB
09.The MERGE Statement/04.MERGE Syntax.wmv
6.3 MB
09.The MERGE Statement/05.MERGE Example.wmv
4.0 MB
09.The MERGE Statement/06.Additional Conditions.wmv
2.5 MB
09.The MERGE Statement/07.DELETE and Summary.wmv
4.3 MB
10.PARTITION BY-RIGHT OUTER JOIN/01.Introduction.wmv
8.4 MB
10.PARTITION BY-RIGHT OUTER JOIN/02.Why Joins Won't Work.wmv
4.4 MB
10.PARTITION BY-RIGHT OUTER JOIN/03.Tried and True Method.wmv
4.3 MB
10.PARTITION BY-RIGHT OUTER JOIN/04.Syntax.wmv
3.4 MB
10.PARTITION BY-RIGHT OUTER JOIN/05.Examples and Summary.wmv
6.7 MB
adv-sql-queries-oracle-sql-server.zip
2.9 MB