YoVDO

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

Introduction to Databases
Meta via Coursera
Web Development
Udacity
Introduction to Data Science
University of Washington via Coursera
Datenmanagement mit SQL
openHPI
Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX