Week 1: SQL Beginner Learning Plan
Day 1: SQL Basics (SELECT, WHERE, ORDER BY)
Step 1: Learn theory + watch videos
- Go to Khan Academy SQL Intro: https://www.khanacademy.org/computing/computer-
programming/sql
- Watch Intro to SQL videos (first few videos about 5-10 minutes each)
- Focus on SELECT, WHERE, ORDER BY
Step 2: Practice interactive exercises on Khan Academy
- Do all exercises related to these topics
Step 3: Write down 5 practice queries yourself (on paper or editor)
- Example: Select all from students, filter by age > 20, order by score descending
Step 4: Practice on SQL Fiddle (http://sqlfiddle.com/)
- Create a simple table "students"
- Insert sample data
- Run your queries and check results
Day 2: SQL Aggregate Functions and GROUP BY
Step 1: Learn theory + watch videos on Khan Academy
- Aggregation functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY clause
Step 2: Complete exercises on Khan Academy for these topics
Step 3: Write 5 aggregate queries on paper/editor
- Count students, average score, max/min score, group by age, etc.
Step 4: Practice on SQL Fiddle
- Create/modify students table
- Run aggregate queries and check results
Day 3: SQL JOINS (INNER JOIN)
Step 1: Learn about INNER JOIN on Khan Academy
- Watch videos and do exercises
Step 2: Write 5 JOIN queries on paper/editor
- Join students with another table (e.g. classes)
Step 3: Practice on SQL Fiddle
- Create two sample tables
- Run your JOIN queries and verify output
Day 4: More JOINS (LEFT JOIN, RIGHT JOIN) & HackerRank SQL Easy challenges
Step 1: Continue Khan Academy JOINS lessons (LEFT JOIN, RIGHT JOIN)
Step 2: Do JOIN exercises on Khan Academy
Step 3: Start HackerRank SQL Easy challenges (3 problems)
- Focus on SELECT and WHERE basics
Day 5: ORDER BY, LIMIT & Subqueries
Step 1: Learn ORDER BY and LIMIT (Khan Academy or YouTube tutorials)
Step 2: Practice nested queries/subqueries on Khan Academy
Step 3: Continue HackerRank SQL Easy challenges (3 problems)
Day 6: Subqueries deep dive & HackerRank practice
Step 1: Watch YouTube video: SQL Subqueries for Beginners
- https://www.youtube.com/watch?v=9Pzj7Aj25lw
Step 2: Practice nested queries on HackerRank (easy/medium) - 4 problems
Step 3: Review SQL Fiddle queries and improve them
Day 7: Review & Rest
- Review all topics learned so far
- Write a summary of your learning to strengthen retention
