'%20stroke-width='3'%20stroke-linecap='round'%20stroke-linejoin='round'%3e%3cpath%20d='M15%2027%2022%2012C25%205%2033%205%2036%2012l8%2017M36%2047l3%208c3%209%2015%205%2012-3l-6-14'/%3e%3cpath%20d='m23%2036%206-17q1-3%203%200l5%2013'/%3e%3cpath%20d='M42%2012c6-1%2010%202%2010%206-1%2018-18%2030-35%2029l-2%206c-3%209-15%206-12-3%205-13%2013-13%2021-14%205%200%209-1%2013-4'/%3e%3c/g%3e%3cg%20fill='url(%23orbit)'%3e%3ccircle%20cx='15'%20cy='27'%20r='3.6'/%3e%3ccircle%20cx='37'%20cy='32'%20r='3.6'/%3e%3ccircle%20cx='17'%20cy='47'%20r='3.6'/%3e%3ccircle%20cx='52'%20cy='15'%20r='4.4'/%3e%3c/g%3e%3c/svg%3e)
Week 1 · Modeling and basic queries
Study modeling, normalization, SELECT, and NULL. As a flexible 45–60-minute daily routine, try 20 minutes of examples, 20 of questions, and 10 of review.
SQLD
SQL DeveloperUnderstand data models and learn to read SQL results.
SQLD · STUDY PATH
Understand the concept. Check the result.
Learn 10 topics through worked tables and detailed reasoning. Each topic has 8 questions, 80 in total, covering concepts, computed results and boundary cases, with explanations for review.
ReadPredictPracticeReview
0 / 10topics complete
Continue learningEntities, relationships, and identifiers →
A flexible four-week guide
These suggested weeks assume 45–60 minutes a day. Adjust them to your experience and available time.
Week 2 · Joins and aggregates
Count join rows by hand and explain how WHERE and HAVING differ. Revisit earlier mistakes the following day.
Week 3 · Query techniques
Practice subqueries, windows, hierarchies, PIVOT, and regex. Check ties, NULLs, and empty results explicitly.
Week 4 · Transactions and consolidation
Review transaction boundaries and unfinished topics. Use a separate current-scope question book for a 50-question, 90-minute timed session; check each subject score and explain mistakes.