Day00 - Today you will see how relational model works and how to get needed data based on basic constructions of SQ
Day01 - Today you will see how to get needed data based on sets constructions and simple JOINs
Day02 - Today you will see how to get needed data based on different structures JOINs
Day03 - Today you will see how to change data based on DML language
Day04 - Today you will see how to use a virtual view and physical snapshot of data
Day05 - Today you will see how and when to create database indexes
Day06 - Today you will see how to add a new business feature into our data model
Day07 - Today you will see how to use specific OLAP constructions to get a “Value” from data
Day08 - Today you will see how database works with transactions and isolation levels
Day09 - Today you will see how to create and use functional blocks in Databases
Team00 - Today you will implementing a quick solution on SQL to achieve results of Traveling Salesman Problem
Team01 - Today you will know what DWH is and how to create a first ETL process