Skip to main content
Iroko Skills Academy
Menu

Data & Analytics

SQL Basics

Learn to query databases with SQL — the highest-value data skill: what databases and SQL are, reading data with SELECT, filtering and sorting precisely, aggregating with GROUP BY, and combining tables with JOINs. Beginner-friendly, ending with a query-real-questions capstone.

BEGINNER · en · ~300 min

Instructor: Self-paced · Reviewed by: Iroko Skills Academy team · Published by: Iroko Skills Academy team

Learning objectives

  • Explain databases, tables, and SQL as a declarative query language
  • Read and filter data with SELECT, WHERE, ORDER BY, and LIMIT
  • Summarize data with aggregate functions and GROUP BY
  • Combine related tables with JOINs to answer real questions

Before you start

Prerequisites: None

Device/connectivity: Laptop or desktop computer with a modern web browser and keyboard, Internet access for lessons, tools, and assignment submission

Sign in to enroll

What you'll cover

  1. Databases and SELECT

    • What a database and SQL are
    • SELECT: asking for data

  2. Filtering and Aggregating

    • Filtering and sorting precisely
    • Aggregating: COUNT, SUM, GROUP BY

  3. Joins and Capstone

    • Combining tables with JOINs
    • Capstone: answer questions with SQL

Assessment and completion criteria

Complete every published lesson to earn a completion badge. A self-paced certificate also requires passing every server-graded quiz. Practical assignments provide project feedback and may support a separate verified-proficiency record, but they do not delay the standard course certificate.

  • Optional reviewed project: Answer questions with SQL · rubric v1 · pass ≥ 70%