Skip to content
Part of Miss Lily Gee Unlimited — Nurturing Your Brilliance
MLG Academy

SQL and Data Wrangling Basics

Already purchased this course? Log in to access your lesson.

Log In Enroll & Pay Now Add to Cart Back to All Courses
Data Analytics Track

Who SQL and Data Wrangling Basics is for

Marketers and aspiring analysts who want to pull, clean and summarise data from a database themselves.

Price: R3,499 / $245
Duration: 3 weeks, part-time
Lessons: 9 online lessons
Certificate: PDF certificate of completion
Prerequisite: None. The course starts from your very first query.

What you'll be able to do

What's inside the course

Level 1: Ask the database

Select, filter, sort and summarise.

  1. Your first query
    A database is a set of tables, like tabs in a spreadsheet. SQL is how you ask a table a question.
  2. Filtering with WHERE
    Most questions are about some of the rows, not all of them. WHERE keeps only the rows that match.
  3. Sorting, limiting and unique values
    Put the rows in order, keep just the top few, and list what is different.
  4. Summarising with aggregates
    Instead of listing rows, collapse them into one number: how many, how much, on average.

Level 2: Combine and clean

Group, join tables and tidy messy data.

  1. GROUP BY and HAVING
    One summary per group: revenue per status, cost per campaign, clicks per day.
  2. Joining tables
    Facts live in different tables. A join lines the rows up using a shared key.
  3. Cleaning messy data
    Real data is never tidy. SQL can standardise it before you count or group anything.

Level 3: Analyse

Use CTEs, window functions and a full scorecard.

  1. CTEs and window functions
    Build a query in named steps, then calculate across rows without collapsing them.
  2. Capstone: the campaign scorecard
    Which campaigns earned back their spend? Combine everything you have learned into one answer a client can act on.

How the course works

Your instructor

MLG Academy courses are written by Lilitha Waqu (Lily Gee), founder of Miss Lily Gee Unlimited and the analytics company Lina Lula. She is a digital marketing analytics specialist who works with SMEs and clients worldwide on tracking, reporting and turning data into decisions, and built each course around the work analysts do every day.

Price and what's included

R3,499 ($245)

SQL and Data Wrangling Basics: 9 lessons, 3 weeks part-time, practicals, quizzes and a certificate of completion.

Frequently asked questions

Who is the SQL and Data Wrangling Basics course for?

Marketers and aspiring analysts who want to pull, clean and summarise data from a database themselves.

Do I need any experience before I start?

None. The course starts from your very first query.

How long does SQL and Data Wrangling Basics take?

3 weeks, part-time. The course has 9 lessons across 3 levels, and you work through them online in your browser.

How is the course taught?

Every lesson combines clear explanations and worked examples with a hands-on practical and a short quiz, so you apply each idea before moving on. You also run real SQL code right in the lesson, with nothing to install.

How much does SQL and Data Wrangling Basics cost?

R3,499 (about $245 USD). Once your payment is confirmed, log in and this page opens your lessons. The course is also listed under My Courses in your account.

Do I get a certificate?

Yes. When you finish, mark the course complete and a PDF certificate of completion is emailed to you. You can also download it from My Courses.