This repository contains my solutions for the SQL Bootcamp tasks, which I completed at the "School 21" programming school.
Day1: Today you will see how relational model works and how to get needed data based on basic constructions of SQL
Day2: Today you will see how to get needed data based on sets constructions and simple JOINs
Day3: Today you will see how to get needed data based on different structures JOINs
Day4: Today you will see how to change data based on DML language
Day5: Today you will see how to use a virtual view and physical snapshot of data
Day6: Today you will see how and when to create database indexes
Day7: Today you will see how to add a new business feature into our data model
Day8: Today you will see how to use specific OLAP constructions to get a “Value” from data
Day9: Today you will see how database works with transactions and isolation levels
Day10: 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