Learn CSIT
CSC-475Databases

Advanced Database

Semester VIII3 credit hours
5
Units
20
Lessons
0
Labs

Beyond the relational model: object-oriented and distributed databases, NoSQL, data warehousing, and database administration.

What you'll learn

The key areas this subject covers, mapped to the official curriculum.

    Course units

    The structured path through this subject.

    1. 1

      Enhanced Entity Relationship Model and Relational Model

      Extending the relational model: the Enhanced ER model with specialization and generalization, and mapping it onto the relational schema.

      4 topics · 4 lessons available

    2. 2

      Object and Object Relational Databases

      Objects in the database: object-oriented modeling, how object databases differ from relational ones, and the bridge of object-relational systems.

      4 topics · 4 lessons available

    3. 3

      Query Processing and Optimization

      Making queries fast: translating SQL into execution plans, the algorithms behind joins and sorts, and how the optimizer chooses.

      4 topics · 4 lessons available

    4. 4

      Distributed Databases, NOSQL Systems, and BigData

      Databases beyond one machine: distribution strategies, the NoSQL family, and the scale of big data systems.

      4 topics · 4 lessons available

    5. 5

      Advanced Database Models, Systems, and Applications

      Specialized systems and applications: active databases, deductive databases, temporal and spatial data, and the role of databases in modern applications.

      4 topics · 4 lessons available

    Subject details

    Code
    CSC-475
    Credit hours
    3
    Semester
    Semester VIII
    Category
    databases