Advanced SQL for Data Science
Time Series
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.
Contents:
- Introduction
- 1. Introduction to Time Series Data
- 2. Installing Database and Tools
- 3. Querying Time Series Data
- 4. Modeling Time Series Data
- 5. Commonly Used Functions for Time Series
- 6. Time Series Analysis
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 1h 18m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Dan Sullivan |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Data Science |
Tags | SQL Time Series Analysis |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Adjunct Professor, Time Series Econometrics $36k
Professor (adjunct series) $37k
Assistant Editor for RFC Series $58k
Traffic Studies Specialist Series $64k
Senior Series Editor $67k
Junior Series Producer, Music Choice Concert Series $71k
Series Editor $84k
Spark series editor $87k
Manager, Series Marketing $88k
Senior Editor for RFC Series $102k
3000 Series Team Leader $111k
Assistant Professor (adjunct series) $162k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 1h 18m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Dan Sullivan |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Data Science |
Tags | SQL Time Series Analysis |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course