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

Start my 1-month free trial

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.

Contents