indiadigital
Home / Code / SQL with Data
🗃️ BEGINNER · CLASS 9+ · FREE COURSE

SQL with Data

डेटा के साथ SQL — टेबल से सवाल पूछिए — क्रिकेट, ट्रेन और किराना दुकान।

SQL is the language every company uses to ask questions of its data. You will query a cricket stats table, a train timetable and a kirana shop’s sales, all running as a real SQLite database inside your browser. You finish by writing the shop’s monthly report with JOIN, GROUP BY and HAVING.

Start lesson 1 →Final project
  • 13lessons
  • 26challenges
  • 8hto finish

Syllabus

Unit 1: Tables and SELECT टेबल और SELECT2 lessons

  1. Your first queryWhat a table is, SELECT * and picking columns.2 challenges · 12 min
  2. Nicer results: AS and DISTINCTRename columns and remove repeated values.2 challenges · 10 min

Unit 2: Filtering with WHERE WHERE से छाँटना3 lessons

  1. WHERE: only the rows you wantEquals, not-equals and comparing numbers.2 challenges · 12 min
  2. AND, OR, IN and BETWEENCombine conditions and test lists and ranges.2 challenges · 14 min
  3. Patterns and missing valuesLIKE with % and _, and IS NULL — on a train timetable.2 challenges · 12 min

Unit 3: Sorting and calculating क्रम लगाना और हिसाब2 lessons

  1. ORDER BY and LIMITSort results, by one or many columns, and keep the top few.2 challenges · 12 min
  2. Calculated columnsDo maths in SELECT: + - * /, ROUND, and the integer trap.2 challenges · 14 min

Unit 4: Summaries: aggregates and GROUP BY सारांश: aggregates और GROUP BY3 lessons

  1. COUNT, SUM, AVG, MIN, MAXTurn many rows into one useful number.2 challenges · 12 min
  2. GROUP BY: a summary per groupCount and add up per category, per product.2 challenges · 14 min
  3. HAVING: filter the groupsWHERE filters rows, HAVING filters groups.2 challenges · 14 min

Unit 5: Joins, changes and the final project Joins, बदलाव और फ़ाइनल प्रोजेक्ट3 lessons

  1. JOIN: connecting two tablesINNER JOIN and LEFT JOIN with ON.2 challenges · 16 min
  2. Changing data: INSERT, UPDATE, DELETEAdd a product, change a price, remove a sale.2 challenges · 14 min
  3. ★ Final project: Kirana shop monthly reportBills with amounts, then the October report by category.2 challenges · 20 min

Search by task, format or tool name.