Course Description
Every modern application sits on top of a database. You will learn how to design relational databases properly — from conceptual data modelling through entity-relationship diagrams to normalised, optimised schemas. You will master SQL: data definition, data manipulation, complex joins, subqueries, and constraints. You will also study the security side: user roles, access control, encryption options, backup and recovery, and basic auditing.
What You’ll Do:
You will design and implement complete database systems in MySQL, PostgreSQL, or SQL Server. You will populate it, write a portfolio of queries and reports, and document the security controls you have applied. You will also practise backup and restore procedures and configure audit logs.
Why it matters:
Databases are everywhere — in banking, telecoms, healthcare, government, fintech, e-commerce. This module gives you a skill that is in permanent demand in every industry.
Lessons:
