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: Lecture

Excercise

Database Server Management: Workbook Database Design

Assignment 1. presentation, DB managment

Assignment

Time’s almost up!

Readings

Chapter 12.1, 12.6,13.1, 13.2, 13.3,13.5, 15.1, 15.2: Database System Concepts

Week #08

Lecture

Database Indexing, sorting, aggregation, join algorithms: Lecture

Excercise

Super trooper extra hardcore raw bio vegan SQL.

Assignment

The time has come… and so have Assignment 2.

Readings

Chapter 14.1 - 14.9: Database System Concepts

Week #09

Lecture

Transactions: Lecture

Excercise

Assignment 2. presentation and Queries.: Workbook 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: Lecture

Excercise

Assignment 2. presentation. Working on assignment 3.

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: : Workbook SQL

Week #12

Lecture

NoSQL

Excercise

Assignment 3. presentation, MongoDB