->

Advanced SQL for Data Science: Time Series

Advanced SQL for Data Science: Time Series

MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 1h 18m

Genre: eLearning | Language: English + Sub | Size: 176 MB


 

Time series data is data gathered over time: performance metrics, user interactions, and information collected by sensors. Since different time series data have different measures and different intervals, these data present a unique challenge for data scientists. However, SQL has some features designed to help. This course teaches you how to standardize and model time series data with them. Instructor Dan Sullivan discusses windowing and the difference between sliding and tumbling window calculations. Then learn how SQL constructs such as OVER and PARTITION BY help to simplify analysis, and how denormalization can be used to augment data while avoiding joins. Plus, discover optimization techniques such as indexing. Dan also introduces time series analysis techniques such as previous time period comparisons, moving averages, exponential smoothing, and linear regression.

Topics include:

Basics of time series data

Writing time series data

Querying time series data

Installing PostgreSQL

Evaluating query performance

Joining time series

Denormalizing time series

Indexing data

Querying a partitioned table

Functions for time series

Calculating aggregates over windows

Calculating moving averages

Forecasting with linear regression

 

HOMEPAGE

https://www.lynda.com/SQL-tutorials/Advanced-SQL-Data-Science-Time-Series/774912-2.html

 

Advanced SQL for Data Science: Time Series


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Solid   |  

Information
Members of Guests cannot leave comments.




rss