SQL Practice: Window Functions
12mAdvanced2023-09-13
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
Test your knowledge of Window Functions in SQL in this edition of Code Challenges. Instructor Scott Simpson provides five challenges—and his solutions—that reflect real-world data analysis use cases, including calculating a running total, ranking employees of a company by pay, and comparing order totals over time. It’s a data-driven world, and SQL is the language often used to work with that data. Try out Scott’s challenges to see how your skills match up, learn new methods, and gain confidence in working with the various data analysis and reporting tools that many SQL-compatible relational database management systems provide.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Try your SQL programming skills
- 02 - What you should know
- 03 - Explore the lab environment
1. Code Challenges
- 04 - Solution - Calculate a running total
- 05 - Solution - Summarize weekly pay by department
- 06 - Solution - Rank department employees by pay
- 07 - Solution - Compare order totals over time
- 08 - Solution - Moving average
Conclusion
- 09 - Next steps