This program discusses the specialised skills for designing and using relational databases. It is a core unit in this advanced and applied IT course. The training provides students with an in depth knowledge of the daily administration of the relational database. SQL is the standard language used in industry for storing information such as websites and business applications. On successful completion of this unit, students will be able to:
1. Abstract data requirements into data models using entity-relationship model and design relational databases;
2. Design proper queries with SQL language to adapt and translate data into useful information to users;
3. Assess and rationalise database design with functional dependencies and normal forms;
4. Propose and devise query optimisation, transaction and security management for relational database management systems;
5. Exhibit mastery of theoretical knowledge and ability of creative application relating to the Relational Data Model and Relational Database Management Systems.
- Lectures 0
- Quizzes 0
- Duration 6 months
- Skill level All levels
- Students 0
- Assessments Self
