English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 27m | 54 MB
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.
Table of Contents
Introduction
1 SQL querying techniques
2 What you should know
3 Using GitHub Codespaces with this course
Window Functions
4 Anatomy of a Window Function
5 Try it Ranking functions
6 Check it Ranking functions
7 Try it Aggregations
8 Check it Aggregations
Subqueries
9 Introduction to subqueries
10 Try it Subquery with aggregations
11 Check it Subquery with aggregations
12 Try it Subquery with conditional logic
13 Check it Subquery with conditional logic
Common Table Expressions
14 Anatomy of a CTE
15 Try it Implement CTE
16 Check it Implement CTE
17 Try it Build a query that implements CTE
18 Check it Build a query that implements CTE
Date and Time Manipulation
19 Introduction to datetime manipulation
20 Try it Difference between dates
21 Check it Difference between dates
22 Try it Extracting the year and month
23 Check it Extracting the year and month
Conclusion
24 Next steps
Resolve the captcha to access the links!