hero-image

Teaching database courses at the Department of Computer Science

Advanced Database Systems

Lectures and Practices

WeekLecturePractice
1.

Introduction, Heap

pdf (08.03.2023)

Heap: pdf (8.3.2023)

customers_plsql.zip

customers_tsql.zip

2.

Query execution plan, index for the primary key

pdf (19.03.2023)

Query execution plan, index on primary key: pdf (20.3.2023)
3.--
4.

B-tree index: pdf (31.3.2023)

Sql script for Oracle

Sql script for SQL Server

B-tree Index: pdf (3.4.2023)
5.CAP theorem, Base, NoSQL DBMS, MongoDB

MongoDB: pdf , moviedb.zip, mongodb.txt

(5.5.2023)

6.

Index, Clustered table: pdf (17.5.2023)

Sql script for Oracle

Sql script for SQL Server

Clustered table: pdf (18.5.2023)
7.  
8.  
9.  
10.  
11.