Level 1 of 3
Beginner Level
Prerequisites
Basic computer use. Experience with spreadsheets is helpful but not required. No programming experience is needed.
Duration
4 weeks · 52 guided hours · 5 modules. Taught live by an instructor — online or in person.
By the end of this level you can
- Explain what a relational database is and when to use one instead of a spreadsheet
- Write SQL to read, add, change and delete data
- Filter, sort, join and summarise data from several tables
- Produce simple report queries for an organisation
- Apply basic care: indexes, backups and access control
Modules
- 1Module 1 · 10 h · 3 lessons · free taster lessonRelational Databases and First Queries
- 2Module 2 · 11 h · 3 lessons · free taster lessonFiltering and Sorting with SQL
- 3Module 3 · 10 h · 3 lessons · free taster lessonKeys, Relationships and Joins
- 4Module 4 · 11 h · 3 lessons · free taster lessonAggregation and Reporting Queries
- 5Module 5 · 10 h · 3 lessons · free taster lessonDatabase Care: Indexes, Backups and Access
- Free course quizQuick Quiz — Database Management Basics
Beginner level project
School Fees Database
A small database for a secondary school that records students, classes, fees and payments and answers the bursar's everyday questions with SQL.
Deliverables
- A schema script creating at least four related tables with keys and constraints
- Sample data for at least 30 students using invented names
- Ten report queries, such as balances per student, unpaid students per class and collections per month
- A backup file and a one-page note on who may access what
Assessed on
- Tables are related correctly with primary and foreign keys
- Every report query returns correct results, checked against hand calculations
- Constraints reject invalid data such as negative payments
- A backup can be restored into an empty database
All levels are taught live by an instructor — online or in person — see registration options.