Overview
This course covers database fundamentals, including design principles and Structured Query Language (SQL). Learners will create, query, and manage data using relational database systems.
Aims and Objectives
To equip learners with practical skills in database structure, design, and data retrieval through SQL queries.
Course Content
Database concepts and relational models
Tables, keys, and relationships
SQL commands: SELECT, INSERT, UPDATE, DELETE
Filtering, sorting, and joining data
Database design and normalisation
Practical exercises using SQL tools
Learning Outcomes
On completion of this course, learners will be able to:
- Design and structure simple databases
- Write SQL queries to manage and analyse data
- Apply data relationships and integrity principles
- Use SQL tools to retrieve and manipulate information
