Database Management Systems

Introduction to DB World

ER Design

Design Theory

DVDrental DB database .zip

SQL -Data Definition Language

Labs DML: Insert, Update, Delete using DVDrental DB

Relational Algebra I: Unary Ops slides RA & SQL lab answers reponses-fr

Relational Algebra II: Binary Ops slides SQL lab answers reponses-fr

Relational Division: slides SQL lab

SQL Analytics I: slides lab answers tpch-benchmark .sql

Recursive SQL

Join algorithms

Relational Indexes: slides lab-idx

OLTP

Programming Languages

+ procedural language

+ JDBC

Semi-strutured databases

+ XML databases: slides-1 slides-2 lab-baseX-1 lab-baseX-2

+ JSON databases: mongo-db+lab