Skip to content
Free delivery over PKR 2,500 nationwide
Ilmora
New

SQL for Data Analysis: From SELECT to Window Functions

Query real business databases with confidence — joins, CTEs, window functions and analysis patterns.

4.7(980 ratings) 6,430 learners

Created by Zainab Qureshi

  • Updated September 2026
  • Urdu + English
  • Beginner
  • 16 hours · 112 lectures
  • Certificate included
PKR 1,999

30-day money-back guarantee · Secure card payment via Safepay

This course includes

  • 16 hours on-demand video
  • 7 articles & notes
  • 9 downloadable resources
  • 2 quizzes & assignments
  • Access on mobile, laptop and TV
  • Full lifetime access
  • Certificate of completion

What you’ll learn

  • Write SELECT queries with filters, sorting and aggregates
  • Combine tables with inner, left and self joins
  • Use CTEs and subqueries to break down complex questions
  • Apply window functions for rankings, running totals and cohorts
  • Answer real business questions on an e-commerce database

Course content

4 sections · 112 lectures · 16h total length

4 lessons · 47 min

  • 08:20
  • 14:30
  • GROUP BY and HAVING16:15
  • Quiz: Basics08:00

3 lessons · 38 min

  • Inner and left joins17:40
  • Self joins and many-to-many14:50
  • Common join mistakes05:00

3 lessons · 41 min

  • Subqueries13:25
  • CTEs for readable analysis15:10
  • CASE WHEN for business rules12:35

4 lessons · 1h 57m

  • ROW_NUMBER, RANK and top-N per group18:20
  • Running totals and moving averages16:45
  • Cohort and retention analysis21:30
  • Mock take-home analyst test60:00

Section outlines list the key lessons (4h 2m shown). The full syllabus of 112 lectures unlocks on enrolment.

Requirements

  • No prior SQL knowledge
  • A laptop that can run PostgreSQL or a free browser-based SQL editor

Description

SQL is the single most requested skill in data analyst job ads in Pakistan, and it's also one of the easiest to learn properly. In this course you'll query a realistic e-commerce database — customers, orders, riders, returns — and answer the questions managers ask every week.

Each lesson ends with practice questions graded automatically, and the final module is a mock take-home test modelled on real analyst interviews.

Who this course is for

  • Complete beginners who want a structured, step-by-step start in SQL
  • Commerce, business and engineering graduates moving into analyst roles
  • Learners who prefer clear explanations in Urdu, with technical terms kept in English
  • Anyone who wants a verifiable certificate to add to their CV or LinkedIn profile

Your instructor

Zainab Qureshi

Senior Data Analyst, Karachi retail group

Rating
4.8
Learners
89.3k
Courses
2

Zainab builds the dashboards that a large Karachi retail group uses to run hundreds of stores, from stock levels to Ramadan sales forecasts. She moved into data from a commerce background, so she knows how to teach people who don't think of themselves as technical. Her courses use real, messy Pakistani business datasets.

Power BIExcelSQLData VisualisationStatistics

More from Zainab Qureshi

Learner reviews

4.7

Course rating · 980 ratings

Breakdown of 3 written reviews.

Most recent reviews

Usama Tariq

BBA student, LUMS

Verified learner

Short, sharp and very practical. The window functions module is excellent.

Helpful?

Maryam Saleem

Operations analyst, Lahore

Verified learner

I use the cohort query from this course every month now.

Helpful?

Shoaib Anwar

Banker, Islamabad

Verified learner

Great for beginners. A few more practice questions in the joins module would help.

Helpful?

Learn with books too

Recommended books for this course

Go deeper on SQL with reference titles and guides chosen to sit next to the videos. Delivered nationwide with cash on delivery.

Shop all books

Keep learning

Learners also enrolled in

All Data Science courses
Bestseller
Data ScienceUrdu + English

Power BI & Excel for Data Analysis

Zainab Qureshi · Senior Data Analyst, Karachi retail group

4.8(11.3k)
58.7k30hBeginner
Save 33%
PKR 1,999PKR 2,999
Bestseller
ProgrammingUrdu

Python for Absolute Beginners (Urdu)

Hamza Malik · Mobile Engineering Lead & Programming Educator

4.8(18.4k)
96.3k22hBeginner
Save 33%
PKR 1,999PKR 2,999
Cyber SecurityUrdu + English

Ethical Hacking from Scratch

Bilal Ahmed · Penetration Tester & Security Consultant

4.7(8.9k)
47.3k38hBeginner
Save 29%
PKR 2,499PKR 3,499
BusinessUrdu + English

Amazon FBA & Daraz Selling Guide

Omer Farooq · Chartered Accountant & E-commerce Entrepreneur

4.5(5.3k)
29.9k27hBeginner
Save 14%
PKR 2,999PKR 3,499