In an increasingly data-driven world, database systems play a central role in data retrieval, manipulation, and storage. When you use services provided by companies such as Google and Amazon you are in fact a user of advanced database systems. The reach of such systems goes well beyond the online world. Most businesses use one or more databases to keep track of important data (e.g. on their personnel, clients, payments, sales, and so on). Obviously, these systems need to be robust and efficient, in terms of handling simultaneous queries, internal consistency, and durability of information stored by the database.

This course is aimed at teaching you about the theoretical fundamentals of databases systems. Special attention is paid to a deep understanding of relational databases, database design, and the structured query language (SQL). In addition, you will learn about several advanced topics, such as ACID properties, B-trees, and alternatives to SQL. Alongside the theory, you will get hands-on experience with database systems, by setting up your own databases using a SQL server and SQLite, and by interfacing with existing databases in various ways (e.g. using Python).

Contact hours listed under a course description may vary due to the combination of lecture-based and independent work required for each course therefore, CEA's recommended credits are based on the ECTS credits assigned by VU Amsterdam. 1 ECTS equals 28 contact hours assigned by VU Amsterdam.