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