Introduction to Database Structure and Query Languages

Course Objective
To provide a standard introduction to RDBMS and SQL

Learning Outcomes

At the end of the course the student should be able to

Explain the concepts of relational database management system (RDBMS)

Use query languages effectively to extract data and creates reports

Detailed Syllabus

  1. Introduction to the Course
  2. Data Models
  3. The Relational Database Model (RDBMS)
  4. Entity Relationship (ER) Modeling
  5. Normalization of Database Tables
  6. Introduction to SQL
  7. Advanced SQL functions.