"Databases" is both a book and a course held at Hefei University (合肥大学). We here provide all the resources of this course.
The goal of the course and book is to teach undergraduate and graduate students the topic of databases. Our focus is a practice-oriented approach to the topic. This means that each concept that we introduce or discuss is always accompanied by a rich set of examples. In the course we will use many tools, ranging from
- the PostgreSQL database management system, over
- yED, a graph editor that can be used for conceptual modeling,
- LibreOffice Base, which can be used as convenient front end for creating forms and reports for data in a database,
- Python, a programming language which can connect to PostgreSQL by using the Psycopg module, to the
- pgModeler, a tool with which we can conveniently design logical PostgreSQL database schemas.
After completing the course, you should be able to productively work with databases, at least at a beginner level. You should be able to realize simple database-based applications. And you should be able to navigate the huge ecosystem of different database management systems, tools, and paradigms in this field in order to pick the right tool for the right problem.
This is work in progress, as I just began writing this book.
The website with up-to-date information about the course is https://thomasweise.github.io/databases.
The book itself can be downloaded as pdf at https://thomasweise.github.io/databases/databases.pdf.
The slides in German language can be found at https://thomasweise.github.io/databasesSlidesDE and are listed here:
- Organisation
- Einleitung
- Anforderungen an ein Datenbankmanagementsystem
- Geschichte
- Software und Literatur
- Installation von PostgreSQL
- Beispiele Herunterladen
- Fabrik-Datenbank: Benutzer und Datenbank
- Fabrik-Datenbank: Tabelle
product - Fabrik-Datenbank: Tabelle
customer - Fabrik-Datenbank: Tabelle
demand - Fabrik-Datenbank: Joins und Views
- Fabrik-Datenbank: Daten ändern und löschen
- Python Installieren — Slide-Set 03 der Schwestervorlesung "Programming with Python"
This is a practice-oriented course on databases. Therefore, we also provide a set of examples. The examples that we provide are all "real" in the sense that they can actually be executed and their results are actually presented in the book. All of them are available in the online repository https://github.com/thomasweise/databasesCode.
The book is written in LaTeX. You can find its sources in https://github.com/thomasWeise/databases. You may use these files under the licensing terms provided below.
This repository contains two types of material: Materials that I (Thomas Weise) have created by myself and such that have been created by others.
The vast majority of the material is teaching material created by me (Thomas Weise). This and only this material is released under the Attribution-NonCommercial-ShareAlike 4.0 International license (CC BY‑NC‑SA 4.0), see http://creativecommons.org/licenses/by-nc-sa/4.0 for a summary.
However, the repository also includes some images and figures created by others, which are marked explicitly and licensed under their authors' terms. For example, all logos and trademarks are under the copyright of their respective owners. The list of files not under the CC BY‑NC‑SA 4.0 license but under their individual owner's copyrights includes, but is not limited to:
- the LibreOffice Logo, e.g.,
- text/main/introduction/software/libreofficeLogo.pdf
- text/main/introduction/software/libreofficeLogo.svg
- the MariaDB Logo, e.g.,
- text/main/introduction/software/mariadbLogo.pdf
- text/main/introduction/software/mariadbLogo.svg
- the PgModeler Logo: This logo is under the copyright of Raphael Araújo
eSilva, e.g.,- text/main/introduction/gettingStarted/pgmodelerLogo.pdf
- text/main/introduction/gettingStarted/pgmodelerLogo.svg
- the PostgreSQL Logo, e.g.,
- text/main/introduction/software/postgresqlLogo.pdf
- text/main/introduction/software/postgresqlLogo.svg
- the Psycopg Logo: Copyright (c) Gabriella Albano and the Psycopg team, e.g.,
- text/main/gettingStarted/psycopgLogo.pdf
- text/main/gettingStarted/psycopgLogo.svg
- the Python Logo, e.g.,
- text/main/gettingStarted/pythonLogo.pdf
- text/main/gettingStarted/pythonLogo.svg
- the SQLite Logo, e.g.,
- text/main/introduction/software/sqliteLogo.pdf
- text/main/introduction/software/sqliteLogo.svg
- the yEd Logo: The yEd logo is protected by copyright. yEd is a registered trademark of yWorks GmbH. Unauthorized use, reproduction, or distribution is strictly prohibited., e.g.,
- text/main/introduction/gettingStarted/yEdLogo.pdf
- text/main/introduction/gettingStarted/yEdLogo.svg
You can download its newest version of the course material from https://thomasweise.github.io/databases. This version may change since this course and book both are work in progress. You can cite this book as follows:
@book{databases,
author = {Thomas Weise},
title = {Databases},
year = {2025},
publisher = {Institute of Applied Optimization,
School of Artificial Intelligence and Big Data,
Hefei University},
address = {Hefei, Anhui, China},
url = {https://thomasweise.github.io/databases}
}
If you have any comments or suggestions regarding the book, or if you spotted an error or typo, please feel free to submit an issue here. Your feedback would help us to improve the book.
We statically include the pdfsizeopt tool in the build process of our book via the bookbase repository and use it during the book compiling and building process to compress the book pdf file. This tool is excluded from the license mentioned above. It is under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991 and the copyright belongs to its authors.
If you have any questions or suggestions, please contact Prof. Dr. Thomas Weise (汤卫思教授) at the Institute of Applied Optimization (应用优化研究所, IAO) of the School of Artificial Intelligence and Big Data (人工智能与大数据学院) of Hefei University (合肥大学), in Hefei, Anhui, China (中国安徽省合肥市) via email to [email protected] with CC to [email protected].