This module focuses on relational databases, introducing you to database software, design, creation, management and implementation. It begins with conceptual entity-relationship design, followed by logical database design and physical database creation. You will learn to design and implement a relational database using various interfaces, such as the bash terminal, phpMyAdmin, and MySQL Workbench.
You will become proficient in applying the principles of CRUD (Create, Read, Update, Delete) via Structured Query Language (SQL) and gain knowledge about the concept of normalisation, including normal forms and how they reduce redundancy and duplication. Additionally, you will develop skills in writing stored procedures, managing transactions, and creating triggers, as well as accessing databases through third-party applications and programs.
