
About Course
This course covers the fundamental concepts of database systems. Topics include data models (ER, relational, and others); query languages (relational algebra, SQL, and others); implementation techniques of database management systems (index structures, concurrency control, recovery, and query processing); management of semi structured and complex data; distributed and no SQL databases.
Prerequisites: CSCI E-22Links to an external site. or the equivalent, and strong programming skills in Java.
About the instructor
ZU
Course Curriculum
Module 1
-
Introduction database design and ER models
-
The relational model, relational algebra and SQL
-
Storage and indexing
Module 2
-
The logical-to-physical mapping; a key-value store Problem
-
Transactions
-
Concurrency control Problem
-
Assignments
Module 3
-
Semi structured data and XML Problem
-
XML (cont.); object-oriented/object-relational models
-
Distributed databases and replication
-
Performance tuning; wrap-up and conclusions
-
Assignments
Exam
-
Exam
Download eBooks
-
Download eBooks
Student Ratings & Reviews
No Review Yet