Database design
 Denormalization for performance. partitioning. Views and materialized views. Semi-structured data in PostgreSQL.

Stored procedures and triggers
 Working with a database from Python. psycopg2. Cursors. Database adapters vs ORM. SQL-injection.

Transaction
ACID properties. Transaction log. MVCC. Isolation levels. Locking. OLTP workload.

Introduction
 Information about course agenda and grading system.
Field overview and motivation. History of databases. DBMS software overview and classification.Getting started with PostgreSQL.

SQL language
Data Definition Language (DDL). Data types. NULL values. Constraints. Database schema changes: migration, backward and forward compatibility.

Complex select queries
 JOINS, subqueries, aggregation, HAVING, GROUP, ORDER BY, UNION. Procedural Languages. PL/pgSQL. Stored procedures.

SQL language continued
Relational algebra. Data Modification Language (DML). CRUD. Select queries. JOINS, subqueries, aggregation, HAVING, GROUP, ORDER BY, UNION, LIMIT.

ER data model
 Components of the ER Diagram. ER-Diagram Notations.  Practice example of creating ERD.

Relational database design
 Functional dependencies. Database normalisation.

Indexes
 B-Tree indexes Hash indexes. Bitmap indexes. Partial and functional indexes. Clustered indexes and covering.

Query optimization
 Profiling queries. Query planning and execution. EXPLAIN statement. Benchmarking.

Database system maintenance
 Database configuration. Tuning memory and I/O. Connection pooling. Database monitoring. Backup solutions.

Practical session
 Discussing database design projects.

Database clustering
 High Availability, Load Balancing, and Replication. Physical and logical replication. Failover.

Extra topics on non-relational databases. 
Final exam.