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
Write SELECT queries that filter, sort and summarise data
Group results with GROUP BY and HAVING, and join tables on a shared key
Clean messy data before you count or group it
Use CTEs and window functions to build a campaign scorecard a client can act on
What's inside the course
Level 1: Ask the database
Select, filter, sort and summarise.
Your first query A database is a set of tables, like tabs in a spreadsheet. SQL is how you ask a table a question.
Filtering with WHERE Most questions are about some of the rows, not all of them. WHERE keeps only the rows that match.
Sorting, limiting and unique values Put the rows in order, keep just the top few, and list what is different.
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.
GROUP BY and HAVING One summary per group: revenue per status, cost per campaign, clicks per day.
Joining tables Facts live in different tables. A join lines the rows up using a shared key.
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.
CTEs and window functions Build a query in named steps, then calculate across rows without collapsing them.
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
Online, interactive lessons that open in your browser once your payment is confirmed
9 hands-on practicals and 9 quizzes, one of each per lesson
Runnable SQL code inside the lessons, with nothing to install
Your courses and certificates are kept under My Courses in your account
Mark the course complete to receive your PDF certificate by email
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.
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.
Marketers who work with exported data every day and want to stop fighting messy spreadsheets, whether or not you plan to go on to SQL, Python or BI tools.