# Introduction to Databases
## Agenda
- What are databases?
- Different forms of data storage and their problems
- About the meaning and structure of data in today’s world
- An approach to Databases and their terminology
- Technical roles and responsibilities
- History of relational DBMS
- Properties of a Database Management System
- Properties of DBMS
- ACID properties of transactions
- CRUD applications of data-driven applications
- CAP theorem for distributed data stores
- Prologue: An Approach to Database Design
- Requirements (real world mapping)
- Conceptual design
- Logical design
- Physical design
- Programming
## Literature References
1. Avi Silberschatz, Henry F. Korth, S. Sudarshan: [Database System Concepts](https://www.db-book.com/db6/slide-dir/index.html), – 6th Edition
2. Ramez Elmasri, Shamkant B. Navathe: [Fundamentals of Database Systems Seventh Edition](https://www.auhd.edu.ye/upfiles/elibrary/Azal2020-01-22-12-28-11-76901.pdf)
3. Nicolai Andler: [Tools für Projektmanagement, Workshops und Consulting](https://nicolaiandler.com/books/german/consulting-toolbox/), 6. überarbeitete Auflage 2015.
4. David Patrishkoff, Robert E. Hoyt: [No-Code Data Science](https://www.lulu.com/shop/robert-e-hoyt-and-david-patrishkoff/no-code-data-science/hardcover/product-kzkkgp.html?q=no+code+data+science&page=1&pageSize=4)
5. Elmasri, R. A., Navathe, S. B.: Grundlagen von Datenbanksystemen, Pearson Studium, München, Boston (u.a.)
6. Faeskorn-Woyke, H., Bertelsmeier, B., Riemer, P., Bauer, E.: Datenbanksysteme: Theorie und Praxis mit SQL2003, Oracle und MySQL, Pearson Studium, München, Boston (u.a.)
7. Kemper, A., Eickler, A: Datenbanksysteme: Eine Einführung, Oldenbourg, München
8. Kleuker, S.: Grundkurs Datenbankentwicklung: Von der Anforderungsanalyse zur komplexen Datenbankanfrage, Teubner, Wiesbaden
9. Preiß, N.: Entwurf und Verarbeitung relationaler Datenbanken, Oldenbourg, München und Wien
10. Saake, G. / Sattler, K.-U. / Heuer, A.: Datenbanken - Konzepte und Sprachen, mitp-Verlag, Bonn
11. Schubert, M.: Datenbanken: Theorie, Entwurf und Programmierung relationaler Datenbanken, Teubner, Wiesbaden
12. Steiner, R.: Relationale Datenbanken: Einführung in die Praxis der Datenbankentwicklung für Ausbildung, Studium und IT-Beruf, Vieweg+Teubner, Wiesbaden
13. Vossen, G.: Datenmodelle, Datenbanksprachen und Datenbankmanagement-Systeme, Oldenbourg, München und Wien
## Weblinks
1. [Learn Relational Database Basics – Key Concepts for Beginners](https://www.freecodecamp.org/news/learn-relational-database-basics-key-concepts-for-beginners/)
2. [When Spreadsheets Aren’t Good Enough: A Lesson in Relational Databases | by Stephanie Lo | Towards Data Science](https://medium.com/towards-data-science/when-spreadsheets-arent-good-enough-a-lesson-in-relational-databases-2e5b0b847f5a?source=tag_recommended_feed---------19-107----------mysql----------766e7f9e_31a6_4cea_a561_86b284318890-------)
3. [MariaDB Databases 101](https://go.mariadb.com/MariaDB101-2024-10-16_Registration-LP.html)
4. [Codd‘s functions of a database](https://blog.triona.de/development/database/die-neun-regeln-von-codd-und-ein-einblick-in-das-formale-relationenmodell.html)
5. [Codd's 12 rules](https://en.wikipedia.org/wiki/Codd%27s_12_rules)
6. [Liste von aktuellen Datenbanksystemen](http://de.wikipedia.org/wiki/Liste_der_Datenbankmanagementsysteme)
7. [Genealogy of RDBMS](https://hpi.de/news/jahrgaenge/2015/hpi-wissenschaftler-geben-ueberblick-zu-datenbanksystemen.html)
8. [Comparison of relational database management systems](http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems?wprov=sfla1)
9. [Databases on AWS: How To Choose The Right Database](https://aws-de-marketing.s3-eu-central-1.amazonaws.com/Field%20Marketing/Summit-Berlin-2019/Presentations/AWS_Summit_Berlin_2019_Feb26_ChoosingTheRightDatabase.pdf)
10. [Choosing The Right Database](https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77)
11. [SE Radio #364: Peter Zaitsev on Choosing the Right Open Source Database](https://www.se-radio.net/2019/04/364-peter-zaitsev-on-choosing-the-right-open-source-database/)
12. [Top 11 Open Source Database for Your Next Project](https://geekflare.com/open-source-database/)
13. [NoSQL Database Types](https://database.guide/nosql-database-types/)

## Further Orientation

### Online academic or commercial resources like bootcamps, courses & lectures (MOOC)
- [Open HPI](https://open.hpi.de/courses) [– Courses](https://open.hpi.de/courses)
- [SAS Academic Program for Students](https://www.sas.com/de_de/learn/academic-programs/students.html)
- [TU Dortmund - Lehrstuhl Datenbanken und Informationssysteme](https://dbis.cs.tu-dortmund.de/lehre/)
- [LUH Data Science Lab – Leibniz Universität Hannover](https://www.data-lab.uni-hannover.de/de/schulung/)
- [Technische Hochschule Mittelhessen - Vorlesung Datenbanksysteme](https://esb-dev.github.io/dbs.html)[](https://dbis.cs.tu-dortmund.de/lehre/)
- [Grundlagen: Datenbanken - Lehrstuhl für Datenbanksysteme - TU München](https://db.in.tum.de/teaching/ws2021/grundlagen/?lang=de)
### Social media for relevant contents in the realm of Data Engineering
- [Software Engineering Radio – The Podcast for Professional Software Developers](https://se-radio.net/)
- [Data Engineering Podcast](https://www.dataengineeringpodcast.com/)
- [Data Culture Podcast](https://www.linkedin.com/company/data-culture-podcast/?lipi=urn%3Ali%3Apage%3Ad_flagship3_detail_base%3BbR9rruYRTCefx%2F7Vvf40pg%3D%3D)
- [Data Skeptic Podcast](https://dataskeptic.com/podcast)
- [Towards Data Science](https://towardsdatascience.com/)
### Other learning materials (Anki cards, quizzes, online simulators etc.)
- [Introduction to Databases - AnkiWeb](https://ankiweb.net/shared/info/1163619738)
- [Fundamentals of Database Systems - 9780133970777 - Solutions and Answers | Quizlet](https://quizlet.com/explanations/textbook-solutions/fundamentals-of-database-systems-7th-edition-9780133970777)
- [Introduction to Databases | Quizizz](https://quizizz.com/admin/quiz/6568e786f53eae568a7d7ac0?source=quiz_share)
### Certification opportunities, e.g. with Public Cloud providers (starter level)
- [Google Cloud Digital Leader](https://cloud.google.com/learn/certification/cloud-digital-leader?hl=de)
- [AWS Cloud Practitioner](https://aws.amazon.com/de/certification/certified-cloud-practitioner/)
- [Microsoft Azure Fundamentals](https://learn.microsoft.com/en-us/credentials/certifications/azure-fundamentals/?practice-assessment-type=certification)