| 1. CTEs - Part 1-en_US.srt | 13.6 KB | ||
| 1. CTEs - Part 1.mp4 | 67.6 MB | ||
| 1. Introducing Window Functions With OVER-en_US.srt | 11.8 KB | ||
| 1. Introducing Window Functions With OVER.mp4 | 52.9 MB | ||
| 1. Introduction-en_US.srt | 1.8 KB | ||
| 1. Introduction.mp4 | 4.6 MB | ||
| 1. Optimizing With UPDATE - Part 1-en_US.srt | 9.7 KB | ||
| 1. Optimizing With UPDATE - Part 1.mp4 | 45.3 MB | ||
| 1. Scalar Subqueries-en_US.srt | 9.3 KB | ||
| 1. Scalar Subqueries.mp4 | 47.8 MB | ||
| 1. Temp Tables - Part 1-en_US.srt | 13.3 KB | ||
| 1. Temp Tables - Part 1.mp4 | 55.8 MB | ||
| 1. Variables - Part 1-en_US.srt | 12.1 KB | ||
| 1. Variables - Part 1.mp4 | 57.1 MB | ||
| 2. CTEs - Part 2-en_US.srt | 10.3 KB | ||
| 2. CTEs - Part 2.mp4 | 54.7 MB | ||
| 2. Correlated Subqueries-en_US.srt | 13.4 KB | ||
| 2. Correlated Subqueries.mp4 | 62.5 MB | ||
| 2. Installing SQL Server 2019 Express-en_US.srt | 10.2 KB | ||
| 2. Installing SQL Server 2019 Express.mp4 | 41.9 MB | ||
| 2. Optimizing With UPDATE - Part 2-en_US.srt | 10.4 KB | ||
| 2. Optimizing With UPDATE - Part 2.mp4 | 76.2 MB | ||
| 2. PARTITION BY-en_US.srt | 7.1 KB | ||
| 2. PARTITION BY.mp4 | 37.8 MB | ||
| 2. Temp Tables - Part 2-en_US.srt | 6.7 KB | ||
| 2. Temp Tables - Part 2.mp4 | 23.3 MB | ||
| 2. Variables - Part 2-en_US.srt | 8.8 KB | ||
| 2. Variables - Part 2.mp4 | 52.3 MB | ||
| 3. An Improved EXISTS With UPDATE-en_US.srt | 14 KB | ||
| 3. An Improved EXISTS With UPDATE.mp4 | 68.2 MB | ||
| 3. CREATE and INSERT-en_US.srt | 17.1 KB | ||
| 3. CREATE and INSERT.mp4 | 76.6 MB | ||
| 3. EXISTS-en_US.srt | 17.4 KB | ||
| 3. EXISTS.mp4 | 95.8 MB | ||
| 3. Installing SQL Server Management Studio-en_US.srt | 5.4 KB | ||
| 3. Installing SQL Server Management Studio.mp4 | 25.1 MB | ||
| 3. Introducing User Defined Functions-en_US.srt | 10.7 KB | ||
| 3. Introducing User Defined Functions.mp4 | 38.5 MB | ||
| 3. ROW_NUMBER-en_US.srt | 12 KB | ||
| 3. ROW_NUMBER.mp4 | 61.2 MB | ||
| 3. Recursive CTEs-en_US.srt | 17.5 KB | ||
| 3. Recursive CTEs.mp4 | 57.9 MB | ||
| 4. Downloading the AdventureWorks Sample Database-en_US.srt | 9.5 KB | ||
| 4. Downloading the AdventureWorks Sample Database.mp4 | 45.9 MB | ||
| 4. FOR XML PATH With STUFF-en_US.srt | 18.7 KB | ||
| 4. FOR XML PATH With STUFF.mp4 | 79.5 MB | ||
| 4. Introducing Indexes-en_US.srt | 11.8 KB | ||
| 4. Introducing Indexes.mp4 | 47.4 MB | ||
| 4. Making Functions Flexible With Parameters-en_US.srt | 14 KB | ||
| 4. Making Functions Flexible With Parameters.mp4 | 68.1 MB | ||
| 4. RANK and DENSE_RANK-en_US.srt | 8.6 KB | ||
| 4. RANK and DENSE_RANK.mp4 | 47.2 MB | ||
| 4. TRUNCATE - Part 1-en_US.srt | 11.5 KB | ||
| 4. TRUNCATE - Part 1.mp4 | 54.8 MB | ||
| 5. Course Environment Walkthrough-en_US.srt | 12.6 KB | ||
| 5. Course Environment Walkthrough.mp4 | 78.7 MB | ||
| 5. LEAD and LAG-en_US.srt | 17.3 KB | ||
| 5. LEAD and LAG.mp4 | 111 MB | ||
| 5. Optimizing With Indexes - Example-en_US.srt | 12.7 KB | ||
| 5. Optimizing With Indexes - Example.mp4 | 69.9 MB | ||
| 5. PIVOT - Part 1-en_US.srt | 12.9 KB | ||
| 5. PIVOT - Part 1.mp4 | 54.5 MB | ||
| 5. Stored Procedures-en_US.srt | 14.4 KB | ||
| 5. Stored Procedures.mp4 | 63.3 MB | ||
| 5. TRUNCATE - Part 2-en_US.srt | 10.1 KB | ||
| 5. TRUNCATE - Part 2.mp4 | 49.2 MB | ||
| 6. Control Flow With IF Statements-en_US.srt | 14 KB | ||
| 6. Control Flow With IF Statements.mp4 | 63.6 MB | ||
| 6. Introducing Subqueries-en_US.srt | 8.9 KB | ||
| 6. Introducing Subqueries.mp4 | 30.8 MB | ||
| 6. Lookup Tables - Part 1-en_US.srt | 16.8 KB | ||
| 6. Lookup Tables - Part 1.mp4 | 57.4 MB | ||
| 6. PIVOT - Part 2-en_US.srt | 10.4 KB | ||
| 6. PIVOT - Part 2.mp4 | 52.8 MB | ||
| 6. UPDATE - Part 1-en_US.srt | 10.6 KB | ||
| 6. UPDATE - Part 1.mp4 | 67 MB | ||
| 7. Lookup Tables - Part 2-en_US.srt | 10 KB | ||
| 7. Lookup Tables - Part 2.mp4 | 61.9 MB | ||
| 7. UPDATE - Part 2-en_US.srt | 10.1 KB | ||
| 7. UPDATE - Part 2.mp4 | 68.5 MB | ||
| 7. Using Multiple IF Statements-en_US.srt | 9.3 KB | ||
| 7. Using Multiple IF Statements.mp4 | 57.9 MB | ||
| 8. DELETE-en_US.srt | 6 KB | ||
| 8. DELETE.mp4 | 21 MB | ||
| 8. Dynamic SQL - Part 1-en_US.srt | 11.7 KB | ||
| 8. Dynamic SQL - Part 1.mp4 | 53.6 MB | ||
| 9. Dynamic SQL - Part 2-en_US.srt | 17 KB | ||
| 9. Dynamic SQL - Part 2.mp4 | 91.8 MB | ||
| An Improved EXISTS With UPDATE - Exercise.html | 512 B | ||
| An-Improved-EXISTS-With-UPDATE-Example-Code.sql | 1.2 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| CREATE and INSERT - Exercise.html | 102.4 B | ||
| CREATE-and-INSERT-Example-Code.sql | 1 KB | ||
| CTEs - Exercise.html | 716.8 B | ||
| CTEs-Example-Code.sql | 1.6 KB | ||
| Control Flow With IF Statements - Exercise.html | 512 B | ||
| Control-Flow-With-IF-Statements-Example-Code.sql | 1.3 KB | ||
| Correlated Subqueries - Exercises.html | 1.1 KB | ||
| Correlated-Subqueries-Example-Code.sql | 409.6 B | ||
| DELETE-Example-Code.sql | 1.2 KB | ||
| Dynamic SQL - Exercises.html | 2.1 KB | ||
| Dynamic-SQL-Part-1-Example-Code.sql | 204.8 B | ||
| Dynamic-SQL-Part-2-Example-Code.sql | 819.2 B | ||
| EXISTS - Exercises.html | 1.5 KB | ||
| EXISTS-Example-Code.sql | 1.9 KB | ||
| FOR XML PATH With STUFF - Exercises.html | 1 KB | ||
| FOR-XML-PATH-With-STUFF-Example-Code.sql | 1.4 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Indexes-Example-Code.sql | 2.2 KB | ||
| Indexes.pdf | 177.8 KB | ||
| Introducing Subqueries - Exercises.html | 1.8 KB | ||
| Introducing Window Functions With OVER - Exercises.html | 1.5 KB | ||
| Introducing-User-Defined-Functions-Example-Code.sql | 409.6 B | ||
| LEAD and LAG - Exercises.html | 2 KB | ||
| LEAD-and-LAG-Example-Code.sql | 1 KB | ||
| Lookup Tables - Exercises.html | 614.4 B | ||
| Lookup-Tables-Part-One-Example-Code.sql | 1.1 KB | ||
| Lookup-Tables-Part-Two-Example-Code.sql | 921.6 B | ||
| OVER-Example-Code.sql | 512 B | ||
| Optimizing With Indexes - Exercise.html | 307.2 B | ||
| Optimizing With UPDATE - Exercise.html | 307.2 B | ||
| Optimizing-With-UPDATE-Example-Code.sql | 2.4 KB | ||
| PARTITION BY - Exercises.html | 1.7 KB | ||
| PARTITION-BY-Example-Code.sql | 614.4 B | ||
| PIVOT - Exercises.html | 819.2 B | ||
| PIVOT-Part-1-Example-Code.sql | 614.4 B | ||
| PIVOT-Part-2-Example-Code.sql | 614.4 B | ||
| RANK and DENSE_RANK - Exercises.html | 1.3 KB | ||
| RANK-and-DENSE-RANK-Example-Code.sql | 409.6 B | ||
| ROW-NUMBER-Example-Code.sql | 614.4 B | ||
| ROW-NUMBER.mp4 | 26.2 MB | ||
| ROW_NUMBER - Exercises.html | 2.1 KB | ||
| Recursive CTEs - Exercises.html | 716.8 B | ||
| Recursive-CTEs-Example-Code.sql | 512 B | ||
| Scalar Subqueries - Exercises.html | 1.5 KB | ||
| Scalar-Subqueries-Example-Code.sql | 716.8 B | ||
| Stored Procedures - Exercise.html | 512 B | ||
| Stored-Procedures-Example-Code.sql | 1.5 KB | ||
| Subqueries-Example-Code.sql | 307.2 B | ||
| TRUNCATE - Exercise.html | 1.3 KB | ||
| TRUNCATE-Example-Code.sql | 1.7 KB | ||
| Temp Tables - Exercises.html | 204.8 B | ||
| Temp-Tables-Example-Code.sql | 716.8 B | ||
| UPDATE - Exercise.html | 819.2 B | ||
| Update-Example-Code.sql | 1.1 KB | ||
| User Defined Functions - Exercises.html | 1.6 KB | ||
| User-Defined-Functions-With-Parameters-Example-Code.sql | 1 KB | ||
| Using Multiple IF Statements - Exercise.html | 921.6 B | ||
| Using-Multiple-IF-Statements-Example-Code.sql | 1.8 KB | ||
| Variables - Exercise 1.html | 204.8 B | ||
| Variables - Exercise 2.html | 819.2 B | ||
| Variables-Part-1-Example-Code.sql | 819.2 B | ||
| Variables-Part-2-Example-Code.sql | 409.6 B | ||
| ▲ 153 total files | |||
The Advanced SQL Server Masterclass For Data Analysis
MP4 | Video: h264, 1280x720 | Audio: AAC, 44100 Hz
Language: English | Size: 2.46 GB | Duration: 7h 8m
What you'll learn
Installing SQL Server and SQL Server Management Studio
Window Functions
Correlated Subqueries
Advanced filtering with EXISTS and NOT EXISTS
Flattening data with PIVOT
Generating data series with Recursive CTEs
Leveraging CTEs and temporary tables to break complex processes into manageable steps
Defining and manipulating tables with DDL and DML commands
Designing lookup tables to simplify redundant analysis
SQL optimization techniques, including indexes
Procedural programming techniques like variables and IF statements
Defining your own SQL functions
Creating stored procedures for flexible, repeatable analysis
Supercharge your SQL knowledge with procedural programming techniques like variables and IF statements
Writing code that writes code, with Dynamic SQL
Requirements
A working knowledge of SQL fundamentals - including SELECT statements, applying criteria, table joins, and aggregate queries - is necessary for success in this course
Microsoft SQL Server 2019 and SQL Server Management Studio; these are both available for free, and I’ll walk you through installation and setup
Access to a Windows operating system (SQL Server only runs on Windows)
Specific knowledge of SQL Server is helpful, but not required
Description
Do you already know the basics of SQL, but sometimes get frustrated when you encounter situations where the basics just aren't enough?
Are you a junior analyst who wants to level up to advanced SQL so you can take the next step in your career?
Or maybe you're a data scientist who knows enough SQL to get by, but want to take your skills further so you can spend less time wrangling data and more time building models.
If any of these sound like your situation, then you're in the right place. This course on advanced SQL for data analysis has everything that isn't covered in introductory SQL courses.
Download More Courses Visit and Support Us -->> https://FreeCourseWeb.com
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 958.9 MB | freecoursewb | 4 years | 0 | 0 | |
|
[ FreeCourseWeb ] Udemy - Web Scraping for Data Science - Python & Selenium - Basics Posted by
freecoursewb in Other
|
1.5 GB | freecoursewb | 4 years | 0 | 2 |
|
[ FreeCourseWeb ] Udemy - Ultimate JavaScript Arrays plus One To-Do List Project Posted by
freecoursewb in Other
|
506 MB | freecoursewb | 4 years | 0 | 0 |
| 615 MB | freecoursewb | 4 years | 0 | 1 | |
|
[ FreeCourseWeb ] Udemy - The Complete Google Docs Course - Google Docs Tricks & Tips Posted by
freecoursewb in Other
|
1.8 GB | freecoursewb | 4 years | 0 | 1 |
All Comments