Intermediate Certificate11 lessons8 hours2 monthsPhysical & online
Databases & SQL
Design a database that will not fall over, and ask it questions in SQL - the skill behind almost every business system.
What you'll learn
- What a database is, and why not a spreadsheet
- Tables, rows, columns and keys
- Designing a schema that survives change
- Normalisation, in plain language
- SELECT: asking your first questions
- WHERE, ORDER BY and LIMIT
- JOIN: pulling answers from several tables
- GROUP BY and the aggregate functions
Single lessons: UGX 5,000–UGX 15,000 by Mobile Money. Read more
Pay for just the lesson you need, or the whole course. Tick lessons as you finish, and use the quiz to test yourself before your assessment.
Video lessons
- Coming soon
What a database is, and why not a spreadsheet
35 min
- Coming soon
Tables, rows, columns and keys
45 min
- Coming soon
Designing a schema that survives change
60 min
- Coming soon
Normalisation, in plain language
45 min
- Coming soon
SELECT: asking your first questions
60 min
- Coming soon
WHERE, ORDER BY and LIMIT
45 min
- Coming soon
JOIN: pulling answers from several tables
60 min
- Coming soon
GROUP BY and the aggregate functions
60 min
- Coming soon
INSERT, UPDATE, DELETE - and transactions
45 min
- Coming soon
Indexes: why a query is slow
45 min
- Coming soon
Backups, restores and keeping data safe
40 min