Semester: 3
ECTS: 5
Lectures: 30
Practice sessions: 30
Independent work: 90
Module Code: 24-00-512-E
Semester: 3
ECTS: 5
Lectures: 30
Practice sessions: 30
Independent work: 90
Module Code: 24-00-512-E

Module title:


Database development

Lecturers and associates:


Mario Fabijanić, Lecturer
Matija Kolarić

Module overview:


This module introduces students to writing programming code in relational databases and applying methods of data access optimization.

This module is core to the Software Engineering subspecialisation and provides the foundation for a wide number of programming modules that students of the Applied Computer Engineering study programme will take in the following semesters. Skills learnt in this module will contribute significantly to students’ development as professionals in respecting field.

Students will learn:
• Database objects including views, stored procedures, triggers, user-defined tables, and scalar functions.
• How to write SQL code for CRUD operations.
• How to optimize data access with indexes.
• Transactions and isolation levels.

The module is taught in Transact-SQL dialect of SQL programming language. The module assessment is based on solving a series of smaller practical tasks by using a defined database client tool to connect to an actual database.

Literature:


Essential reading:
1. Petkovic, D. (2020) Microsoft SQL Server 2019: A Beginner's Guide. 7th edn. Austin: Oracle Press.

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