Learn SQL vs Web Performance Fundamentals, v2

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 covers the full stack of modern web performance knowledge in approximately six hours — a tight, well-curated curriculum that avoids the padding common in longer Udemy-style recordings. It opens with the psychology of perceived performance (drawing on David Maister's "Psychology of Waiting Lines"), then moves through Core Web Vitals metrics (LCP, CLS, and INP, which replaced FID as an official Google signal in March 2024), measurement APIs, synthetic testing with Lighthouse and WebPageTest, Real User Monitoring with CrUX, and finally concrete optimization tactics for each metric — TTFB, FCP, LCP, layout shift prevention, and interaction latency. The October 2024 update brought the curriculum fully current with the INP transition, so learners are not working with obsolete tooling or metrics. What sets the content apart from generic performance tutorials is its insistence on real user data before optimization. The recurring lesson — "focus on your worst metric, fix the most basic thing first, and confirm with RUM" — is a workflow, not just a collection of tips. The course also links performance work directly to business outcomes: conversion rate, SEO rankings, and user retention statistics are woven into the justification throughout, which gives engineers the language they need to advocate for performance work with non-technical stakeholders. The GitHub workshop repository (113 stars, 87 forks as of mid-2026) demonstrates the exercises have genuine uptake in the developer community.

Todd Gardner is one of the most credentialed practitioners teaching web performance in any format. As co-founder of TrackJS and Request Metrics, he has spent years building commercial RUM tools and working directly with thousands of development teams on performance problems — a background that produces very different teaching than a course built purely from documentation. His Frontend Masters blog articles (published November 2024 on INP and February 2025 on image optimization) extend the same practical, measurement-first methodology into the broader developer community. Student feedback collected from the official course page is unusually consistent in citing his teaching clarity as a differentiator. Anurag Bhandari wrote "Wonderfully planned and executed. Such a heavy topic explained in such simple terms." Pedro Antônio Pereira called it "a masterclass in how to understand web performance." Ryan Davidson, recommending it broadly, wrote: "Great blend of breadth and depth in the performance space. All web engineers — backend or frontend, junior or senior — should be taking this course!" The breadth of that recommendation — extending to backend engineers — reflects how Gardner anchors the course in concepts (HTTP caching, server response times, rendering pipelines) that apply regardless of whether you write CSS or database queries.

The course is included in a Frontend Masters subscription, priced at approximately $39/month or $390/year (annual plans have carried a 17-20% discount in 2025-2026). A seven-day free trial is available. For a subscriber who accesses even two or three courses, the per-course cost is minimal, and the Web Performance Fundamentals course is among the most immediately actionable in the entire library — the techniques taught apply to any existing project without needing to rebuild or refactor an architecture. Deeptiman Mallick's testimonial captures the evergreen value: "This course is like a bookmark to come back to when we're working on performance." Unlike courses that you complete once and set aside, the performance metrics and tools taught here — Lighthouse, WebPageTest, CrUX — are ones practitioners return to on every new project or optimization sprint. The value proposition is strongest for working developers with a real codebase to optimize; the course is less compelling as a purely theoretical exercise for learners with no project to apply it to. There is no standalone purchase option, so non-subscribers must commit to at least one month of the full subscription.

The hands-on component uses a real Node.js + Express e-commerce project — "Developer Stickers Online" — which is deployed to multiple regions and available on a global CDN with HTTP/3 support, making it possible to test real network conditions rather than synthetic localhost scenarios. Students work with actual Lighthouse scores, WebPageTest waterfalls, and CrUX field data rather than simulated metrics, which bridges the gap between tutorial and professional practice. The workshop's focus on a single, realistic project (rather than a series of disconnected toy exercises) is appropriate for the subject: web performance work lives in real measurement data, and the course correctly models that. The project repository's 87 forks suggest learners actively run the exercises rather than just watching. The main limitation is scope: the project is a static storefront, so learners working primarily on Single Page Applications, server-rendered frameworks like Next.js, or complex state-heavy UIs will need to extrapolate some of the tactics. There is no separate project tier with more complex application types.

Web performance is one of the highest-ROI skills a working web developer can acquire in 2024-2026: Core Web Vitals are a confirmed Google Search ranking signal, and the business case studies cited throughout the course (eCommerce and SaaS conversion improvements correlated with performance gains) are drawn from real production data. Gardner's background running RUM tools for thousands of teams means the tactics are not academic — they are the same ones practitioners reach for when a client's LCP score drops. Multiple student reviews specifically noted immediate applicability: Álex Castelo wrote that the course made them realize "how easy it can be to boost a website's performance exponentially," and Yuganshu Mohan distilled the practical lesson as "focus on the worst metric and perform the most basic fixes." The methodological frame — measure with real user data first, then fix, then confirm — transfers directly to professional performance audits. Taran Bains, writing an extended reference post from the course material in August 2025, used it as the foundation for a comprehensive web performance guide, which is a reliable signal that the content holds up as a reference long after the initial watch-through.