Skip to main content
Database
Beginner to Intermediate
45 days

SQL

Query, aggregate, join, and analyze relational data with confidence.

Master structured querying: SELECT, WHERE, JOINs, GROUP BY, subqueries, window functions, and data manipulation.

SQL illustrated course poster
Pacing & Duration

45 days

Experience Level

Beginner to Intermediate

Delivery Mode

Live online · One-to-one available · Group batches when scheduled

Learning Format

1-on-1 & small cohorts

Course overview

SQL is the universal language of data. This hands-on course teaches querying from simple filters to complex multi-table JOINs, aggregations, nested subqueries, CASE statements, and data modification (INSERT, UPDATE, DELETE). Essential for developers and data analysts alike.

Free, self-guided practice

Try a SQL starter exercise

A practical first task you can try independently, without registration or payment. These instructions are for self-study; they are not a free live class or a downloadable project.

Your task

Write a query that filters completed orders.

  1. Imagine an orders table with id, status and total columns.
  2. Write SELECT with a WHERE clause for completed status.
  3. Add ORDER BY total DESC to show largest orders first.

Check your result: The query filters before ordering and returns the expected columns.

Ungated self-study

Free projects to practice this course

Open a hands-on starter kit with runnable example code, project milestones and a downloadable checklist. No signup or tuition is required for the guide.

Browse all free projects

What you'll achieve

Core competencies developed through practical implementation and project work.

  • Write efficient SQL queries to extract and filter large datasets
  • Combine data across multiple tables using INNER, LEFT, RIGHT, and FULL JOINs
  • Perform aggregations and group-level calculations with GROUP BY and HAVING
  • Use subqueries, CTEs (Common Table Expressions), and window functions
30–60 Day Structured Course

Chapters, Core Topics & Guided Tasks

Every chapter closes with a guided implementation task. The complete course ends with one portfolio-ready capstone project.

45 days 3–4 classes/week

Curriculum Validation Basis

Core chapters are cross-checked against current official technology documentation and authoritative standards or academic references.

  1. Chapter 01

    Relational Query Foundations

    Core topics

    • SELECT and aliases
    • WHERE and operators
    • ORDER BY and LIMIT

    Guided chapter task

    Answer a set of filtered business questions from one table.

  2. Chapter 02

    Aggregation & Grouping

    Core topics

    • Aggregate functions
    • GROUP BY
    • HAVING and conditional aggregation

    Guided chapter task

    Produce a KPI summary by category, month, or customer segment.

  3. Chapter 03

    Multi-Table Queries

    Core topics

    • INNER and OUTER JOINs
    • Self and many-to-many joins
    • NULL-safe reasoning

    Guided chapter task

    Combine a normalized sales or admissions dataset into one report.

  4. Chapter 04

    Subqueries, CTEs & Set Operations

    Core topics

    • Scalar and correlated subqueries
    • Common table expressions
    • UNION, INTERSECT, and EXCEPT

    Guided chapter task

    Refactor a complex report into readable CTE steps.

  5. Chapter 05

    Window Functions

    Core topics

    • ROW_NUMBER and RANK
    • Running totals
    • Partitioned comparisons

    Guided chapter task

    Build customer ranking and period-over-period analysis queries.

  6. Chapter 06

    Data Definition & Transactions

    Core topics

    • CREATE and ALTER
    • INSERT, UPDATE, and DELETE
    • Constraints and transaction control

    Guided chapter task

    Create a small schema and execute a safe multi-step update transaction.

Complete Course Capstone

Portfolio Project

Complete an e-commerce or academy SQL case study with schema, analytical queries, and a business findings report.

Prerequisites & Prior Knowledge

Recommended background before starting this course. Mentors adapt pacing to your current level.

No previous database experience required.
Target Audience

Who is this course for?

Aspiring developers, data analysts, students, and professionals working with data.

Delivery & Mentoring

Hands-on Learning Format

  • Live interactive screen-sharing
  • 1-on-1 personalized instruction
  • Practical, portfolio-ready code

Contact admissions for current fee and available learning formats

Enrol in SQL

Start with a 1-on-1 trial session to discuss your technical goals with an instructor.

  • Duration: 45 days
  • Level: Beginner to Intermediate
  • Delivery: Live online · One-to-one available · Group batches when scheduled
  • Format: 1-on-1 & small cohorts
Apply for this course Request Free Demo Trial

* Free Demo is a 1-on-1 trial session, not the complete course.

Ready to start your learning journey?

Apply today and our admissions team will review your application and guide you through the next steps.