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

01 - Before we start coding/001 Introduction.mp4

4.65 MB

01 - Before we start coding/001 Introduction.srt

2.13 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.25 MB

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

10.73 KB

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

12.57 MB

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

5.54 KB

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

37.2 MB

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

9.97 KB

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

34.49 MB

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

13.28 KB

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

27.43 MB

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

12.36 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.47 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

20.67 MB

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

7.41 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.61 KB

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

2.02 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.25 MB

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

50.89 MB

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

12.9 KB

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

2.08 KB

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

2 KB

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

22.33 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.29 KB

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

2.57 KB

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

110.98 MB

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

18.49 KB

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

1.04 KB

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

1.95 KB

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

2.01 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.09 MB

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

15.56 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

2.96 KB

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

14.79 MB

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

9.75 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.77 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.28 MB

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

17.68 KB

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

2.29 KB

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

1.75 KB

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

602 B

03 - Subqueries/001 Scalar Subqueries.mp4

25.26 MB

03 - Subqueries/001 Scalar Subqueries.srt

9.78 KB

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

670 B

03 - Subqueries/002 Scalar Subqueries - Exercises.html

1.48 KB

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

1.1 KB

03 - Subqueries/003 Correlated Subqueries.mp4

62.52 MB

03 - Subqueries/003 Correlated Subqueries.srt

13.92 KB

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

369 B

03 - Subqueries/004 Correlated Subqueries - Exercises.html

1.08 KB

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

871 B

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

1.86 KB

03 - Subqueries/005 EXISTS.mp4

51.46 MB

03 - Subqueries/005 EXISTS.srt

18.18 KB

03 - Subqueries/006 EXISTS - Exercises.html

1.45 KB

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

959 B

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

60.34 MB

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

19.97 KB

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

1.39 KB

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

1.36 KB

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

712 B

03 - Subqueries/009 PIVOT - Part 1.mp4

49.79 MB

03 - Subqueries/009 PIVOT - Part 1.srt

13.8 KB

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

601 B

03 - Subqueries/010 PIVOT - Part 2.mp4

31.77 MB

03 - Subqueries/010 PIVOT - Part 2.srt

11.1 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

40.91 MB

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

14.57 KB

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

27.74 MB

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

10.95 KB

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

1.58 KB

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

754 B

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

1.03 KB

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

935 B

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

26.7 MB

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

18.37 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.33 MB

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

14.09 KB

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

23.34 MB

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

7.18 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.13 KB

05 - Temp Tables/004 CREATE and INSERT.mp4

41.36 MB

05 - Temp Tables/004 CREATE and INSERT.srt

17.98 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.75 KB

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

50.67 MB

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

12.06 KB

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

27.31 MB

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

10.66 KB

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

1.73 KB

05 - Temp Tables/008 TRUNCATE - Exercise.html

1.34 KB

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

1.84 KB

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

47.81 MB

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

11.06 KB

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

35.16 MB

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

10.73 KB

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

1.07 KB

05 - Temp Tables/011 UPDATE - Exercise.html

800 B

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

1.23 KB

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

1.08 KB

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

1.24 KB

05 - Temp Tables/012 DELETE.mp4

9.61 MB

05 - Temp Tables/012 DELETE.srt

6.51 KB

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

35.21 MB

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

10 KB

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

38.76 MB

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

11.12 KB

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

2.37 KB

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

262 B

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

1.76 KB

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

520 B

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

54.31 MB

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

14.36 KB

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

1.18 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

177.77 KB

06 - Optimization/006 Introducing Indexes.mp4

47.39 MB

06 - Optimization/006 Introducing Indexes.srt

12.21 KB

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

2.24 KB

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

65.22 MB

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

13.58 KB

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

1.3 KB

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

1.14 KB

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

269 B

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

57.37 MB

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

17.76 KB

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

1.08 KB

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

61.9 MB

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

10.47 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

57.7 MB

06 - Optimization/012 Views.srt

12.06 KB

06 - Optimization/013 Views - Exercises.html

1.81 KB

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

1.2 KB

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

42.17 MB

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

12.56 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.33 MB

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

9.49 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.28 MB

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

11.19 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.05 MB

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

14.91 KB

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

1.02 KB

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

1.63 KB

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

557 B

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

27.75 MB

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

15.82 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

27.85 MB

07 - Programming SQL/011 Stored Procedures.srt

15.53 KB

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

1.47 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.38 MB

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

15.21 KB

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

1.26 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.26 MB

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

9.93 KB

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

1.82 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.71 KB

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

53.61 MB

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

12.2 KB

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

162 B

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

73.94 MB

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

17.74 KB

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

782 B

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

2.14 KB

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

1.64 KB

资源详情

免责声明