The Database Systems course provides the necessary introduction to database system architecture, design and implementation. Topics include: SQL language (demonstrated using PostgreSQL), relational database modeling and design, relational and NoSQL database servers, Business Intelligence, data warehousing, PL/pgSQL programming, etc.

Introduction to SQL (slides)
SQL Practices
Database for practices

Introduction to PL/pgSQL (slides)
PL/pgSQL Practices

Introduction to Business Intelligence (slides)
Data warehousing assignment
Data warehousing assignment: source CSV file

Back