My first steps in SQL. Project completion date: 06.2024.
The project consists of 10 individual and two team projects. Each sql-file contains a task that needed to be completed except for day09 and team01, where there are a separate readme files.
The logical view of the database model looked like this:
- Day00 - how relational model works and how to get needed data based on basic constructions of SQL
- Day01 - how to get needed data based on sets constructions and simple JOINs
- Day02 - how to get needed data based on different structures JOINs
- Day03 - how to change data based on DML language
- Day04 - how to use a virtual view and physical snapshot of data
- Day05 - how and when to create database indexes
- Day06 - how to add a new business feature into data model
- Day07 - how to use specific OLAP constructions to get a “Value” from data
- Day08 - how database works with transactions and isolation levels
- Day09 - how to create and use functional blocks in Databases
- Team00 - implementing a quick solution on SQL to achieve results of Traveling Salesman Problem
- Team01 - what is DWH and how to create a first ETL process