This unit aims to enable learners to understand different database models, including common relational databases. It also equips them with the skills and knowledge to write SQL database queries and perform administrative tasks.
It is designed for learners seeking to develop a career in computing and information systems. It equips learners with the knowledge and understanding required to understand different database models and to apply the principles associated with relational databases. The unit will equip learners with the knowledge and skills to write SQL query statements that manipulate data in a database as well as how to perform basic administrative tasks.
After successfully completing this unit, the learner will:
1. Analyse database models
2. Analyse the principles of relational database systems
3. Apply the process of database normalisation
4. Apply SQL by writing database queries
5. Analyse how to perform basic database administration