SQL Practice: Window Functions

Offered By: LinkedIn Learning

Tags

Data Analysis Courses SQL Courses Database Management Courses Data Aggregation Courses Moving Average Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Test your knowledge of Window Functions in SQL with five challenges.

Syllabus

Introduction

Try your SQL programming skills
What you should know
Explore the lab environment

1. Code Challenges

Solution: Calculate a running total
Solution: Summarize weekly pay by department
Solution: Rank department employees by pay
Solution: Compare order totals over time
Solution: Moving average

Conclusion

Next steps

Taught by

Scott Simpson

Related Courses

Datenmanagement mit SQL
openHPI Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera Getting and Cleaning Data
Johns Hopkins University via Coursera Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق) MongoDB for .NET Developers
MongoDB University