Scribd
Upload
14 views2 pages

7 Day SQL Study Routine

The document outlines a 7-day SQL study routine designed to teach the fundamentals of SQL. Each day focuses on specific topics such as basic syntax, filtering data, sorting, grouping, joins, and subqueries, with practical tasks to reinforce learning. The final day is dedicated to a real-life project that incorporates all learned concepts.

Uploaded by

bedardisuman1262
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

7 Day SQL Study Routine

The document outlines a 7-day SQL study routine designed to teach the fundamentals of SQL. Each day focuses on specific topics such as basic syntax, filtering data, sorting, grouping, joins, and subqueries, with practical tasks to reinforce learning. The final day is dedicated to a real-life project that incorporates all learned concepts.

Uploaded by

bedardisuman1262
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

7-Day SQL Study Routine

Day 1 - Basics + Setup


Time: 45 min
Topics:
- What is SQL? (Theory + Real-life examples)
- Install MySQL or use online compiler (e.g., W3Schools SQL editor)
- Basic syntax: SELECT, FROM
Task:
- Create a 'Students' table with columns: name, age, marks

Day 2 - Filtering Data


Time: 1 hour
Topics:
- WHERE, AND, OR, BETWEEN, IN, LIKE
Task:
- Filter Students table for students aged 18+

Day 3 - Sorting and Functions


Time: 1 hour
Topics:
- ORDER BY, LIMIT, DISTINCT
- Functions: COUNT(), AVG(), SUM(), MAX(), MIN()
Task:
- Show top 3 students by marks

Day 4 - Grouping Data


Time: 1 hour
Topics:
- GROUP BY, HAVING
Task:
- Group students by age and show average marks
Day 5 - Joins Mastery
Time: 1.5 hours
Topics:
- INNER JOIN, LEFT JOIN, RIGHT JOIN
Task:
- Create a 'Courses' table (student_id, course_name)
- Join Students + Courses tables

Day 6 - Subqueries + Nested Queries


Time: 1 hour
Topics:
- Subqueries in WHERE, FROM, SELECT
Task:
- Show the name of the topper student using subquery

Day 7 - Practice Day (Real-life Project Style)


Time: 1.5 hours
Task:
- Create a mini project: Online Store DB (Products, Orders, Customers)
- Use all topics above in your queries
- Save your queries in Notepad or GitHub

You might also like