برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Practice It: Advanced SQL

27mAdvanced2024-03-06

Authors

Kedeisha Bryan

Course details

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.

Skills covered

SQLDatabase AdministrationAdvancedDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development

Concepts

0. Introduction

01 - SQL querying techniques
02 - What you should know
03 - Using GitHub Codespaces with this course

1. Window Functions

04 - Anatomy of a Window Function
05 - Try it - Ranking functions
06 - Check it - Ranking functions
07 - Try it - Aggregations
08 - Check it - Aggregations

2. Subqueries

09 - 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

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

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