Certified in Data Resource Management

Wishlist Share
Share Course
Page Link
Share On Social Media

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

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
No Review Yet