Database Fundamentals and Applications

Description

By the end of this course, you can define and explain core concepts in database systems; design and normalise relational databases; query databases using SQL; describe the advantages and disadvantages of relational databases as well as alternative database systems, and make recommendations on which system to use in which context; and describe and apply data structures that are widely used to implement relational database efficiently. Course Objective: 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). Assessment Information: Written or digital exam and group assignments. Teaching Methods: Lectures (4 hours a week) and tutorials (2 hours a week).