University Computer Science

Database Systems

Relational database design, data modeling, SQL querying, and the architectural structure of database management systems (DBMS).

Curriculum / Syllabus

  1. Relational Model and Relational Algebra
  2. Entity-Relationship (ER) Modeling
  3. SQL (DDL, DML, Advanced Queries)
  4. Normalization (1NF, 2NF, 3NF, BCNF)
  5. Transaction Management and Concurrency Control
  6. Indexing and Query Optimization

Exam & Course Strategy

Evaluates the ability to write complex SQL queries, translate a given scenario into an ER diagram, and normalize relational database schemas.

Book a Free Trial Lesson