Database development

Module title:

Database development

Module overview:

The aim of the module is to familiarize students with writing programming code in relational databases when creating objects (views, procedures, triggers, functions), using transactions and applying data access optimization methods. As part of the module, students are introduced to the basics of non-relational databases.
This is the central module within the study program and represents the basis for other modules that students enrol in in the coming semesters. Acquired skills significantly contribute to the professional development of students in related professional fields.
The module is taught in the Transact-SQL dialect of the SQL programming language. The final evaluation is based on solving a series of small practical tasks using the default client tools for database management in order to connect to the existing database.

In this module students will learn:

database objects including views, stored procedures, triggers, user-defined table and scalar functions.

how to write SQL code for CRUD operations.

how to optimize data access with indexes.

transactions and isolation levels.

Literature:

Required readings:
1. Petkovic, D. (2020) Microsoft SQL Server 2019: A Beginner´s Guide. 7th edn. Austin: Oracle Press.

Supplementary readings:
1. Dye, D. et al (2015) SQL Server T-SQL Recipes. 4th edn. New York City: Apress.