INTRODUCTION TO DATABASE SYSTEMS (2/2 Credits)

Learning Outcomes :

On successful completion of this course, student will be able to: Describe concepts, terminologies, environment, and relational model in database system; Apply user role and right access to increase security in database system; Construct query of SQL that suitable with the problem; Design database using structured data model; Recognize database technology concept.

Topics :

Normalization & ER Modeling; Introduction to Databases & The Relational Model; Normalization; SQL – Data Definition; SQL – Data Manipulation (Basic Queries 1); Entity Relationship (ER) Modeling; Enhanced Entity Relationship (ER) Modeling; SQL – Data Manipulation (Basic Queries 2); Quiz; SQL – Data Definition; SQL – Data Manipulation (Basic Queries 1); SQL – Data Manipulation (Multi Table Queries); SQL – Data Manipulation (Basic Queries 3); SQL – Data Manipulation (Basic Queries 2); SQL – Data Manipulation (Multi table Queries); SQL – Data Manipulation (Sub Queries); View; Security and Administration; SQL – Data Manipulation (Sub Queries) & View; Security and Administration; Database Environment; SQL – Data Manipulation & View Exercise; Database Environment & Architectures; Project; Data Warehousing Concepts.