SQL Bootcamp (PostgreSQL)

Day 00 Relational Data Model and SQL

Day 01 First steps working with sets and JOINs in SQL

Day 02 Deep diving into JOINs in SQL

Day 03 Changing data based on DML language

Day 04 Virtual views and physical snapshots of data

Day 05 Database indexes

Day 06 Adding a new business feature to our data model

Day 07 Specific OLAP constructions to get a “Value” from data

Day 08 Transactions and isolation levels

Day 09 Functional blocks in databases

Team 00 Traveling Salesman Problem

Team 01 DWH and how to create an ETL process