Learning Centreby learnwhatyouwant.co.uk
Sign inStart learning
Back to Discover

Technology · Data & analytics

SQL and Databases from Scratch: Query, Manage, and Understand Your Data

A practical, hands-on course for UK adult learners with no prior experience. You will learn what databases are, how to design simple tables, and how to write SQL queries to find, add, update, and delete data. By the end, you will be able to work confidently with real-world data sets using free tools

150 min5 modulesBeginner friendly
Start this free course

Free to take. This course does not use any Learning Credits.

What you’ll be able to do

By the end of this course, you will be able to create a simple relational database, write basic SQL queries (SELECT, INSERT, UPDATE, DELETE), filter and sort data, and understand how databases are used in everyday business contexts

Course outline

A clear route from first principles to practical confidence

  1. 01

    Module 1: What Is a Database and Why Does It Matter?

    • Databases vs Spreadsheets: When to Use Which
    • Key Concepts: Tables, Rows, Columns, and Primary Keys
    • Installing and Exploring a Free Database Tool (SQLite)
  2. 02

    Module 2: Your First SQL Queries – Reading Data

    • The SELECT Statement: Choosing Columns and All Data
    • Filtering Rows with WHERE and Comparison Operators
    • Sorting Results with ORDER BY and Limiting Output
  3. 03

    Module 3: Adding, Changing, and Removing Data

    • Inserting New Rows with INSERT INTO
    • Updating Data with UPDATE and WHERE
    • Deleting Rows with DELETE – and How to Avoid Mistakes
  4. 04

    Module 4: Working with Multiple Tables

    • Understanding Table Relationships: One-to-Many and Many-to-Many
    • Joining Tables with INNER JOIN
    • Using LEFT JOIN to Keep All Records from One Table
  5. 05

    Module 5: Designing a Simple Database from Scratch

    • Planning Your Database: Identifying Tables and Relationships
    • Creating Tables with CREATE TABLE and Setting Data Types
    • Putting It All Together: A Mini Project (e.g., a Customer Orders Database)