1. Introduction to SQL Server

2. Introduction to Relational Database

3. Intermediate to SQL Server

4. Time Series Analysis with SQL Server

5. Functions for Manipulating Data in SQL-SERVER

6. Database Design

7. Transactions And Error Handling in SQL Server

8. Writing Functions and Store Procedures in SQL Server

9. Building & Optimizing Triggers in SQL Server

10. SQL Cheat-Sheet

11. Advanced SQL

Indexes in SQL

Postgres

Postgres cursor and functions

Untitled

Untitled

Important Links

Dimensional models

Dimensional schemas