Serving schools, colleges & students across India Sign inRegister freeFAQsHelpcontact@ghosla.io
GHOSLAGrowth Hub for Opportunities, Skills, Learning & AchievementGrow•Learn•Achieve Login Get Started

Solutions (For Institutions)

School ERPComplete school management College ERPComplete college management University ERPUniversity-wide management Coaching Classes ERPCoaching institute management

For Students

Ghosla AIAI-powered education & career assistant AI Career TestFind the careers that fit you Education LoansPlan, apply & track your loan Skills & CertificationsFree courses, Skill Score, certificates All 103 CoursesJob-ready courses, free right now Find Better SchoolsDiscover the right school for you Find Better CollegesDiscover the right college for you

Discover

Browse by City66 cities across India

SQL for Data Jobs: From Queries to Case Studies

Write the SQL that analysts and developers use daily, practised on realistic Indian business data

Ghosla Academy · Data Team

SQL is the most requested skill in data job listings on Indian portals. This course teaches it with practical datasets such as retail sales, UPI-style transactions and student records, so every query answers a real business question. You will progress from simple selects to window functions and finish with case studies modelled on interview rounds.

What you will be able to do

  • Write SELECT queries with filters, sorting and aggregation
  • Combine tables with INNER, LEFT and self joins
  • Use subqueries, CTEs and window functions
  • Design tables with keys, constraints and normalisation
  • Insert, update and delete data safely with transactions
  • Solve SQL rounds asked in analyst and developer interviews

What you build

  • Sales analysis for a kirana-chain dataset
  • UPI transactions dashboard queries
  • Interview-style SQL case study

What you need to start

  • Basic computer skills
  • A laptop to install MySQL or PostgreSQL (free)

Curriculum · 6 sections, 24 lectures

Databases and setup4 lectures
  1. What databases and SQL areFree preview8 min
  2. Installing MySQL and WorkbenchFree preview12 min
  3. Loading the course datasets10 min
  4. Quiz: database basics5 min
Querying a single table4 lectures
  1. SELECT, WHERE and ORDER BY14 min
  2. Text, date and number functions12 min
  3. GROUP BY and HAVING14 min
  4. Practice: 20 single-table questions15 min
Joins4 lectures
  1. INNER and LEFT joins15 min
  2. Self joins and multiple joins12 min
  3. Common join mistakes12 min
  4. Quiz: joins6 min
Advanced querying4 lectures
  1. Subqueries14 min
  2. CTEs for readable queries14 min
  3. Window functions: ROW_NUMBER, RANK, LAG18 min
  4. CASE expressions12 min
Designing and changing data4 lectures
  1. Tables, keys and constraints14 min
  2. Normalisation basics12 min
  3. INSERT, UPDATE, DELETE and transactions12 min
  4. Indexes and performance basics10 min
Case studies4 lectures
  1. Case study: kirana-chain sales20 min
  2. Case study: UPI transactions analysis20 min
  3. Interview-style SQL case study25 min
  4. SQL interview question bank8 min

Who this is for

  • Students targeting data analyst or business analyst roles
  • Developers who want stronger database skills
  • Commerce and management graduates moving into analytics