# 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
- Rules of relational DBMS (Codd)
- ACID properties
- CRUD applications
- CAP theorem
- 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, Global Edition](https://www.pearson.de/fundamentals-of-database-systems-global-edition-9781292097619) - 7th Edition
3. 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)
## Weblinks
1. [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-------)
2. [MariaDB Databases 101](https://go.mariadb.com/MariaDB101-2024-10-16_Registration-LP.html)
3. [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)
4. [Codd's 12 rules](https://en.wikipedia.org/wiki/Codd%27s_12_rules)
5. [Liste von aktuellen Datenbanksystemen](http://de.wikipedia.org/wiki/Liste_der_Datenbankmanagementsysteme)
6. [Genealogy of RDBMS](https://hpi.de/news/jahrgaenge/2015/hpi-wissenschaftler-geben-ueberblick-zu-datenbanksystemen.html)
7. [Comparison of relational database management systems](http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems?wprov=sfla1)
8. [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)
9. [Choosing The Right Database](https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77)
10. [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/)
11. [Top 11 Open Source Database for Your Next Project](https://geekflare.com/open-source-database/)
12. [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)
•[TU](https://dbis.cs.tu-dortmund.de/lehre/) [Dortmund - Lehrstuhl Datenbanken und Informationssysteme](https://dbis.cs.tu-dortmund.de/lehre/) [– Lehre](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)
### Professional/commercial 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)