Introduction to databases

Module title:

Introduction to databases

Module overview:

The aim of the module is to introduce students to the concepts of relational databases and relational database management systems (RDBMS).
This is the central module within the study program and represents the basis for other modules related to databases that students enrol in in the coming semesters. Acquired skills significantly contribute to the professional development of students in professional areas related to the study program.
The module is taught in the Transact-SQL dialect of the SQL programming language. The final evaluation is based on solving a series of smaller practical tasks. Database design tasks are solved using the default entity and connection modeling tool, while database query execution tasks are solved using the default client database management tools to connect to the existing database.

Students will learn:

relational databases concepts, which are necessary to build skills that are more complex and required in the labour market.

normal forms (1NF, 2NF, 3NF) and the normalization process.

how to construct and interpret SQL statements for selecting, inserting, deleting and updating data.

how to write more complex SQL queries that include JOIN mechanics, grouping, aggregate functions and subqueries.

Literature:

Required readings:
1. Harrington, J. L. (2016) Relational Database Design and Implementation. 4th edn. Amsterdam: Elsevier Inc.

Supplementary readings:
1. Churcher, C. (2012) Beginning Database Design: From Novice to Professional. New York City: Apress.