Business, Finance & ConsultingData, Technology & EngineeringEnergy, Environment & SustainabilityExplore OptionsFocus & PrepareHealthcare & Biomedical SciencesTake Action

SQL Practice: Window Functions

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.

This course includes Code Challenges powered by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can get hands-on coding practice alongside the course content to advance your programming skills.

Learn More