Practice It: Advanced SQL

Focused View

Kedeisha Bryan

27:28

600 View

01 - Introduction

01 - SQL querying techniques.mp4

00:36

02 - What you should know.mp4

00:50

03 - Using GitHub Codespaces with this course.mp4

04:07

02 - 1. Window Functions

01 - Anatomy of a Window Function.mp4

01:15

02 - Try it Ranking functions.mp4

00:24

03 - Check it Ranking functions.mp4

01:35

04 - Try it Aggregations.mp4

00:25

05 - Check it Aggregations.mp4

01:41

03 - 2. Subqueries

01 - Introduction to subqueries.mp4

01:34

02 - Try it Subquery with aggregations.mp4

00:25

03 - Check it Subquery with aggregations.mp4

01:26

04 - Try it Subquery with conditional logic.mp4

00:22

05 - Check it Subquery with conditional logic.mp4

01:26

04 - 3. Common Table Expressions

01 - Anatomy of a CTE.mp4

01:46

02 - Try it Implement CTE.mp4

00:29

03 - Check it Implement CTE.mp4

02:00

04 - Try it Build a query that implements CTE.mp4

00:28

05 - Check it Build a query that implements CTE.mp4

01:29

05 - 4. Date and Time Manipulation

01 - Introduction to datetime manipulation.mp4

00:46

02 - Try it Difference between dates.mp4

00:25

03 - Check it Difference between dates.mp4

02:03

04 - Try it Extracting the year and month.mp4

00:23

05 - Check it Extracting the year and month.mp4

01:04

06 - Conclusion

01 - Next steps.mp4

00:29

Description

Are you looking to broaden your SQL abilities while gaining practical experience? Want to master advanced SQL querying techniques beyond the basics? In this course, data scientist and data career coach Kedeisha Bryan teaches advanced SQL concepts through walkthrough exercises and real-world applications. Kedeisha shows you how to think in SQL code and not just memorize syntax. Learn advanced topics such as window functions, CTEs, subqueries, date time manipulation, and more.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace. Check out the “Using GitHub Codespaces with this course” video to learn how to get started.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Kedeisha Bryan

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn 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.