Database systems are central to most organizations’ operations. At any organizational level, users can expect to have frequent interaction with databases, and to use then to prepare useful analytics. Therefore, understanding capabilities and limitations of databases, knowing how to access data, knowing how to effectively use the information stored in such database systems, and skills in designing database systems is a distinct advantage and necessity today. The Relational Database Management System (RDBMS) is the dominant type of database systems and is the primary focus of this course.
This core course will cover topics such as: the relational data model (data structure, data integrity, and data manipulation), entity-relationship modelling, normalization, as well as the structured query language (for creating data structures and constraints, for managing tables’ content, and for creating variety of queries that address business scenarios).
Further, to provide students with opportunity to apply the knowledge learnt from lectures, various homework assignments, SQL assignments, and a database implementation project will be given.
There are no pre-requisites for this class.