Torrent Downloads » Other » [ FreeCourseWeb com ] Udemy - The Advanced SQL Server Masterclass For Data Analysis
Other
[ FreeCourseWeb com ] Udemy - The Advanced SQL Server Masterclass For Data Analysis
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 2.47 GB) (Files: 153)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. Before we start coding
1. Introduction-en_US.srt
1. Introduction.mp4
2. Installing SQL Server 2019 Express-en_US.srt
2. Installing SQL Server 2019 Express.mp4
3. Installing SQL Server Management Studio-en_US.srt
3. Installing SQL Server Management Studio.mp4
4. Downloading the AdventureWorks Sample Database-en_US.srt
4. Downloading the AdventureWorks Sample Database.mp4
5. Course Environment Walkthrough-en_US.srt
5. Course Environment Walkthrough.mp4
2. Advanced Analysis With Window Functions
1. Introducing Window Functions With OVER-en_US.srt
1. Introducing Window Functions With OVER.mp4
2. PARTITION BY-en_US.srt
2. PARTITION BY.mp4
3. ROW_NUMBER-en_US.srt
3. ROW_NUMBER.mp4
4. RANK and DENSE_RANK-en_US.srt
4. RANK and DENSE_RANK.mp4
5. LEAD and LAG-en_US.srt
5. LEAD and LAG.mp4
6. Introducing Subqueries-en_US.srt
6. Introducing Subqueries.mp4
Introducing Subqueries - Exercises.html
Introducing Window Functions With OVER - Exercises.html
LEAD and LAG - Exercises.html
LEAD-and-LAG-Example-Code.sql
OVER-Example-Code.sql
PARTITION BY - Exercises.html
PARTITION-BY-Example-Code.sql
RANK and DENSE_RANK - Exercises.html
RANK-and-DENSE-RANK-Example-Code.sql
ROW-NUMBER-Example-Code.sql
ROW-NUMBER.mp4
ROW_NUMBER - Exercises.html
Subqueries-Example-Code.sql
3. Subqueries
1. Scalar Subqueries-en_US.srt
1. Scalar Subqueries.mp4
2. Correlated Subqueries-en_US.srt
2. Correlated Subqueries.mp4
3. EXISTS-en_US.srt
3. EXISTS.mp4
4. FOR XML PATH With STUFF-en_US.srt
4. FOR XML PATH With STUFF.mp4
5. PIVOT - Part 1-en_US.srt
5. PIVOT - Part 1.mp4
6. PIVOT - Part 2-en_US.srt
6. PIVOT - Part 2.mp4
Correlated Subqueries - Exercises.html
Correlated-Subqueries-Example-Code.sql
EXISTS - Exercises.html
EXISTS-Example-Code.sql
FOR XML PATH With STUFF - Exercises.html
FOR-XML-PATH-With-STUFF-Example-Code.sql
PIVOT - Exercises.html
PIVOT-Part-1-Example-Code.sql
PIVOT-Part-2-Example-Code.sql
Scalar Subqueries - Exercises.html
Scalar-Subqueries-Example-Code.sql
4. Common Table Expressions (CTEs)
1. CTEs - Part 1-en_US.srt
1. CTEs - Part 1.mp4
2. CTEs - Part 2-en_US.srt
2. CTEs - Part 2.mp4
3. Recursive CTEs-en_US.srt
3. Recursive CTEs.mp4
CTEs - Exercise.html
CTEs-Example-Code.sql
Recursive CTEs - Exercises.html
Recursive-CTEs-Example-Code.sql
5. Temp Tables
1. Temp Tables - Part 1-en_US.srt
1. Temp Tables - Part 1.mp4
2. Temp Tables - Part 2-en_US.srt
2. Temp Tables - Part 2.mp4
3. CREATE and INSERT-en_US.srt
3. CREATE and INSERT.mp4
4. TRUNCATE - Part 1-en_US.srt
4. TRUNCATE - Part 1.mp4
5. TRUNCATE - Part 2-en_US.srt
5. TRUNCATE - Part 2.mp4
6. UPDATE - Part 1-en_US.srt
6. UPDATE - Part 1.mp4
7. UPDATE - Part 2-en_US.srt
7. UPDATE - Part 2.mp4
8. DELETE-en_US.srt
8. DELETE.mp4
CREATE and INSERT - Exercise.html
CREATE-and-INSERT-Example-Code.sql
DELETE-Example-Code.sql
TRUNCATE - Exercise.html
TRUNCATE-Example-Code.sql
Temp Tables - Exercises.html
Temp-Tables-Example-Code.sql
UPDATE - Exercise.html
Update-Example-Code.sql
6. Optimization
1. Optimizing With UPDATE - Part 1-en_US.srt
1. Optimizing With UPDATE - Part 1.mp4
2. Optimizing With UPDATE - Part 2-en_US.srt
2. Optimizing With UPDATE - Part 2.mp4
3. An Improved EXISTS With UPDATE-en_US.srt
3. An Improved EXISTS With UPDATE.mp4
4. Introducing Indexes-en_US.srt
4. Introducing Indexes.mp4
5. Optimizing With Indexes - Example-en_US.srt
5. Optimizing With Indexes - Example.mp4
6. Lookup Tables - Part 1-en_US.srt
6. Lookup Tables - Part 1.mp4
7. Lookup Tables - Part 2-en_US.srt
7. Lookup Tables - Part 2.mp4
An Improved EXISTS With UPDATE - Exercise.html
An-Improved-EXISTS-With-UPDATE-Example-Code.sql
Indexes-Example-Code.sql
Indexes.pdf
Lookup Tables - Exercises.html
Lookup-Tables-Part-One-Example-Code.sql
Lookup-Tables-Part-Two-Example-Code.sql
Optimizing With Indexes - Exercise.html
Optimizing With UPDATE - Exercise.html
Optimizing-With-UPDATE-Example-Code.sql
7. Programming SQL
1. Variables - Part 1-en_US.srt
1. Variables - Part 1.mp4
2. Variables - Part 2-en_US.srt
2. Variables - Part 2.mp4
3. Introducing User Defined Functions-en_US.srt
3. Introducing User Defined Functions.mp4
4. Making Functions Flexible With Parameters-en_US.srt
4. Making Functions Flexible With Parameters.mp4
5. Stored Procedures-en_US.srt
5. Stored Procedures.mp4
6. Control Flow With IF Statements-en_US.srt
6. Control Flow With IF Statements.mp4
7. Using Multiple IF Statements-en_US.srt
7. Using Multiple IF Statements.mp4
8. Dynamic SQL - Part 1-en_US.srt
8. Dynamic SQL - Part 1.mp4
9. Dynamic SQL - Part 2-en_US.srt
9. Dynamic SQL - Part 2.mp4
Control Flow With IF Statements - Exercise.html
Control-Flow-With-IF-Statements-Example-Code.sql
Dynamic SQL - Exercises.html
Dynamic-SQL-Part-1-Example-Code.sql
Dynamic-SQL-Part-2-Example-Code.sql
Introducing-User-Defined-Functions-Example-Code.sql
Stored Procedures - Exercise.html
Stored-Procedures-Example-Code.sql
User Defined Functions - Exercises.html
User-Defined-Functions-With-Parameters-Example-Code.sql
Using Multiple IF Statements - Exercise.html
Using-Multiple-IF-Statements-Example-Code.sql
Variables - Exercise 1.html
Variables - Exercise 2.html
Variables-Part-1-Example-Code.sql
Variables-Part-2-Example-Code.sql
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ FreeCourseWeb com ] Udemy - The Advanced SQL Server Masterclass For Data Analysis Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
