Walnut DataTech
Create account

Applied SQL for analytics

Write clear, correct SQL to answer real business questions, from simple filters to window functions.

No reviews yetTaught by Priya Raman
Level
Beginner
Language
English
Duration
18 hours
Lessons
10

Last updated 8 Oct 2026

What you'll learn.

  • Explain the logical order in which a SQL query is evaluated
  • Filter, sort and aggregate data, handling NULL values correctly
  • Combine tables with inner, left and anti joins without duplicating rows
  • Structure long queries with common table expressions
  • Use window functions for rankings, running totals and period-over-period change
  • Build a monthly revenue report that a finance team can rely on

How this course is taught.

Every module comes to you in four parts, so you can watch, read, discuss and check what you have learned.

  1. Quadrant I

    e-Tutorial

    Watch a short video lecture for each module, with full text notes beside it so you can review or translate at your own pace.

  2. Quadrant II

    e-Content

    Download or print the reading material for each module, with key terms, case studies and links to further resources.

  3. Quadrant III

    Discussion forum

    Ask questions and clear your doubts with other learners. The course team guides the discussion and answers questions.

  4. Quadrant IV

    Assessment

    Check your understanding with quizzes, short and long-answer practice and FAQs.

Curriculum.

3 modules · 10 lessons
1Querying with confidence3 lessons · 53 minHow a query is evaluated, and the filtering and grouping patterns you will use every day.e-Tutorial (video)1e-Content (notes)2
  • Note: How a SQL query is evaluated15 min
  • Video: Filtering, sorting and handling NULL18 min
  • Note: Aggregation with GROUP BY and HAVING20 min
2Joining and shaping data4 lessons · 1 h 1 minCombine tables correctly, avoid duplicated rows and keep long queries readable.e-Tutorial (video)1e-Content (notes)2Assessment1
  • Note: Inner, left and anti joins20 min
  • Video: Avoiding join fan-out16 min
  • Note: Common table expressions for readable queries15 min
  • Quiz: Check your understanding: querying and joins10 min
3Analytical SQL3 lessons · 2 h 43 minWindow functions for rankings, running totals and growth figures, then the final project.e-Tutorial (video)1e-Content (notes)1Assessment1
  • Note: Window functions: ranking and running totals25 min
  • Video: Period-over-period comparisons with LAG18 min
  • Assignment: Project: monthly revenue report2 h

Before you start.

  • Comfort with spreadsheets, including filters and pivot tables
  • Access to any SQL database or an online SQL editor

About this course.

Most analytics work starts with a question someone asks in a meeting and ends with a number they can trust. SQL is the bridge between the two. This programme teaches you to write SQL that is correct first, readable second and fast enough third.

Who it is for

Analysts, product managers, finance and operations professionals who already work with spreadsheets and want to query data directly instead of waiting for an export.

How it works

  • Short lessons with worked examples you can run on any modern database (PostgreSQL, MySQL 8 or SQL Server).
  • A quiz at the end of the joins module to check your understanding.
  • A final project: a monthly revenue report with growth figures, reviewed by your instructor.

What makes it different

We focus on the mistakes that produce wrong numbers silently: NULL handling, join fan-out and grouping at the wrong grain. You will learn to check your own results before anyone else sees them.

Your instructor.

Priya RamanSenior data engineer

Priya builds data pipelines and analytics platforms, and teaches SQL, Python and reporting with one priority: numbers people can trust.

Learner reviews.

No reviews yet

No reviews yet. Learners can review a course after completing half of it.

Questions about enrolling.

How long can I access this course?

You can access the course for 365 days from the day you enrol.

Is my payment secure?

Yes. Your card, UPI or bank details go straight to Razorpay. Walnut Data Tech never sees or stores them.

When do I get access?

Immediately after the payment is confirmed. You'll also get a receipt by email.

What if the payment fails but money is deducted?

This is usually a delay at the bank. If the payment is confirmed, you're enrolled automatically. If not, the bank reverses the amount, normally within 5–7 working days. Contact support with your receipt number if you need help.

Can I get a refund?

Yes, if you ask within 7 days of purchase and have completed less than 20% of the course. Raise a ticket from the help desk with your receipt number.

Data and analytics