1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Advanced SQL for Data Science: Time Series Preview

Advanced SQL for Data Science: Time Series

With Dan Sullivan Liked by 4,097 users
Duration: 1h 20m Skill level: Advanced Released: 4/26/2019

Start my 1-month free trial Buy for my team

Course details

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.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.6 out of 5

361 ratings
  • 5 star
    Current value: 266 74%
  • 4 star
    Current value: 71 20%
  • 3 star
    Current value: 16 4%
  • 2 star
    Current value: 3 <1%
  • 1 star
    Current value: 5 1%
  • Rabia Ijaz Rabia Ijaz

    Rabia Ijaz

    Data Analyst @ Realytics.ai | MS in Computer Sciences

    5/5 October 10, 2024
    I am impressed with quality specially lectures are not unnecessary stretched and it is to the point and on spot.
    Helpful · Report
  • Joseph Eton Joseph Eton

    Joseph Eton

    Data Engineer/Data Analyst: Power BI, Tableau, SQL, Excel, Python, R, AI/ML, Data Quality, Snowflakes, AWS, Microsoft Azure, Alteryx, NLP, Sentiment…

    5/5 November 26, 2023
    Great!
    Helpful · Report
  • Eftal Dedebali Eftal Dedebali

    Eftal Dedebali

    BI Solutions | Data Analyst | Python | MS SQL | Power BI

    4/5 March 22, 2023
    Vielen Dank aus Deutschland :)
    Helpful · Report

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Test your knowledge 5 quizzes
  • Learn on the go Access on tablet and phone

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play