01

Database Systems

Designing tables, writing queries and running a local MariaDB server.

Course notes 1 file

Database Systems — full notes

Tables, keys, normalisation and SQL queries.

Open PDF Download

Software 1 item

XAMPP Server

A free Apache distribution bundling MariaDB, PHP and Perl. Quick to install and easy to run on your own machine.

Download
02

Video Editing

Cutting, sequencing, colour and export settings for finished video.

Course notes 1 file

Video Editing — full notes

Timeline basics through to final export.

Open PDF Download

Software 1 item

Adobe Premiere Pro

The editor used throughout this module.

Download
03

Web Development Essentials

Three parts, taken in order: structure, styling, then behaviour.

Course notes 3 files

HTML

Page structure, elements, forms and tables.

Open PDF Download

CSS

Selectors, the box model, layout and responsive design.

Open PDF Download

JavaScript

Variables, functions, events and the DOM.

Open PDF Download

Software 1 item

Visual Studio Code

The code editor used for every exercise in this module.

Download
04

Graphic Design

Vectors, photo work and print-ready artwork across three applications.

Course notes 1 file

Graphic Design — full notes

Layout, colour, typography and file formats.

Open PDF Download

Software 3 items

CorelDRAW

Vector drawing and page layout.

Download

Adobe Photoshop CC 2024

Photo editing and raster artwork.

Download

Adobe Illustrator CC 2024

Logos, icons and scalable vector artwork.

Download
05

Capstone Project

Put all four modules together in one finished piece of work. Browse past projects and the current brief.

Browse projects