SkillPath Africa
Beginner

SQL & Databases for Beginners

Read and write real SQL queries against a relational database. By the end you'll be able to select and filter data, combine tables with JOINs, summarise with GROUP BY, and work through a full data-exploration project you can show someone.

8 lessons · 3 levelsKSh 500

Every lesson comes with written notes, a practice task and a knowledge check.

Watch the first lesson free

What a Database Is and Why SQL Matters — Start with the opening chapters ("What is a Database?" and "Tables & Keys") of this full course — the rest is a useful reference to return to later.

Create a free account to watch it. No payment needed.

On a limited data plan? Tap the gear icon (⚙️) in the video player and choose 480p or lower — standard-definition video uses a fraction of the data HD does and still looks fine on a phone.

Level 1 — Foundations

Start from zero: what this skill is, the tools you need, and how to get set up.

Module 1 — Getting Started

  • Lesson 1 — What a Database Is and Why SQL Matters· 4h 21m· ~1877 MB

    Start with the opening chapters ("What is a Database?" and "Tables & Keys") of this full course — the rest is a useful reference to return to later.

    • Say what a database gives you that a spreadsheet does not
    • Read a table in terms of rows, columns, keys and relationships
    • Start practising without installing anything
  • Lesson 2 — SELECT Basics: Retrieving Data· 6 min· ~45 MB

    Your first real queries — SELECT and FROM, and reading what comes back.

    • Write and read a basic SELECT query
    • Know the order the database actually processes a query in
    • Limit what you pull back, for speed and for data cost

Module 2 — How Data Is Actually Stored

  • Lesson 1 — Tables, Keys and How Data Relates· 4h 21m· ~1877 MB

    What a table actually is, and how primary and foreign keys connect one table to another — the idea that makes JOINs make sense later.

    • Describe a table in terms of rows, columns and data types
    • Explain what a primary key is and why every table needs one
    • Explain how a foreign key links one table to another
  • Lesson 2 — Making Your Own Database to Practise On· 4h 21m· ~1877 MB

    Creating tables and putting rows into them — so you have data of your own to query instead of only reading someone else's examples.

    • Create a table with appropriate columns and data types
    • Insert rows into a table you made
    • Explain why practising on your own data beats following along with a sample database

Level 2 — Core Skills

The hands-on skills that make up the day-to-day of this work.

Module 3 — Core Skills in Practice

  • Lesson 1 — Filtering Data with WHERE· 8 min· ~57 MB

    Narrowing a result set down to just the rows you actually want.

    • Filter rows with comparisons, AND, OR and parentheses
    • Handle empty values correctly, which is where beginners get wrong answers
    • Check a destructive change before you make it
  • Lesson 2 — JOINs: Combining Data Across Tables· 35 min· ~255 MB

    INNER, LEFT, and RIGHT joins — pulling related data out of separate tables.

    • Join two tables on a key and read the result
    • Choose between an inner join and a left join deliberately
    • Recognise the two join mistakes that produce wrong numbers

Level 3 — Professional Practice

Work the way professionals do, and take on real projects and clients.

Module 4 — Working Like a Pro

  • Lesson 1 — Grouping and Sorting: GROUP BY and ORDER BY· 8 min· ~59 MB

    Aggregate functions, grouping rows into summaries, and ordering the output.

    • Summarise rows into counts, totals and averages
    • Use HAVING and WHERE in the right places
    • Sort and take the top results correctly
  • Lesson 2 — A Full SQL Data Exploration Project· 1h 17m· ~555 MB

    Working through a real dataset end to end — the kind of project that belongs in a portfolio.

    • Explore an unfamiliar dataset in a deliberate order
    • Check your own findings before you report them
    • Turn the work into something an employer can look at

Spin for a discount

One spin, one discount on this Learning Path.

10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF10% OFF
Get Full Access — KSh 500

Reviews

No reviews yet.