Udemy - The Advanced SQL Server Masterclass For Data Analysis (11.2024)

File Name

Size

01 - Before we start coding/001 Introduction.mp4

4.6 MB

01 - Before we start coding/001 Introduction.srt

2.1 kB

01 - Before we start coding/002 IMPORTANT NOTE PLEASE READ.html

1.6 kB

01 - Before we start coding/003 Installing SQL Server 2019 Express.mp4

34 MB

01 - Before we start coding/003 Installing SQL Server 2019 Express.srt

11 kB

01 - Before we start coding/004 Installing SQL Server Management Studio.mp4

13 MB

01 - Before we start coding/004 Installing SQL Server Management Studio.srt

5.5 kB

01 - Before we start coding/005 Downloading the AdventureWorks Sample Database.mp4

37 MB

01 - Before we start coding/005 Downloading the AdventureWorks Sample Database.srt

10 kB

01 - Before we start coding/006 Course Environment Walkthrough.mp4

34 MB

01 - Before we start coding/006 Course Environment Walkthrough.srt

13 kB

02 - Advanced Analysis With Window Functions/001 Introducing Window Functions With OVER.mp4

27 MB

02 - Advanced Analysis With Window Functions/001 Introducing Window Functions With OVER.srt

12 kB

02 - Advanced Analysis With Window Functions/001 OVER-Example-Code.sql

555 B

02 - Advanced Analysis With Window Functions/002 Introducing Window Functions With OVER - Exercises.html

1.5 kB

02 - Advanced Analysis With Window Functions/002 OVER-Exercise-SOLUTIONS.sql

1.7 kB

02 - Advanced Analysis With Window Functions/003 PARTITION BY.mp4

21 MB

02 - Advanced Analysis With Window Functions/003 PARTITION BY.srt

7.4 kB

02 - Advanced Analysis With Window Functions/003 PARTITION-BY-Example-Code.sql

594 B

02 - Advanced Analysis With Window Functions/004 PARTITION BY - Exercises.html

1.6 kB

02 - Advanced Analysis With Window Functions/004 PARTITION-BY-Exercise-SOLUTIONS.sql

2.0 kB

02 - Advanced Analysis With Window Functions/005 ROW-NUMBER-Example-Code.sql

656 B

02 - Advanced Analysis With Window Functions/005 ROW-NUMBER.mp4

26 MB

02 - Advanced Analysis With Window Functions/005 ROW_NUMBER.mp4

51 MB

02 - Advanced Analysis With Window Functions/005 ROW_NUMBER.srt

13 kB

02 - Advanced Analysis With Window Functions/006 ROW-NUMBER-Exercise-SOLUTIONS.sql

2.1 kB

02 - Advanced Analysis With Window Functions/006 ROW_NUMBER - Exercises.html

2.0 kB

02 - Advanced Analysis With Window Functions/007 RANK and DENSE_RANK.mp4

22 MB

02 - Advanced Analysis With Window Functions/007 RANK and DENSE_RANK.srt

0 B

02 - Advanced Analysis With Window Functions/007 RANK-and-DENSE-RANK-Example-Code.sql

456 B

02 - Advanced Analysis With Window Functions/008 RANK and DENSE_RANK - Exercises.html

1.3 kB

02 - Advanced Analysis With Window Functions/008 RANK-and-DENSE-RANK-Exercise-SOLUTIONS.sql

2.6 kB

02 - Advanced Analysis With Window Functions/009 LEAD and LAG.mp4

111 MB

02 - Advanced Analysis With Window Functions/009 LEAD and LAG.srt

18 kB

02 - Advanced Analysis With Window Functions/009 LEAD-and-LAG-Example-Code.sql

1.0 kB

02 - Advanced Analysis With Window Functions/010 LEAD and LAG - Exercises.html

1.9 kB

02 - Advanced Analysis With Window Functions/010 LEAD-and-LAG-Exercise-SOLUTIONS.sql

2.0 kB

02 - Advanced Analysis With Window Functions/011 FIRST-VALUE-Example-Code.sql

741 B

02 - Advanced Analysis With Window Functions/011 FIRST_VALUE.mp4

88 MB

02 - Advanced Analysis With Window Functions/011 FIRST_VALUE.srt

16 kB

02 - Advanced Analysis With Window Functions/012 FIRST-VALUE-Exercise-SOLUTIONS.sql

984 B

02 - Advanced Analysis With Window Functions/012 FIRST_VALUE - Exercises.html

3.0 kB

02 - Advanced Analysis With Window Functions/013 Introducing Subqueries.mp4

15 MB

02 - Advanced Analysis With Window Functions/013 Introducing Subqueries.srt

9.7 kB

02 - Advanced Analysis With Window Functions/013 Subqueries-Example-Code.sql

319 B

02 - Advanced Analysis With Window Functions/014 Introducing Subqueries - Exercises.html

1.8 kB

02 - Advanced Analysis With Window Functions/014 Subqueries-Exercise-Solutions.sql

800 B

02 - Advanced Analysis With Window Functions/015 ROWS BETWEEN.mp4

95 MB

02 - Advanced Analysis With Window Functions/015 ROWS BETWEEN.srt

18 kB

02 - Advanced Analysis With Window Functions/015 ROWS-BETWEEN-Example-Code.sql

2.3 kB

02 - Advanced Analysis With Window Functions/016 ROWS BETWEEN - Exercises.html

1.8 kB

02 - Advanced Analysis With Window Functions/016 ROWS-BETWEEN-Exercise-SOLUTIONS.sql

602 B

03 - Subqueries/001 Scalar Subqueries.mp4

25 MB

03 - Subqueries/001 Scalar Subqueries.srt

9.8 kB

03 - Subqueries/001 Scalar-Subqueries-Example-Code.sql

670 B

03 - Subqueries/002 Scalar Subqueries - Exercises.html

1.5 kB

03 - Subqueries/002 Scalar-Subqueries-Exercise-SOLUTIONS.sql

1.1 kB

03 - Subqueries/003 Correlated Subqueries.mp4

62 MB

03 - Subqueries/003 Correlated Subqueries.srt

14 kB

03 - Subqueries/003 Correlated-Subqueries-Example-Code.sql

369 B

03 - Subqueries/004 Correlated Subqueries - Exercises.html

1.1 kB

03 - Subqueries/004 Correlated-Subqueries-Exercise-SOLUTIONS.sql

871 B

03 - Subqueries/005 EXISTS-Example-Code.sql

1.9 kB

03 - Subqueries/005 EXISTS.mp4

52 MB

03 - Subqueries/005 EXISTS.srt

18 kB

03 - Subqueries/006 EXISTS - Exercises.html

1.5 kB

03 - Subqueries/006 EXISTS-Exercise-SOLUTIONS.sql

959 B

03 - Subqueries/007 FOR XML PATH With STUFF.mp4

60 MB

03 - Subqueries/007 FOR XML PATH With STUFF.srt

20 kB

03 - Subqueries/007 FOR-XML-PATH-With-STUFF-Example-Code.sql

1.4 kB

03 - Subqueries/008 FOR XML PATH With STUFF - Exercises.html

1.4 kB

03 - Subqueries/008 FOR-XML-PATH-With-STUFF-Exercise-SOLUTIONS.sql

712 B

03 - Subqueries/009 PIVOT - Part 1.mp4

50 MB

03 - Subqueries/009 PIVOT - Part 1.srt

14 kB

03 - Subqueries/009 PIVOT-Part-1-Example-Code.sql

601 B

03 - Subqueries/010 PIVOT - Part 2.mp4

32 MB

03 - Subqueries/010 PIVOT - Part 2.srt

11 kB

03 - Subqueries/010 PIVOT-Part-2-Example-Code.sql

590 B

03 - Subqueries/011 PIVOT - Exercises.html

841 B

03 - Subqueries/011 PIVOT-Exercise-SOLUTIONS.sql

523 B

04 - Common Table Expressions (CTEs)/001 CTEs - Part 1.mp4

41 MB

04 - Common Table Expressions (CTEs)/001 CTEs - Part 1.srt

15 kB

04 - Common Table Expressions (CTEs)/002 CTEs - Part 2.mp4

28 MB

04 - Common Table Expressions (CTEs)/002 CTEs - Part 2.srt

11 kB

04 - Common Table Expressions (CTEs)/002 CTEs-Example-Code.sql

1.6 kB

04 - Common Table Expressions (CTEs)/003 CTEs - Exercise.html

754 B

04 - Common Table Expressions (CTEs)/003 CTEs-Exercise-SOLUTION.sql

1.0 kB

04 - Common Table Expressions (CTEs)/003 CTEs-Exercise-Starter-Code.sql

935 B

04 - Common Table Expressions (CTEs)/004 Recursive CTEs.mp4

27 MB

04 - Common Table Expressions (CTEs)/004 Recursive CTEs.srt

18 kB

04 - Common Table Expressions (CTEs)/004 Recursive-CTEs-Example-Code.sql

523 B

04 - Common Table Expressions (CTEs)/005 Recursive CTEs - Exercises.html

694 B

04 - Common Table Expressions (CTEs)/005 Recursive-CTEs-Exercise-SOLUTIONS.sql

452 B

05 - Temp Tables/001 Temp Tables - Part 1.mp4

49 MB

05 - Temp Tables/001 Temp Tables - Part 1.srt

14 kB

05 - Temp Tables/002 Temp Tables - Part 2.mp4

23 MB

05 - Temp Tables/002 Temp Tables - Part 2.srt

7.2 kB

05 - Temp Tables/002 Temp-Tables-Example-Code.sql

719 B

05 - Temp Tables/003 Temp Tables - Exercises.html

190 B

05 - Temp Tables/003 Temp-Tables-Exercise-SOLUTION.sql

1.1 kB

05 - Temp Tables/004 CREATE and INSERT.mp4

41 MB

05 - Temp Tables/004 CREATE and INSERT.srt

18 kB

05 - Temp Tables/004 CREATE-and-INSERT-Example-Code.sql

979 B

05 - Temp Tables/005 CREATE and INSERT - Exercise.html

148 B

05 - Temp Tables/005 CREATE-and-INSERT-Exercise-SOLUTION.sql

1.7 kB

05 - Temp Tables/006 TRUNCATE - Part 1.mp4

51 MB

05 - Temp Tables/006 TRUNCATE - Part 1.srt

12 kB

05 - Temp Tables/007 TRUNCATE - Part 2.mp4

27 MB

05 - Temp Tables/007 TRUNCATE - Part 2.srt

11 kB

05 - Temp Tables/007 TRUNCATE-Example-Code.sql

1.7 kB

05 - Temp Tables/008 TRUNCATE - Exercise.html

1.3 kB

05 - Temp Tables/008 TRUNCATE-Exercise-SOLUTION.sql

1.8 kB

05 - Temp Tables/009 UPDATE - Part 1.mp4

48 MB

05 - Temp Tables/009 UPDATE - Part 1.srt

11 kB

05 - Temp Tables/010 UPDATE - Part 2.mp4

35 MB

05 - Temp Tables/010 UPDATE - Part 2.srt

11 kB

05 - Temp Tables/010 Update-Example-Code.sql

1.1 kB

05 - Temp Tables/011 UPDATE - Exercise.html

800 B

05 - Temp Tables/011 Update-Exercise-SOLUTION.sql

1.2 kB

05 - Temp Tables/011 Update-Exercise-Starter-Code.sql

1.1 kB

05 - Temp Tables/012 DELETE-Example-Code.sql

1.2 kB

05 - Temp Tables/012 DELETE.mp4

9.6 MB

05 - Temp Tables/012 DELETE.srt

6.5 kB

06 - Optimization/001 Optimizing With UPDATE - Part 1.mp4

35 MB

06 - Optimization/001 Optimizing With UPDATE - Part 1.srt

10 kB

06 - Optimization/002 Optimizing With UPDATE - Part 2.mp4

39 MB

06 - Optimization/002 Optimizing With UPDATE - Part 2.srt

11 kB

06 - Optimization/002 Optimizing-With-UPDATE-Example-Code.sql

2.4 kB

06 - Optimization/003 Optimizing With UPDATE - Exercise.html

262 B

06 - Optimization/003 Optimizing-With-UPDATE-Exercise-SOLUTION.sql

1.8 kB

06 - Optimization/003 Optimizing-With-UPDATE-Exercise-Starter-Code.sql

520 B

06 - Optimization/004 An Improved EXISTS With UPDATE.mp4

54 MB

06 - Optimization/004 An Improved EXISTS With UPDATE.srt

14 kB

06 - Optimization/004 An-Improved-EXISTS-With-UPDATE-Example-Code.sql

1.2 kB

06 - Optimization/005 An Improved EXISTS With UPDATE - Exercise.html

474 B

06 - Optimization/005 An-Improved-EXISTS-With-UPDATE-Exercise-SOLUTION.sql

930 B

06 - Optimization/005 An-Improved-EXISTS-With-UPDATE-Exercise-Starter-Code.sql

313 B

06 - Optimization/006 Indexes.pdf

178 kB

06 - Optimization/006 Introducing Indexes.mp4

47 MB

06 - Optimization/006 Introducing Indexes.srt

12 kB

06 - Optimization/007 Indexes-Example-Code.sql

2.2 kB

06 - Optimization/007 Optimizing With Indexes - Example.mp4

65 MB

06 - Optimization/007 Optimizing With Indexes - Example.srt

14 kB

06 - Optimization/008 Indexes-Exercise-SOLUTION.sql

1.3 kB

06 - Optimization/008 Indexes-Exercise-Starter-Code.sql

1.1 kB

06 - Optimization/008 Optimizing With Indexes - Exercise.html

269 B

06 - Optimization/009 Lookup Tables - Part 1.mp4

57 MB

06 - Optimization/009 Lookup Tables - Part 1.srt

18 kB

06 - Optimization/009 Lookup-Tables-Part-One-Example-Code.sql

1.1 kB

06 - Optimization/010 Lookup Tables - Part 2.mp4

62 MB

06 - Optimization/010 Lookup Tables - Part 2.srt

10 kB

06 - Optimization/010 Lookup-Tables-Part-Two-Example-Code.sql

922 B

06 - Optimization/011 Lookup Tables - Exercises.html

612 B

06 - Optimization/011 Lookup-Tables-Exercise-SOLUTIONS.sql

755 B

06 - Optimization/012 Views-Example-Code.sql

576 B

06 - Optimization/012 Views.mp4

58 MB

06 - Optimization/012 Views.srt

12 kB

06 - Optimization/013 Views - Exercises.html

1.8 kB

06 - Optimization/013 Views-Exercise-SOLUTIONS.sql

1.2 kB

07 - Programming SQL/001 Variables - Part 1.mp4

42 MB

07 - Programming SQL/001 Variables - Part 1.srt

13 kB

07 - Programming SQL/001 Variables-Part-1-Example-Code.sql

854 B

07 - Programming SQL/002 Variables - Exercise 1.html

229 B

07 - Programming SQL/002 Variables-Part-1-Exercise-SOLUTION.sql

907 B

07 - Programming SQL/002 Variables-Part-1-Exercise-Starter-Code.sql

490 B

07 - Programming SQL/003 Variables - Part 2.mp4

24 MB

07 - Programming SQL/003 Variables - Part 2.srt

9.5 kB

07 - Programming SQL/003 Variables-Part-2-Example-Code.sql

435 B

07 - Programming SQL/004 Variables - Exercise 2.html

805 B

07 - Programming SQL/004 Variables-Part-2-Exercise-SOLUTION.sql

395 B

07 - Programming SQL/005 Introducing User Defined Functions.mp4

22 MB

07 - Programming SQL/005 Introducing User Defined Functions.srt

11 kB

07 - Programming SQL/005 Introducing-User-Defined-Functions-Example-Code.sql

397 B

07 - Programming SQL/006 NOTE TO STUDENTS.html

898 B

07 - Programming SQL/007 Making Functions Flexible With Parameters.mp4

72 MB

07 - Programming SQL/007 Making Functions Flexible With Parameters.srt

15 kB

07 - Programming SQL/007 User-Defined-Functions-With-Parameters-Example-Code.sql

1.0 kB

07 - Programming SQL/008 User Defined Functions - Exercises.html

1.6 kB

07 - Programming SQL/008 User-Defined-Functions-Exercise-SOLUTIONS.sql

557 B

07 - Programming SQL/009 Table-Valued Functions.mp4

28 MB

07 - Programming SQL/009 Table-Valued Functions.srt

16 kB

07 - Programming SQL/009 TVFs-Example-Code.sql

321 B

07 - Programming SQL/010 Table-Valued Functions - Exercise.html

766 B

07 - Programming SQL/010 TVFs-Exercise-SOLUTION.sql

251 B

07 - Programming SQL/011 Stored Procedures.mp4

28 MB

07 - Programming SQL/011 Stored Procedures.srt

16 kB

07 - Programming SQL/011 Stored-Procedures-Example-Code.sql

1.5 kB

07 - Programming SQL/012 Stored Procedures - Exercise.html

527 B

07 - Programming SQL/012 Stored-Procedures-Exercise-SOLUTION.sql

500 B

07 - Programming SQL/013 Control Flow With IF Statements.mp4

26 MB

07 - Programming SQL/013 Control Flow With IF Statements.srt

15 kB

07 - Programming SQL/013 Control-Flow-With-IF-Statements-Example-Code.sql

1.3 kB

07 - Programming SQL/014 Control Flow With IF Statements - Exercise.html

525 B

07 - Programming SQL/014 Control-Flow-With-IF-Statements-Exercise-SOLUTION.sql

1007 B

07 - Programming SQL/015 Using Multiple IF Statements.mp4

28 MB

07 - Programming SQL/015 Using Multiple IF Statements.srt

9.9 kB

07 - Programming SQL/015 Using-Multiple-IF-Statements-Example-Code.sql

1.8 kB

07 - Programming SQL/016 Using Multiple IF Statements - Exercise.html

947 B

07 - Programming SQL/016 Using-Multiple-IF-Statements-Exercise-SOLUTION.sql

1.7 kB

07 - Programming SQL/017 Dynamic SQL - Part 1.mp4

54 MB

07 - Programming SQL/017 Dynamic SQL - Part 1.srt

12 kB

07 - Programming SQL/017 Dynamic-SQL-Part-1-Example-Code.sql

162 B

07 - Programming SQL/018 Dynamic SQL - Part 2.mp4

74 MB

07 - Programming SQL/018 Dynamic SQL - Part 2.srt

18 kB

07 - Programming SQL/018 Dynamic-SQL-Part-2-Example-Code.sql

782 B

07 - Programming SQL/019 Dynamic SQL - Exercises.html

2.1 kB

07 - Programming SQL/019 Dynamic-SQL-Exercise-SOLUTIONS.sql

1.6 kB