← Course catalogue

DBS-201Intermediate

Databases

SQL & MySQL Database Development

Design relational databases and write dependable SQL for operational applications.

Part of these pathways

Data and databases

Course outline: enrolment opens after THNF content and assessment review.

What you will be able to do

Clear outcomes. Practical evidence.

Normalise relational data
Write joins and subqueries
Use transactions and constraints
Back up and restore MySQL

Course structure

Modules and lessons

Relational databases and MySQL setup

Explain and apply tables, rows, columns, keys, schema, client/server to a tested, privacy-safe solution.

Relational databases and MySQL setup60 min

ER modelling and normalisation

Explain and apply entities, attributes, cardinality, 1NF, 2NF, 3NF to a tested, privacy-safe solution.

ER modelling and normalisation60 min

DDL, constraints and referential integrity

Explain and apply CREATE/ALTER/DROP, data types, PK, FK, UNIQUE, CHECK, NOT NULL to a tested, privacy-safe solution.

DDL, constraints and referential integrity60 min

CRUD and transactions

Explain and apply INSERT, SELECT, UPDATE, DELETE, START TRANSACTION, COMMIT, ROLLBACK to a tested, privacy-safe solution.

CRUD and transactions60 min

Queries, filtering, functions and aggregation

Explain and apply WHERE, ORDER BY, LIKE, CASE, COUNT/SUM/AVG, GROUP BY, HAVING to a tested, privacy-safe solution.

Queries, filtering, functions and aggregation60 min

Joins, subqueries and views

Explain and apply INNER/LEFT joins, aliases, correlated subquery, CTE, view to a tested, privacy-safe solution.

Joins, subqueries and views60 min

Indexes, users, backup and recovery

Explain and apply B-tree index, EXPLAIN, least privilege, dump, restore, recovery test to a tested, privacy-safe solution.

Indexes, users, backup and recovery60 min

Capstone operational database

Explain and apply requirements, ERD, schema, seed data, queries, security, recovery to a tested, privacy-safe solution.

Capstone operational database60 min

Access and progression

Know what the course requires.

The required capability matters; the learner does not have to personally own every device.

Who it is for

Aspiring developers, technical learners, career changers and practitioners seeking applied computing skills.

Hardware access

Personal 64-bit computer with 4 GB RAM and 20 GB free, or use the required device and software at a readiness-approved THNF centre.

Software and practical access

Course software is available through the text-first pack, an approved offline installer or a readiness-approved THNF centre.

Possible progression

Junior development, data, web, application-support or technical-project progression appropriate to the completed portfolio.

Progression is not a guarantee of employment or external certification.

Sierra Leone context

Mobile-first, low-data solutions for Sierra Leonean schools, traders, transport, agriculture, NGOs and SMEs using synthetic local names, districts and NLe values.

Skills in context

Career directions and next steps

These are realistic directions that the skills can support—not promises of employment, job titles or external certification.

Junior data assistant
Database-support assistant
Reporting and information assistant

Possible progression pathways

Data and databases