Learn TypeScript vs Learn SQL

Learn TypeScript covers the essentials of the language across seven lessons — Types, Functions, Complex Types (arrays and tuples), Union Types, Type Narrowing, and Advanced Object Types — in roughly 10 hours of guided content. The course holds a 4.6/5 rating on Codecademy from 2,298 ratings, with 65% awarding five stars. The Curricular.dev developer review confirms the content "covers the essentials" and is "a solid hands-on learning option for getting up to speed with TypeScript." The author of the New Screwdriver blog wrote that the TypeScript handbook "makes a lot more sense to me after this Codecademy course than it did before." The main content gap, flagged by multiple reviewers, is that the course is "a little light on coverage of classes and OOP, as well as modules and namespaces," which slightly offsets an otherwise strong foundation score.

Codecademy uses a curated, single-course-per-topic model rather than named celebrity instructors, and the Hackr.io review rates instruction 4/5 while noting the platform offers "only one high-quality course" instead of thousands of variable-quality alternatives. There is no live instructor and no real-time feedback; the ScoreBeyond review notes the platform "lacks live lectures or direct instructor interaction." An AI Learning Assistant provides automated, context-aware hints on the current lesson and solution code, partly compensating for the absence of a human teacher. Reviewers consistently describe the written explanations as "clear and easy to follow," which lifts the score, but the lack of any human guidance when stuck — forcing reliance on community forums — is the ceiling here.

The introductory Learn TypeScript course is free, including the lessons, quizzes, and guided projects; only the certificate of completion and some practice features sit behind the Plus ($17.49/month annual) or Pro ($29.99/month annual, $59.99 month-to-month) subscriptions. For a learner who only wants the TypeScript fundamentals, the free tier is exceptional value. The ScoreBeyond review scores price 4.8/5, citing "no payment required to start learning." The value score is held back by Codecademy's well-documented billing reputation: its Trustpilot profile sits around 2.7/5 across roughly 1,450 reviews, with recurring complaints about unexpected auto-renewals and difficult cancellations for those who do subscribe to Pro.

Hands-on practice is Codecademy's single strongest dimension and the most consistently praised aspect of this course. The Curricular.dev review observes that "almost every section requires you to run some code to learn the concept, followed by a practical hands-on exercise." Code is written in an in-browser terminal that behaves like a real command line, and each lesson is paired with a quiz and a guided project (7 lessons, 7 projects, 7 quizzes). One Codecademy learner, Anmol B., said the hands-on model beat Coursera, Scrimba, Udemy, and freeCodeCamp in their experience. The notable limitation: Curricular.dev points out the course "provides several guided projects, but no solo project opportunities," recommending learners supplement with independent builds.

For a skills course there is no test score to track, so we assess learning outcomes and readiness. Reviewers report concrete capability gains: the New Screwdriver author documented learning rest parameters, spread syntax, and `number.toFixed()`, and concluded the course "was worth my time investment" as preparation for reading the official TypeScript handbook independently. The Codecademy testimonial from Valerie J. credits the repetitive typing model with building "muscle memory and confidence." The principal caveat — surfaced across Reddit sentiment summaries and the ScoreBeyond review — is that the course is a strong on-ramp but not a destination: learners targeting real-world proficiency, generics depth, or OOP fluency will need follow-up resources and independent projects to convert the fundamentals into job-ready skill.

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.