LinkedIn Learning - Top Five Things to Know in Advanced SQL

Files Included :

01 - The importance of SQL in a data-driven world.mp4 (3.28 MB)
MP4
02 - Prerequisite knowledge.mp4 (2.63 MB)
MP4
03 - Navigating the exercise files on GitHub.mp4 (3.7 MB)
MP4
04 - Setting up Microsoft SQL Server.mp4 (13.17 MB)
MP4
05 - Adding primary key constraints.mp4 (5.34 MB)
MP4
01 - What is a subquery.mp4 (1.41 MB)
MP4
02 - Syntax of a scalar subquery.mp4 (10.45 MB)
MP4
03 - Syntax of a multiple-row subquery.mp4 (17.93 MB)
MP4
04 - Uncorrelated subquery.mp4 (2.36 MB)
MP4
05 - Correlated subquery.mp4 (13.34 MB)
MP4
06 - Challenge Create a subquery.mp4 (1.96 MB)
MP4
07 - Solution Create a subquery.mp4 (5.54 MB)
MP4
01 - Syntax of CTEs.mp4 (9.44 MB)
MP4
02 - Recursive CTEs.mp4 (13.09 MB)
MP4
03 - Challenge Create a CTE.mp4 (2.25 MB)
MP4
04 - Solution Create a CTE.mp4 (6.36 MB)
MP4
05 - Difference between a CTE and a subquery.mp4 (3.6 MB)
MP4
01 - Introduction to window functions.mp4 (4.1 MB)
MP4
02 - Diving into ROW NUMBER().mp4 (18.69 MB)
MP4
03 - Challenge Calculate a ROW NUMBER.mp4 (1.73 MB)
MP4
04 - Solution Calculate a ROW NUMBER.mp4 (10.9 MB)
MP4
01 - Use cases and syntax of LAG() and LEAD().mp4 (2.78 MB)
MP4
02 - Using LAG() and LEAD() in tandem.mp4 (12.68 MB)
MP4
03 - Challenge Using LAG() and LEAD() to determine most recent order quantities.mp4 (5.19 MB)
MP4
04 - Solution Using LAG() and LEAD() to determine most recent order quantities.mp4 (17.85 MB)
MP4
01 - Introduction to ranking window functions.mp4 (3.72 MB)
MP4
02 - Demonstrating the distinction between RANK() and DENSE RANK().mp4 (11.43 MB)
MP4
03 - Challenge RANK() and DENSE RANK().mp4 (1.06 MB)
MP4
04 - Solution RANK() and DENSE RANK().mp4 (16.21 MB)
MP4
01 - Wrap-up.mp4 (4.31 MB)
MP4