The Advanced SQL Server Masterclass For Data Analysis

سرفصل های دوره

Take your SQL skills - and your career - to the next level

01 - Before we start coding

001 Introduction

002 IMPORTANT NOTE PLEASE READ.html

003 Installing SQL Server 2019 Express

004 Installing SQL Server Management Studio

005 Downloading the AdventureWorks Sample Database

006 Course Environment Walkthrough

02 - Advanced Analysis With Window Functions

001 Introducing Window Functions With OVER

001 over-example-code.zip

002 Introducing Window Functions With OVER - Exercises.html

002 over-exercise-solutions.zip

003 PARTITION BY

003 partition-by-example-code.zip

004 PARTITION BY - Exercises.html

004 partition-by-exercise-solutions.zip

005 ROW NUMBER

005 ROW-NUMBER

005 row-number-example-code.zip

006 ROW NUMBER - Exercises.html

006 row-number-exercise-solutions.zip

007 RANK and DENSE RANK

007 rank-and-dense-rank-example-code.zip

008 RANK and DENSE RANK - Exercises.html

008 rank-and-dense-rank-exercise-solutions.zip

009 LEAD and LAG

009 lead-and-lag-example-code.zip

010 LEAD and LAG - Exercises.html

010 lead-and-lag-exercise-solutions.zip

011 FIRST VALUE

011 first-value-example-code.zip

012 FIRST VALUE - Exercises.html

012 first-value-exercise-solutions.zip

013 Introducing Subqueries

013 subqueries-example-code.zip

014 Introducing Subqueries - Exercises.html

014 subqueries-exercise-solutions.zip

015 ROWS BETWEEN

015 rows-between-example-code.zip

016 ROWS BETWEEN - Exercises.html

016 rows-between-exercise-solutions.zip

03 - Subqueries

001 Scalar Subqueries

001 scalar-subqueries-example-code.zip

002 Scalar Subqueries - Exercises.html

002 scalar-subqueries-exercise-solutions.zip

003 Correlated Subqueries

003 correlated-subqueries-example-code.zip

004 Correlated Subqueries - Exercises.html

004 correlated-subqueries-exercise-solutions.zip

005 EXISTS

005 exists-example-code.zip

006 EXISTS - Exercises.html

006 exists-exercise-solutions.zip

007 FOR XML PATH With STUFF

007 for-xml-path-with-stuff-example-code.zip

008 FOR XML PATH With STUFF - Exercises.html

008 for-xml-path-with-stuff-exercise-solutions.zip

009 PIVOT - Part 1

009 pivot-part-1-example-code.zip

010 PIVOT - Part 2

010 pivot-part-2-example-code.zip

011 PIVOT - Exercises.html

011 pivot-exercise-solutions.zip

04 - Common Table Expressions (CTEs)

001 CTEs - Part 1

002 CTEs - Part 2

002 ctes-example-code.zip

003 CTEs - Exercise.html

003 ctes-exercise-solution.zip

003 ctes-exercise-starter-code.zip

004 Recursive CTEs

004 recursive-ctes-example-code.zip

005 Recursive CTEs - Exercises.html

005 recursive-ctes-exercise-solutions.zip

05 - Temp Tables

001 Temp Tables - Part 1

002 Temp Tables - Part 2

002 temp-tables-example-code.zip

003 Temp Tables - Exercises.html

003 temp-tables-exercise-solution.zip

004 CREATE and INSERT

004 create-and-insert-example-code.zip

005 CREATE and INSERT - Exercise.html

005 create-and-insert-exercise-solution.zip

006 TRUNCATE - Part 1

007 TRUNCATE - Part 2

007 truncate-example-code.zip

008 TRUNCATE - Exercise.html

008 truncate-exercise-solution.zip

009 UPDATE - Part 1

010 UPDATE - Part 2

010 update-example-code.zip

011 UPDATE - Exercise.html

011 update-exercise-solution.zip

011 update-exercise-starter-code.zip

012 DELETE

012 delete-example-code.zip

06 - Optimization

001 Optimizing With UPDATE - Part 1

002 Optimizing With UPDATE - Part 2

002 optimizing-with-update-example-code.zip

003 Optimizing With UPDATE - Exercise.html

003 optimizing-with-update-exercise-solution.zip

003 optimizing-with-update-exercise-starter-code.zip

004 An Improved EXISTS With UPDATE

004 an-improved-exists-with-update-example-code.zip

005 An Improved EXISTS With UPDATE - Exercise.html

005 an-improved-exists-with-update-exercise-solution.zip

005 an-improved-exists-with-update-exercise-starter-code.zip

006 Indexes.pdf

006 Introducing Indexes

007 Optimizing With Indexes - Example

007 indexes-example-code.zip

008 Optimizing With Indexes - Exercise.html

008 indexes-exercise-solution.zip

008 indexes-exercise-starter-code.zip

009 Lookup Tables - Part 1

009 lookup-tables-part-one-example-code.zip

010 Lookup Tables - Part 2

010 lookup-tables-part-two-example-code.zip

011 Lookup Tables - Exercises.html

011 lookup-tables-exercise-solutions.zip

012 Views

012 views-example-code.zip

013 Views - Exercises.html

013 views-exercise-solutions.zip

07 - Programming SQL

001 Variables - Part 1

001 variables-part-1-example-code.zip

002 Variables - Exercise 1.html

002 variables-part-1-exercise-solution.zip

002 variables-part-1-exercise-starter-code.zip

003 Variables - Part 2

003 variables-part-2-example-code.zip

004 Variables - Exercise 2.html

004 variables-part-2-exercise-solution.zip

005 Introducing User Defined Functions

005 introducing-user-defined-functions-example-code.zip

006 NOTE TO STUDENTS.html

007 Making Functions Flexible With Parameters

007 user-defined-functions-with-parameters-example-code.zip

008 User Defined Functions - Exercises.html

008 user-defined-functions-exercise-solutions.zip

009 Table-Valued Functions

009 tvfs-example-code.zip

010 Table-Valued Functions - Exercise.html

010 tvfs-exercise-solution.zip

011 Stored Procedures

011 stored-procedures-example-code.zip

012 Stored Procedures - Exercise.html

012 stored-procedures-exercise-solution.zip

013 Control Flow With IF Statements

013 control-flow-with-if-statements-example-code.zip

014 Control Flow With IF Statements - Exercise.html

014 control-flow-with-if-statements-exercise-solution.zip

015 Using Multiple IF Statements

015 using-multiple-if-statements-example-code.zip

016 Using Multiple IF Statements - Exercise.html

016 using-multiple-if-statements-exercise-solution.zip

017 Dynamic SQL - Part 1

017 dynamic-sql-part-1-example-code.zip

018 Dynamic SQL - Part 2

018 dynamic-sql-part-2-example-code.zip

019 Dynamic SQL - Exercises.html

019 dynamic-sql-exercise-solutions.zip

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy