Lead - SQL Tutorial

Contents

• Introduction Introduction

  • Learn time series data analysis with SQL

    48s
  • (Locked)
    What you should know

    23s
• 1. Introduction to Time Series Data 1. Introduction to Time Series Data

  • Characteristics of time series data

    4m 11s
  • (Locked)
    Examples of time series data

    1m 23s
  • (Locked)
    Writing time series data

    1m 48s
  • (Locked)
    Querying time series data

    1m 38s
• 2. Installing Database and Tools 2. Installing Database and Tools

  • Installing PostgreSQL

    2m 41s
  • (Locked)
    Creating schema and tables

    3m 24s
  • (Locked)
    Timing a query

    1m 8s
  • (Locked)
    Evaluating query performance with EXPLAIN

    1m 34s
• 3. Querying Time Series Data 3. Querying Time Series Data

  • Time window queries and aggregates

    1m 39s
  • (Locked)
    Sliding windows

    1m 9s
  • (Locked)
    Tumbling windows

    1m 4s
  • (Locked)
    Joining two time series

    2m 52s
  • (Locked)
    Denormalizing time series data

    1m 56s
• 4. Modeling Time Series Data 4. Modeling Time Series Data

  • (Locked)
    Example data set 1: Temperature by time and location

    2m 44s
  • (Locked)
    Indexing data set 1: Time index only

    4m 50s
  • (Locked)
    Indexing data set 1: Time and location index

    4m
  • (Locked)
    Creating a partitioned table

    4m 34s
  • (Locked)
    Querying a partitioned table

    2m 37s
  • (Locked)
    Example data set 2: CPU utilization and application type

    1m 57s
  • (Locked)
    Indexing data set 2: Time and type Indexing

    3m 5s
• 5. Commonly Used Functions for Time Series 5. Commonly Used Functions for Time Series

  • (Locked)
    Lead

    3m 56s
  • (Locked)
    Lag

    1m 34s
  • (Locked)
    Rank

    1m 27s
  • (Locked)
    Percent rank

    34s
• 6. Time Series Analysis 6. Time Series Analysis

  • (Locked)
    Common Table Expressions and recursion

    2m 46s
  • (Locked)
    Calculating aggregates over windows

    1m 34s
  • (Locked)
    Previous day comparison

    3m 50s
  • (Locked)
    Moving averages

    1m 59s
  • (Locked)
    Weighted moving averages

    5m 18s
  • (Locked)
    Forecasting with linear regression

    3m 39s
  • (Locked)
    Exponential moving average

    1m 29s
• Conclusion Conclusion

  • (Locked)
    Next steps

    45s