R
Rishtaara
SQL: Zero to Data Analyst
Lesson 27 of 30Article14 min

Quiz, Exercises & Study Plan

Rishtaara covers this path with lesson drills plus MCQ practice at /mcq/sql-mcq.

Certificate, Quiz & Exercises

Rishtaara covers this path with lesson drills plus MCQ practice at /mcq/sql-mcq.

After each part (queries vs database admin), pause and test yourself without looking at notes.

Real-life example: Quizzes are mock exams before boards — they show gaps before the real interview or project.

  • MCQ practice: /mcq/sql-mcq
  • Interview prep: /interview/sql-interview
  • Full guide article: /knowledge/sql-zero-to-analyst

Syllabus & Study Plan

Week 1: lessons 1–8 (SELECT through aliases). Week 2: 9–16 (JOINs through procedures). Week 3: 17–24 (DDL and security). Week 4: 25–30 (patterns and project).

Real-life example: A study plan is a term syllabus — fixed weekly topics so you finish before placement season.

  • Day 1–2: SELECT, WHERE, ORDER BY
  • Day 3–4: INSERT/UPDATE/DELETE, aggregates
  • Day 5–7: JOINs and GROUP BY
  • Weekend: /mcq/sql-mcq set 1

Bootcamp & Training notes

Bootcamps compress this syllabus into 1–2 weeks with daily projects. Self-paced learners should code every example, not just read.

Real-life example: Bootcamp training is cricket nets every morning — repetition beats watching highlights once.

Daily drill — rewrite from memory
-- Without looking at notes, write:
-- 1) All grade 10 students in Delhi, sorted by name
-- 2) Average score per course with HAVING avg > 70
-- 3) Students with no enrollments (LEFT JOIN pattern)

-- Then check answers in lesson 26 and run them on sample data.