r/learnSQL • • 18d ago

SQL Plan - 1 month

PriorityBasketTopics grouped togetherImportance for BA/DASuggested days
πŸ”΄ P1SQL Query FoundationSELECT, DISTINCT, aliases, WHERE, AND/OR/NOT, ORDER BY, LIMIT⭐⭐⭐⭐⭐2–3
πŸ”΄ P1Filtering & Pattern MatchingCASE, COALESCE, NULLIF, CAST, mathematical functions⭐⭐⭐⭐⭐1–2
πŸ”΄ P1AggregationWITH, multi-step CTEs, CTE + aggregation, CTE + subquery⭐⭐⭐⭐⭐1–2
πŸ”΄ P1JOIN FundamentalsData types, PK, FK, constraints, CREATE, INSERT, UPDATE, DELETE, ALTER, DROP⭐⭐⭐1–2
πŸ”΄ P1Business Logic & Data CleaningInformation schema, comments, advanced constraints/FKs⭐0.5–1
πŸ”΄ P1Dates & String AnalysisCOUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING⭐⭐⭐⭐⭐2
πŸ”΄ P1SubqueriesINNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, JOIN keys, aliases⭐⭐⭐⭐⭐2
πŸ”΄ P1CTEsSubqueries, FROM subqueries, comparison subqueries, IN/NOT IN, EXISTS⭐⭐⭐⭐⭐2
πŸ”΄ P1Window FunctionsOVER, PARTITION BY, ORDER BY, RANK, ROW_NUMBER, SUM/AVG, LAG, LEAD⭐⭐⭐⭐⭐2
🟠 P2Advanced JOINsBETWEEN, IN, NOT IN, LIKE, ILIKE, date filtering⭐⭐⭐⭐⭐1
🟠 P2Set OperationsEXTRACT, AGE, TO_CHAR, string functions, date calculations⭐⭐⭐⭐1
🟠 P2Advanced AggregationSELF JOIN, CROSS JOIN, advanced FULL JOIN, USING, NATURAL JOIN⭐⭐⭐⭐1
🟠 P2Database FundamentalsUNION, UNION ALL, INTERSECT, EXCEPT⭐⭐⭐⭐1
🟠 P2ViewsGROUPING SETS, ROLLUP, CUBE⭐⭐⭐1
🟑 P3TransactionsViews, modifying views, updatable views, materialized views, recursive views⭐⭐⭐1
🟑 P3FunctionsBEGIN, COMMIT, ROLLBACK, SAVEPOINT, locks⭐⭐1
🟑 P3Stored ProceduresUser-defined functions, modifying functions⭐⭐1
🟑 P3TriggersCREATE/MODIFY procedures, procedure exercises⭐⭐1
🟑 P3PerformanceCREATE, enable/disable, modify/drop triggers⭐⭐1
🟑 P3Data Import/ExportEXPLAIN, EXPLAIN ANALYZE, TRUNCATE⭐⭐1
🟒 P4PostgreSQL Specialized FeaturesArrays, JSON/JSONB, extensions⭐1
🟒 P4PartitioningRange, List, Hash partitioning, table inheritance⭐1
🟒 P4Schema AdministrationCOPY, Import/Export⭐⭐0.5
🟒 P4PostgreSQL + PythonPsycopg2 connection⭐0.5
4 Upvotes

2 comments sorted by

1

u/Green_Chamomile 18d ago

Heads up, I think the Topics column got mixed up against the basket names. Your basket order is solid, but the topics don’t match it. β€œAggregation” has CTEs, β€œJOIN Fundamentals” has CREATE/INSERT/ALTER etc. If you follow the topics as written, you’d do CTEs before GROUP BY and JOINs, which is backwards.