General information
| Course type | AMUPIE |
| Module title | Database administration |
| Language | English |
| Module lecturer | dr Andrzej Wójtowicz |
| Lecturer's email | andre@amu.edu.pl |
| Lecturer position | assistant professor |
| Faculty | Faculty of Mathematics and Computer Science |
| Semester | 2025/2026 (winter) |
| Duration | 30 |
| ECTS | 3 |
| USOS code | 06-DDATLI0-E |
Timetable
The classes will be scheduled intensively throughout the beginning of the semester, with approximately three sessions, each dedicated to a different database engine.
Module aim (aims)
The aim of the course is to practice the basic administrative tasks related to database systems. The classes focus on the installation of a database server, user and data management, indexes and partitioning, as well as command-line tools for communicating with the database server and for data import/export. The course is conducted on three database systems: MySQL, Microsoft SQL Server, and PostgreSQL.
Pre-requisites in terms of knowledge, skills and social competences (where relevant)
- Completed a basic course in databases.
- Proficiency in handling a virtual machine and the shell in a Linux system.
Syllabus
- MySQL: server installation; basics of the mysql tool; encoding and collation.
- MySQL: access control, privilege tables, accounts, roles.
- MySQL: account and password management, authentication plugins, proxies and grants.
- MySQL: backups and data recovery.
- MySQL: partitioning.
- Microsoft SQL Server: server installation; basics of the sqlcmd tool; encoding and collation.
- Microsoft SQL Server: mssql-cli tool, access control, accounts, roles, permissions.
- Microsoft SQL Server: database schema management, data masking methods.
- Microsoft SQL Server: file management, backups.
- Microsoft SQL Server: partitioning.
- PostgreSQL: server installation; basics of the psql tool; encoding and collation.
- PostgreSQL: roles, attributes, authentication, permissions.
- PostgreSQL: password management, schemas, search path.
- PostgreSQL: tablespaces, backups.
- PostgreSQL: partitioning.
Reading list
- Mehta, C., Bhavsar, A., Oza, H., & Shah, S. (2018). MySQL 8 Administrator's Guide: Effective guide to administering high-performance MySQL 8 solutions. O'Reilly.
- Korotkevitch, D. (2016). Pro SQL Server Internals (2nd ed.). New York, NY: Apress.
- PostgreSQL Global Development Group (n.d.). PostgreSQL Documentation Manual.