Learn SQL vs Complete Intro to SQL & PostgreSQL

Learn SQL is organised into four tightly scoped lessons — Manipulation, Queries, Aggregate Functions, and Multiple Tables — followed by five hands-on projects and four quizzes, with an estimated five hours to complete. The curriculum covers the genuine fundamentals of working with a relational database: creating and updating records, filtering and ordering result sets, computing aggregates with GROUP BY and HAVING, and joining related tables. For a complete beginner with no prior exposure to databases, this is a well-sequenced path that moves from individual statements to multi-table reasoning without overwhelming detail. The standout pedagogical feature, cited repeatedly across reviews, is the visual treatment of how data moves and combines. Multiple learners single out the animations that illustrate how rows transform during joins as the clearest explanation of that concept they had encountered, including some who had previously studied SQL at university and still preferred Codecademy's visual approach. The recurring criticism is depth. The course teaches SQL against a SQLite engine and, as one detailed blog reviewer put it, could fairly be retitled "Learn SQLite." It introduces primary and foreign keys but stops at uniqueness; it does not cover database normalisation, schema design, indexing, transactions, or window functions. Several reviewers noted topics that ended with an acknowledgement that more depth exists but would not be covered. The content is excellent for using an existing database and insufficient for designing a new one — an honest scope limitation rather than a quality failure.

The entire Learn SQL course — every lesson, project, and quiz — is free on the Basic plan. There is no paywall on the learning content itself, which over a million learners have taken. Payment is only required for a certificate of completion and Pro-exclusive features, available through Plus (around $14.99/month billed annually) or Pro (around $19.99/month billed annually), which add personalised feedback, career paths, and interview prep. For a learner whose goal is to become competent at querying data, the free tier delivers essentially the full value at zero cost — a strong proposition for a five-hour, fully interactive course. The certificate carries modest professional weight; reviewers and comparison articles broadly agree the real value is the skill gained rather than the credential, which is considered less rigorous than exam-based alternatives such as DataCamp's. The one caveat is platform-level: Codecademy's subscription scores poorly on Trustpilot (around 2.4/5), with complaints typically about billing and the upsell pressure toward Pro rather than the quality of this specific course. Learners who only want the free content should be deliberate about not auto-upgrading.

The skills taught — selecting, filtering, aggregating, and joining data — are exactly the day-one SQL competencies expected of analysts, developers, and data-adjacent roles, and the most common positive theme is immediacy. Learners describe being able to query data "the next day" and apply the syntax directly to work tasks within the same week. Codecademy positions the course as a building block of its Data Analyst Career Path, which adds Python, statistics, and visualisation around this SQL foundation. Because the course is purely query-focused, it transfers cleanly to any relational database a learner will encounter at work — the SELECT, JOIN, and GROUP BY patterns are standard across PostgreSQL, MySQL, and SQL Server. This makes it a reliable first rung whether the end goal is data analysis, backend development, or simply being literate when reading a colleague's query. The applicability ceiling is real-world database operations beyond querying. The course does not cover connecting to a production database, performance tuning, schema design, or the operational concerns of managing data at scale. One reviewer's analogy — that learning SQL here is like fencing against a hologram, with the theory but not the live feedback — captures the gap a learner must close with their own projects after finishing.

This is the course's defining strength. Every concept is taught inside Codecademy's browser-based coding environment, so learners write and run real SQL from the first lesson rather than watching video. There is nothing to install, no local database to configure, and the integrated console returns results immediately — a setup that removes the single biggest friction point that derails self-taught beginners. The five projects reinforce this. Guided projects such as "Create a Table" and the "New York Restaurants" exercise walk learners through applied scenarios, while the "Analyze Hacker News Trends" project pushes them toward more independent query writing against a realistic dataset. Reviewers consistently describe the learn-by-doing format as a "game changer" for self-study and credit it with making concepts stick far better than passive material. The trade-off, raised by more experienced learners and one forum thread, is that the sandbox can feel too forgiving: exercises sometimes surface full solutions or accept answers without the friction of debugging against a real production database. The practice is excellent for building correct mental models, but it does not replicate the messy feedback of connecting to and querying a live system.

Codecademy's model is interactive text instruction with inline exercises rather than a single charismatic video instructor, so "teaching quality" here means the clarity of the written lessons, the helpfulness of hints, and the pacing of exercises. On the whole this lands well: reviewers describe the explanations as touching "the essential with just enough context" and praise the gradual ramp that lets total beginners feel they "learned months in a week." The visual explanations of joins and table transformations are the most praised teaching element, repeatedly called the clearest treatment of the topic learners had seen. The embedded quizzes and immediate feedback loop keep engagement high and confirm comprehension after each lesson. Criticism centres on inconsistency in the exercise scaffolding. A minority of reviewers and forum posts found certain instructions terse or the hints unhelpful, and some exercises were felt to be padded with formatting that made them longer than the underlying concept warranted. These are isolated rough edges in an otherwise smooth and beginner-respecting teaching flow.

The course packs a substantial curriculum into 7 hours and 20 minutes, covering everything from database creation and basic CRUD operations to advanced topics including window functions, self joins, materialized views, transactions, and query performance analysis using EXPLAIN. The curriculum progresses logically, starting with fundamentals before building toward complex relational modeling — many-to-many relationships, foreign key constraints, and JSONB handling for semi-structured data. A distinguishing strength is the integration of Node.js exercises throughout, which connect raw SQL concepts to actual application development patterns. Reviewers consistently note that this practical framing — writing SQL in the context of a real backend app — sets the course apart from purely academic treatments of the language. The course materials are open-source (Apache 2.0 for code, CC-BY-NC-4.0 for lessons) and available at sql.holt.courses, which allows learners to revisit content after their Frontend Masters subscription lapses. The GitHub repository (442 stars, 68 forks as of mid-2026) also reflects active community engagement with the material. The one consistent criticism is scope relative to the "complete" label: one independent blogger (mattbatman.com) benchmarked Holt's similar SQLite course against Stephen Grider's 15+ hour Udemy offerings and found the depth lighter than the name implies. For a developer-oriented introduction to SQL fundamentals, however, the coverage is solid and well-sequenced.

Brian Holt brings an unusually credible background to this course — over a decade of engineering at Netflix, Reddit, and LinkedIn before moving into product management roles at Databricks, Neon, Snowflake/Streamlit, Stripe, and Microsoft Azure. This is not a bootcamp instructor teaching theory; the course reflects the experience of someone who has designed and queried databases in high-traffic production environments. Student feedback on Frontend Masters consistently praises Holt's teaching clarity. Testimonials from his broader catalog describe him as explaining "core principles in a clear, structured, easy-to-understand way," making learning "truly enjoyable and highly effective," and — in one superlative case — calling him "my favorite teacher of all time." These ratings span multiple courses, suggesting a consistent instructional standard rather than a single strong effort. The SQL course specifically draws praise for Holt's ability to contextualize database concepts within real web application workflows. One reviewer with eight years of web development experience noted they had previously avoided databases out of anxiety but finished the course feeling "well equipped to build the things which I procrastinated on." This transformation from apprehension to confidence is a recurring theme in the feedback. No substantive negative feedback targeting Holt's teaching style appeared in the reviewed corpus. The few critical comments focus on course scope or depth, not on instructional quality.

The course is available exclusively through a Frontend Masters subscription, priced at approximately $39/month or $390/year, which unlocks access to the full library of 200+ courses. For developers who plan to use multiple Frontend Masters courses, this model offers exceptional value — the SQL course alone would justify a month's subscription, and the library includes courses on React, Node.js, TypeScript, CSS, and system design that together form a complete web development curriculum. The open-source course website (sql.holt.courses) provides the written lessons and exercises at no cost, which is a notable differentiator. A developer on a tight budget can follow the written material for free; the Frontend Masters subscription adds the video recording of Brian teaching live, which many learners prefer for pacing and comprehension. The value calculation is somewhat sensitive to use case. A developer who wants only this one course and has no interest in the broader Frontend Masters library might find the subscription-only model slightly inflexible compared to a one-time Udemy purchase. However, no reviewer in the corpus raised this as a complaint — the consensus is that the library model represents good value for professional developers investing in continued learning.

The course is structured around hands-on exercises rather than passive video consumption. The Node.js integration exercises are the most praised component — they allow students to write SQL queries inside a working backend application, bridging the gap between learning syntax and understanding how SQL fits into real project architecture. One reviewer specifically called out the ability to "play around a bit in a NodeJS app to see how all of these concepts look like when you develop an app" as a key differentiator from other SQL courses. This framing reflects a genuine pedagogical choice: the course is designed for application developers who need to understand how to integrate SQL into a codebase, not for database administrators who work with raw SQL tooling. The course also uses the Movie Database (a well-known sample dataset) for query performance exercises, which gives learners a realistic dataset with enough complexity to demonstrate indexing and optimization meaningfully. The pgAdmin section provides familiarity with a production-grade GUI tool alongside command-line usage. The main limitation is the absence of a larger capstone project. The course builds toward exercises per module rather than a single cohesive application built from start to finish, which some developers prefer for a more integrated learning experience.

PostgreSQL is one of the most widely deployed relational databases in the industry, used by companies including Apple, Instagram, Spotify, and Netflix. Learning SQL through PostgreSQL positions developers for immediate applicability in a large fraction of real production environments. The course covers topics that regularly arise in professional database work: query optimization with EXPLAIN, indexing strategies (B-tree, GiST, GIN), transactions and isolation levels, views and materialized views for performance, and JSONB for hybrid relational/document data models. These are not academic topics — they are the exact problems that come up when a web application starts handling real user loads. Independent bloggers who have reviewed or recommended the course emphasize that Brian Holt "teaches you to think in SQL" rather than just syntax, which is the quality that separates educational content that sticks from reference material that fades. A developer with this foundation can productively engage with Prisma, Drizzle, SQLAlchemy, or raw SQL in any production context. Reviewers with significant prior experience report that the course delivered new, immediately applicable knowledge rather than only reinforcing basics. The developer who described it as "a great refresher course for Postgres and laying down the foundation for ORM" was reflecting a common pattern in the feedback: the course works both as a first introduction and as a consolidating reference for developers who learned SQL piecemeal.