Advanced SQL for Data Science: Time Series/ with Dan Sullivan.

Format:

Video

Author/Creator:

Sullivan, Dan, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Video recordings.

Physical Description:

1 online resource

polychrome

Place of Publication:

Carpenteria, CA:: linkedin.com, 2019.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Learn how to model time series data and apply advanced analysis techniques using SQL.

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.

Participant:

Presenter: Dan Sullivan

Notes:

4/26/20191

Access Restriction:

Restricted for use by site license.