Syllabus
Title
1921 Database Systems
Instructors
Dr. Amr Azzam, M.Sc.
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
09/09/20 to 09/30/20
Registration via LPIS
Registration via LPIS
Notes to the course
Subject(s) Bachelor Programs
Dates
Day | Date | Time | Room |
---|---|---|---|
Thursday | 10/15/20 | 08:45 AM - 12:00 PM | Online-Einheit |
Thursday | 10/22/20 | 08:45 AM - 12:00 PM | Online-Einheit |
Thursday | 10/29/20 | 08:45 AM - 12:00 PM | Online-Einheit |
Thursday | 11/05/20 | 08:45 AM - 12:00 PM | Online-Einheit |
Thursday | 11/12/20 | 08:45 AM - 12:00 PM | Online-Einheit |
Thursday | 11/19/20 | 08:45 AM - 12:00 PM | Online-Einheit |
Thursday | 12/03/20 | 08:45 AM - 12:00 PM | Online-Einheit |
On this page:
- Der Kurs findet im Distanzmodus zu den angegebenen Kursterminen statt. Wir wechseln auf eine Online-Kursumgebung (MS Teams etc.).
- Die Teilnahmevoraussetzungen, die Lehrmethode, die Aufgaben und die Bewertung bleiben wie im Lehrplan beschrieben. Ein Wechsel des Lehrmodus (Online-Lernen) hat keine Auswirkungen auf den Lehrplan.
- Theoretical and Practical Aspects of DBMS.
- Relational Model (basis, relational algebra, data description and data manipulation)
- Relational Theory (Semantic constraints, functional dependencies, normal forms)
- Transactions (ACID principle, correctness, parallel processing)
- Optimization (Indexes, Query Plan)
- Structured Query Language SQL
- NoSQL databases (Key-Value stores, document DBs, GraphDBs, Semantic Web triple stores)
- In-Memory DBs
- Big Data, Google BigTable, etc.
- Understanding of DBMS and ability to apply DBMS in practice
- Understanding of the relational model and the basic concepts of the relational theory
- Understanding of the basic concepts of transactions and optimizations
- Ability to formulate SQL statements to solve practical problems
- Integration of DB and websites (PHP)
- Basic ideas of non-relational DBs, including graph databases and NoSQL stores
- Current scalability issues (Big Data)
- Lessons and computer exercises with DBMS on Linux servers
- Active participation in solving tasks using DBMS
- Repetitions of lesson content in front of your colleagues
- Peer Review (review each others’ work)
- Presentation of a final project
- 40% - Homeworks submitted via learn@WU
- 20% - Test
- 25% - Presentation of final project (a small database application)
- 15% - Commitment in class
Nach Ende der Anmeldefrist werden verfügbare LV-Plätze den Studierenden der Warteliste, die noch keine gültige Anmeldung zum Planpunkt haben, gereiht nach Studienfortschritt zugeteilt, nicht nach Wartelistenplatz.
Last edited: 2020-07-15
Back