Описание на русском тут
Diving into SQL (PostgreSQL).
The request to create a database for the execution of days is in the
days_dbfolder.
On this day, you will see how the relational model works and how to get the necessary data based on basic SQL constructs.
On this day, you will see how to get needed data based on sets constructions and simple JOINs.
Today you will see how to get needed data based on different structures JOINs.
Today you will see how to change data based on DML language.
Today you will see how to use a virtual view and physical snapshot of data.
Today you will see how and when to create database indexes.
Today you will see how to add a new business feature into our data model.
Today you will see how to use specific OLAP constructions to get a “Value” from data
Today you will see how database works with transactions and isolation levels.
Today you will see how to create and use functional blocks in Databases.
Today you will know what DWH is and how to create a first ETL process. Group project.