Schedule

Week #01

Lecture
Introductions to Database Systems
Lecture
Excercise
Env setup, DB import, SQL showcase
Workbook 1
Readings
Chapter 1
Database System Concepts

Week #02

Lecture
Basic SQL
Lecture
Excercise
Basic SQL queries (WHERE, GROUP BY, Agregations)
Workbook SQL ;
Datasets
Readings
Chapter 3; 4.1, 4.4, 4.5
Database System Concepts

Week #03

Lecture
Advanced SQL
Lecture
Excercise
Advanced SQL queries (Window functions, Lateral/Cross join)
Workbook SQL
Assignment
Release of #1 assignment - SQL
Assignment ;
Datasets
Readings
Chapter 4.2, 5
Database System Concepts

Week #04

Lecture
Database modeling 1. - Cardinalities, Notations, Design patterns, Conceptual model
Lecture
Excercise
Database modeling
Workbook Database Design
Assignment
Deadline is coming!
Readings
Chapter 6.1, 6.2, 6.4, 6.5
Database System Concepts

Week #05

Lecture
Database modeling 2. - UC realization, Examples
Lecture
Excercise
Database modeling
Workbook Database Design
Assignment
The deadline has arrived!
Readings
Chapter 7.1, 7.2, 7.3
Database System Concepts

Week #06

Lecture
RDBMS Managment - RBAC, Maintenance, DCL
Excercise
Assignment 1. presentation, RBAC tasks
Assignment
New assignment #2.
Readings
Chapter 4.7
Database System Concepts

Week #07

Lecture
How RDBMS works, Indexing
Excercise
Assignment 1. presentation, DB managment
Assignment
Time’s almost up!
Readings
Chapter 12.1, 12.6,13.1, 13.2, 13.3,13.5
Database System Concepts

Week #08

Lecture
Database Indexing
Excercise
Database Indexing (How to and performance)
Assignment
The time has come… and so have Assignment 2.
Readings
Chapter 14.1 - 14.9
Database System Concepts

Week #09

Lecture
Transactions
Excercise
Assignment 2. presentation, Transactions, Super trooper extra hardcore raw bio vegan SQL.
Assignment
Release of #3 assignment.
Readings
Chapter 17, 18.1, 18.2, 18.7, 18.8, 18.9
Database System Concepts

Week #10

Lecture
Recovery Algorithms, Parallel Processing
Excercise
Assignment 2. presentation, More imposible queries 😈😈😈
Assignment
Submitting assignment #3.
Readings
Chapter 19
Database System Concepts

Week #11

Lecture
Applications in context of Database Systems
Excercise
Assignment 3. presentation, REST, Docker

Week #12

Lecture
NoSQL
Excercise
Assignment 3. presentation, MongoDB