As a 2020 course, it does not cover modern cloud-based SQL engines (BigQuery, Redshift, Snowflake) or advanced performance tuning (indexing strategies, query execution plans). Also, it focuses exclusively on querying—there is no instruction on database administration, user permissions, or transaction control (commits, rollbacks). For a pure "analyst" track, that is fine; for an aspiring DBA, it is incomplete.
Another strength is the . Jose Portilla explains joins visually using Venn diagrams and provides side-by-side comparisons of result sets before and after applying a function. The course also emphasizes debugging—showing common mistakes (like forgetting to GROUP BY all non-aggregated columns) and how to fix them. watch the complete sql bootcamp 2020: go from zero to hero
The primary advantage is its . Rather than drowning the student in database theory or normalization forms, the instructor focuses on writing queries that answer business questions—e.g., "Which customer spent the most in March?" or "What is the month-over-month revenue growth?" The included dataset (a DVD rental store) is rich enough to allow complex multi-table joins, yet simple enough for a beginner to conceptualize. As a 2020 course, it does not cover
