Data Science and Artificial Intelligence

Database basics and query language

Integrated course, 2.50 ECTS

 

Course content

Area 1: Introduction and basic terms
- Database models including historical development
- Architectural layers
Area 2: Relational databases
- Basic terms of the relational data model
- Data modeling using the entity relationship model
- Integrity conditions and normal forms
- Denormalization
Area 3: SQL
- Relational operators
- Data Query Language (DQL)
- Data Manipulation language (DML)
- Data Definition Language (DDL)
- Data Control Language (DCL)
Area 4: Special topics
- Distributed and federated database systems
- NoSQL databases
- Data security

Learning outcomes

The students have a profound understanding of important basics and relationships in the field of relational databases. They are also able to normalize databases and consequently create SQL statements. In addition, they have conceptually familiarized with distributed and federated database systems, NoSQL databases and important principles of data security.

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