This course will equip students with ICT skills which include theory and practical of fundamental concepts of database management systems, data modelling techniques, data normalization, Structured Query Language (SQL) and finally, database development process. At the end of this course, youshould be able to take a real world case scenario and create a database that adhere to a user requirements and required functions.
Diploma in Introduction to Databases
Module 1: Introduction to Database Systems
Module 2: Database History
Module 3: Data Modelling
Module 4: Data Models
Module 5: Relational Data Model
Module 6: Entity Relationship Model
Module 7: Integrity Rules and Constraints
Module 8: Relational Design and Redundancy
Module 9: Functional Dependencies
Module 10: Introduction to Data Normalization
Module 11: Introduction to SQL
Module 12: SQL – Data Manipulation Language
Module 13: SQL – Join Statements
Module 14: Database Development Process