Top Five Things to Know in Advanced SQL

[0dayddl]

​

Top Five Things to Know in Advanced SQL
Language: English | Size:226.5 MB
Genre:eLearning
​

Files Included :

Spoiler

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

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!