Skip to content

Master_SQL_In_One_Week.md

Latest commit

 

History

History
323 lines (196 loc) · 4.43 KB

Master_SQL_In_One_Week.md

File metadata and controls

323 lines (196 loc) · 4.43 KB
Raw

7-day SQL bootcamp

With:

  • ⏱ Exact hours per day
  • 📚 Academic foundation (how databases actually work)
  • 💻 Practical job-ready skills
  • 🧠 Real-world thinking practice

Assuming you can study 3–4 hours per day for one week.

🎯 End Goal (After 7 Days)

You should be able to:

  • Write complex queries confidently
  • Understand how relational databases work internally
  • Design simple database schemas
  • Pass junior-level SQL interview questions
  • Connect SQL knowledge to backend/web development

📅 7-Day Super-Focused SQL Plan (Job + Web Dev Track)

🟢 Day 1 – Database Foundations + SELECT (4 hours)

⏱ Hour 1 – Academic Foundation

Learn:

  • What is a relational database?
  • What is a DBMS?
  • Tables, rows, columns
  • Primary key
  • Foreign key
  • What is normalization?
  • What is ACID?

Understand theory, not just syntax.

⏱ Hour 2 – Basic Queries

Learn:

  • SELECT
  • WHERE
  • ORDER BY
  • LIMIT
  • DISTINCT

Practice 20+ simple queries.

⏱ Hour 3 – Data Types + Schema

Learn:

  • INT, VARCHAR, DATE, BOOLEAN
  • CREATE TABLE
  • INSERT INTO

Understand how backend apps store data.

⏱ Hour 4 – Practice

Use:

  • W3Schools
  • HackerRank

Do beginner filtering problems.

🟢 Day 2 – Filtering + Logical Thinking (3–4 hours)

⏱ Hour 1.5 – Advanced Filtering

Learn:

  • AND, OR
  • IN
  • BETWEEN
  • LIKE
  • IS NULL

⏱ Hour 1 – Query Logic Thinking

Translate English → SQL

Example:

“Find users who signed up in 2024 and made more than 3 purchases”

⏱ Hour 1 – Practice

Solve 15–20 filtering problems.

Use:

  • LeetCode (SQL easy problems)

🟢 Day 3 – Aggregations (Very Important for Jobs) (4 hours)

⏱ Hour 1 – Functions

  • COUNT()
  • SUM()
  • AVG()
  • MIN()
  • MAX()

⏱ Hour 1 – GROUP BY + HAVING

Understand grouping deeply.

Academic concept:

  • What is aggregation?
  • Why does GROUP BY change result structure?

⏱ Hour 1.5 – Business Problems

Solve:

  • Top customers
  • Monthly revenue
  • Average salary per department
  • Most sold product

⏱ Hour 0.5 – Review

🟢 Day 4 – JOINS (Critical for Web Development) (4 hours)

This is the most important day.

⏱ Hour 1 – Academic Foundation

Understand:

  • One-to-many relationships
  • Many-to-many relationships
  • Foreign keys
  • Why joins exist

⏱ Hour 1.5 – Types of Joins

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • Self join

⏱ Hour 1.5 – Real App Simulation

Imagine a web app:

  • Users
  • Orders
  • Products

Write 20 join queries.

This is what backend developers do daily.

🟢 Day 5 – Subqueries + Nested Thinking (3–4 hours)

⏱ Hour 1 – Subqueries in WHERE

Example: Find users who bought more than average purchases.

⏱ Hour 1 – Subqueries in FROM

Understand temporary tables.

⏱ Hour 1 – Interview Questions

  • Second highest salary
  • Duplicate emails
  • Rank users

Practice on:

  • LeetCode

🟢 Day 6 – Database Design + Indexing (Academic Depth) (4 hours)

This separates hobby learners from job-ready learners.

⏱ Hour 1 – Normalization

  • 1NF
  • 2NF
  • 3NF

Understand data redundancy.

⏱ Hour 1 – Indexes

  • What is an index?
  • Why does it improve speed?
  • Trade-offs

⏱ Hour 1 – Constraints

  • UNIQUE
  • NOT NULL
  • FOREIGN KEY
  • CHECK

⏱ Hour 1 – Design a Small System

Design database for:

  • E-commerce store OR
  • Blog system OR
  • School management

Create tables and relationships.

🟢 Day 7 – Real Project Simulation (4 hours)

Build a mini project schema:

Example: Online Store

Tables:

  • users
  • products
  • orders
  • order_items

Then write:

  • Top 5 customers
  • Monthly revenue
  • Products never sold
  • Most popular category
  • Users with no orders

Write at least 25 queries.

📚 Recommended Structured Course (Optional but Strong)

If you want structured academic backing:

  • Coursera
  • edX

Search: “Database Systems” or “Introduction to SQL”

🧠 After 1 Week — What You’ll Actually Be

You will:

  • Understand relational databases properly
  • Write 80% of common job SQL queries
  • Be ready to connect SQL with:
    • Python (backend)
    • JavaScript (Node.js)
    • Web frameworks

🚀 Next Step After This Week

Week 2:

  • Learn how to connect SQL to backend (Node.js or Python Flask)
  • Learn basic CRUD APIs