CAT4-06 · Information Technology & Digital Skills

Database Design & Administration (MySQL/PostgreSQL)

Relational database design from ER modelling through SQL querying, stored procedures, user administration, backup and recovery, and basic performance tuning in MySQL and PostgreSQL.

What you will learn

• Design a normalised relational schema from a set of business requirements using ER modelling
• Write SQL queries including joins, aggregation functions, subqueries, and views
• Administer database users, roles, permissions, and backup and restore procedures
• Apply basic indexing and query optimisation techniques to improve database performance

Who it's for

Basic computing knowledge required; useful alongside CAT4-03 or CAT4-05.