From the course: Advanced SQL for Data Science: Time Series
Learn time series data analysis with SQL - SQL Tutorial
From the course: Advanced SQL for Data Science: Time Series
Learn time series data analysis with SQL
- [Dan] More and more data is being collected from sensors, user interactions with web applications and performance metrics. One thing all of these have in common is that they can be modeled as a series of events that happen over time. Analyzing time series data like this can be challenging, but SQL has evolved to include features that support just the kind of analysis we need. In this course, you'll learn about time series data, ways of working with is using abstractions like sliding windows and tumbling windows, and you'll also learn how to use SQL constructs, like over and partition by, to simplify analysis of time series data. You'll also learn about the benefits of denormalizing time series data to avoid joins and when to limit your use of denormalizing. By the end of the course, you'll be familiar with common analysis patterns, like moving averages, comparisons across periods, exponential smoothing, and forecasting with linear regression. My name is Dan Sullivan, and I'm a principal engineer and architect working on large scale time series and machine learning applications.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.