Top Five Things to Know in Advanced SQL
Focused View
Kendall Ruber
1:35:24
76 View
01 - The importance of SQL in a data-driven world.mp4
00:50
02 - Prerequisite knowledge.mp4
00:57
03 - Navigating the exercise files on GitHub.mp4
01:22
04 - Setting up Microsoft SQL Server.mp4
06:09
05 - Adding primary key constraints.mp4
01:38
01 - What is a subquery.mp4
00:58
02 - Syntax of a scalar subquery.mp4
04:16
03 - Syntax of a multiple-row subquery.mp4
06:20
04 - Uncorrelated subquery.mp4
01:05
05 - Correlated subquery.mp4
04:52
06 - Challenge Create a subquery.mp4
00:57
07 - Solution Create a subquery.mp4
02:35
01 - Syntax of CTEs.mp4
04:43
02 - Recursive CTEs.mp4
06:56
03 - Challenge Create a CTE.mp4
01:05
04 - Solution Create a CTE.mp4
03:05
05 - Difference between a CTE and a subquery.mp4
02:01
01 - Introduction to window functions.mp4
02:30
02 - Diving into ROW NUMBER().mp4
07:59
03 - Challenge Calculate a ROW NUMBER.mp4
01:02
04 - Solution Calculate a ROW NUMBER.mp4
05:02
01 - Use cases and syntax of LAG() and LEAD().mp4
01:15
02 - Using LAG() and LEAD() in tandem.mp4
06:00
03 - Challenge Using LAG() and LEAD() to determine most recent order quantities.mp4
02:04
04 - Solution Using LAG() and LEAD() to determine most recent order quantities.mp4
05:52
01 - Introduction to ranking window functions.mp4
02:03
02 - Demonstrating the distinction between RANK() and DENSE RANK().mp4
04:17
03 - Challenge RANK() and DENSE RANK().mp4
00:32
04 - Solution RANK() and DENSE RANK().mp4
05:36
01 - Wrap-up.mp4
01:23
Description
In this course, Kendall Ruber shows you how to build on your existing knowledge of basic SQL commands by introducing advanced SQL concepts and providing hands-on exercises for you to apply these skills to common business problems. By the end of this course, students should understand the different use cases and limitations for various advanced functions in SQL, as well as be able to appropriately apply these functions to solve business problems. Learn and practice how to construct subqueries, CTEs (Common Table Expressions), and windows functions.
More details
User Reviews
Rating
average 0
Focused display
Category
Kendall Ruber
Instructor's Courses
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 30
- duration 1:35:24
- Release Date 2023/10/03
