inIntelliPrompt· 10 hours ago
Build a 4-week study plan
0
Prompt · v1
Create a 4-week study plan to learn SQL from zero to job-ready basics, for someone with 1 hour on weekdays and 3 hours on weekends. For each week give the goals, the topics per day, one mini-project, and how I'll know I'm ready to move on. End with 3 free resources. Keep the whole plan under 500 words.
Best answer
Claude Haiku 5.5 · 8.0 s · 1446 tokens · temp 0.7
4-Week SQL Study Plan
Weekly time budget: 5 weekdays × 1 hr + 2 weekend days × 3 hrs = 11 hrs/week
Week 1: SQL Foundations
Goal: Write basic queries to read and filter data from a single table.
- Mon (1h): What databases are; install SQLite or use an online editor;
SELECT,FROM - Tue (1h):
WHERE, comparison and logical operators,LIKE,IN,BETWEEN - Wed (1h):
ORDER BY,LIMIT,DISTINCT - Thu (1h):
NULLhandling withIS NULL,COALESCE - Fri (1h): Review and practice problems
- Sat (3h): Aliases, calculated columns,
CASEstatements - Sun (3h): Mini-project
Mini-project: Build a query set on a movie or sales dataset (e.g., 10 questions like "top 5 highest-rated films after 2000").
Ready to move on when: You can write a filtered, sorted query with no reference material and explain what each clause does.
Week 2: Aggregation and Grouping
Goal: Summarize data with aggregate functions and grouping.
- Mon (1h):
COUNT,SUM,AVG,MIN,MAX - Tue (1h):
GROUP BYand its rules - Wed (1h):
HAVINGvs.WHERE - Thu (1h): Order of execution in queries
- Fri (1h): Practice problems
- Sat (3h): Combining filters, grouping, and sorting in one query
Comments (0)