This repository contains everything you need to become proficient in Time Series Analysis and Forecasting
Day 1: Introduction to Time Series Analysis and Forecasting
Cleaning and preparing time series data
Set Theory Operations, Stored Procedures and CASE statements in SQL
Wildcards, Aggregation and Sequences in SQL
Subqueries, Group by, order by and Having clauses in SQL and Analytical Functions
Window Functions, Grouping Sets and Constraints in SQL
Common Expression Table, UNNEST Clause, SQL vs NoSQL Databases
Triggers, Pivot and Cursors in SQL
Views, Indexes and Auto Increment in SQL
Query optimizations, Performance tuning in SQL
Time Series Analysis Projects ( 5 projects)