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