NASSCOM AlignedAPSSDC RecognisedCertificate Included
What you'll learn
✓
Say what one row of your result represents, and check it before trusting a number✓
Aggregate at the right grain, and filter correctly before or after grouping✓
Count without double counting, and handle NULL the way SQL actually does✓
Predict which rows a join keeps and which it silently drops✓
Recognise fan-out, and explain why a total doubled after adding a join✓
Use LEFT JOIN deliberately to find what is missing rather than what is there✓
Write a query with CTEs that a colleague can read and check✓
Rank, number and compare rows with window functions without collapsing them✓
Build running totals, moving averages and period-on-period comparisons✓
Run a cohort analysis, and handle dates with no rows in themCourse Curriculum
5 sections · 16 lessons · 15h 20m total
📝
Quizzes & Exams
5 checkpoint quizzes as you go, plus a final exam of 25 questions. 50 questions in total, included with the course.
✓ Included — available now
Requirements
Data Foundations, or comfort reading a table and reasoning about what a row means
No SQL experience required — module 1 gets you querying from nothing
SQLite, a single small download with no server to run
This is a WRITTEN course: lessons are text and queries you run, not video
Your Instructor
V
Venkat Kurela
Course Instructor · KCA Expert Trainer
📚 NASSCOM Certified
Course Details
🏷 CategoryDATA_SCIENCE_ANALYTICS
📊 LevelBeginner
🌐 LanguageEnglish
⚡ AccessOne-time purchase
📅 UpdatedAugust 2026
⏱ Duration15h 20m total
📜 Certificate✓ Included
Tags
SQLAnalyticsWindow FunctionsCohortsBeginnerWritten Course
Share
Related Courses
You might also like
Curated based on category & skill level
