Data Science and Artificial Intelligence

Relational Database Management

Integrated course, 2.50 ECTS

 

Course content

Area 1: Basic topics
- Installation and setup of a relational database system
- Creation of relational databases and import/export of data records
- Rights concept and user administration
- SQL statements (DQL, SML, DDL, DCL)
- Views and indexes
Area 2: Advanced topics
- Stored procedures, functions, transactions and triggers
- File groups, FileTables, partitions and cursors
- Memory optimization and encryption
- Spatial and hierarchical data types

Learning outcomes

Students have extensive skills in practical management of relational databases. They are also able to optimize relational databases through various measures.

Recommended or required reading and other learning resources / tools

Recommended Literature and Books:
- Davidson, L. (2017). Exam Ref 70-762 Developing SQL-Databases. Microsoft Press, 1. Auflage.
- Emrich, M. (2013). Datenbanken & SQL für Einsteiger: Datenbankdesign und MySQL in der Praxis. CreateSpace Independent Publishing Platform, 3. Auflage.
- Itzik, B. (2017). Exam Ref 70-761 Querying Data with Transact-SQL. Microsoft Press, 1. Auflage.
- Konopasek, K. (2018). SQL Server 2017: Der schnelle Einstieg. Carl Hanser Verlag GmbH & Co. KG, 1. Auflage.
- Kudraß, T. (2015). Taschenbuch Datenbanken. Carl Hanser Verlag GmbH & Co. KG, 2. Auflage.
- Mertins, D., et. al. (2016). SQL Server 2016: Das Programmierhandbuch. Inkl. ADO.NET Entity Framework und Migration von SQL Server 2014. Rheinwerk Computing, 7. Auflage.
- Vossen, G. (2008). Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme. De Gruyter Oldenbourg, 5. Auflage.
Recommended journals and selected articles: All relevant journals and articles will be announced in the course. Typical software for this module: Microsoft SQL Server, Microsoft SQL Management Studio, MySQL, SQLite etc.

Mode of delivery

1,25 ECTS Lecture, 1,25 ECTS Exercise

Prerequisites and co-requisites

none

Assessment methods and criteria

Lecture: final exam, Exercise: examination character