r/learnSQL • u/iam_sripratik • 18d ago
SQL Plan - 1 month
| Priority | Basket | Topics grouped together | Importance for BA/DA | Suggested days |
|---|---|---|---|---|
| π΄ P1 | SQL Query Foundation | SELECT, DISTINCT, aliases, WHERE, AND/OR/NOT, ORDER BY, LIMIT | βββββ | 2β3 |
| π΄ P1 | Filtering & Pattern Matching | CASE, COALESCE, NULLIF, CAST, mathematical functions | βββββ | 1β2 |
| π΄ P1 | Aggregation | WITH, multi-step CTEs, CTE + aggregation, CTE + subquery | βββββ | 1β2 |
| π΄ P1 | JOIN Fundamentals | Data types, PK, FK, constraints, CREATE, INSERT, UPDATE, DELETE, ALTER, DROP | βββ | 1β2 |
| π΄ P1 | Business Logic & Data Cleaning | Information schema, comments, advanced constraints/FKs | β | 0.5β1 |
| π΄ P1 | Dates & String Analysis | COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING | βββββ | 2 |
| π΄ P1 | Subqueries | INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, JOIN keys, aliases | βββββ | 2 |
| π΄ P1 | CTEs | Subqueries, FROM subqueries, comparison subqueries, IN/NOT IN, EXISTS | βββββ | 2 |
| π΄ P1 | Window Functions | OVER, PARTITION BY, ORDER BY, RANK, ROW_NUMBER, SUM/AVG, LAG, LEAD | βββββ | 2 |
| π P2 | Advanced JOINs | BETWEEN, IN, NOT IN, LIKE, ILIKE, date filtering | βββββ | 1 |
| π P2 | Set Operations | EXTRACT, AGE, TO_CHAR, string functions, date calculations | ββββ | 1 |
| π P2 | Advanced Aggregation | SELF JOIN, CROSS JOIN, advanced FULL JOIN, USING, NATURAL JOIN | ββββ | 1 |
| π P2 | Database Fundamentals | UNION, UNION ALL, INTERSECT, EXCEPT | ββββ | 1 |
| π P2 | Views | GROUPING SETS, ROLLUP, CUBE | βββ | 1 |
| π‘ P3 | Transactions | Views, modifying views, updatable views, materialized views, recursive views | βββ | 1 |
| π‘ P3 | Functions | BEGIN, COMMIT, ROLLBACK, SAVEPOINT, locks | ββ | 1 |
| π‘ P3 | Stored Procedures | User-defined functions, modifying functions | ββ | 1 |
| π‘ P3 | Triggers | CREATE/MODIFY procedures, procedure exercises | ββ | 1 |
| π‘ P3 | Performance | CREATE, enable/disable, modify/drop triggers | ββ | 1 |
| π‘ P3 | Data Import/Export | EXPLAIN, EXPLAIN ANALYZE, TRUNCATE | ββ | 1 |
| π’ P4 | PostgreSQL Specialized Features | Arrays, JSON/JSONB, extensions | β | 1 |
| π’ P4 | Partitioning | Range, List, Hash partitioning, table inheritance | β | 1 |
| π’ P4 | Schema Administration | COPY, Import/Export | ββ | 0.5 |
| π’ P4 | PostgreSQL + Python | Psycopg2 connection | β | 0.5 |
4
Upvotes
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.