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
Introduction
- SQL querying techniques
- What you should know
- Using GitHub Codespaces with this course
Window Functions
- Anatomy of a Window Function
- Try it - Ranking functions
- Check it - Ranking functions
- Try it - Aggregations
- Check it - Aggregations
Subqueries
- Introduction to subqueries
- Try it - Subquery with aggregations
- Check it - Subquery with aggregations
- Try it - Subquery with conditional logic
- Check it - Subquery with conditional logic
Common Table Expressions
- Anatomy of a CTE
- Try it - Implement CTE
- Check it - Implement CTE
- Try it - Build a query that implements CTE
- Check it - Build a query that implements CTE
Date and Time Manipulation
- Introduction to datetime manipulation
- Try it - Difference between dates
- Check it - Difference between dates
- Try it - Extracting the year and month
- Check it - Extracting the year and month
Conclusion
- Next steps