Zero to AI

The mountain › Level 3 of 5

LEVEL 3 · TYPESCRIPT, NODE.JS, APIS AND SQL

Backend Climber

Learn what happens behind the screen: servers, APIs and databases.

Try 5 free lessonsLessons 1, 2, 3, 4, 5. No login, no payment.
You can start here: every level can be bought on its own. The levels build on each other, so if you are new to this, Web Builder comes first.

What you will be able to do

  • Write typed code and read compiler errors
  • Build a REST API with routes, validation and error handling
  • Query and change a database with SQL
  • Connect an API to a database

What is inside

44 lessons in 4 units. Lessons 1, 2, 3, 4, 5 are free for everyone. The rest, the test and the boss projects are for students who buy the level.

Unit 1: TypeScript · lessons 1-10

JavaScript with types. The compiler is real, so the errors you see are the errors professionals see.

See the 10 lessons
  1. Why TypeScript?FREE
  2. Types and inferenceFREE
  3. Arrays and tuplesFREE
  4. Object types and interfacesFREE
  5. Typed functionsFREE
  6. Union types and narrowing
  7. Literal types
  8. Generics
  9. Typing async code and API data
  10. Checkpoint: a typed inventory

Unit 2: Node.js · lessons 11-20

Run JavaScript outside the browser: modules, files, async code and command-line programs.

See the 10 lessons
  1. What is Node.js?
  2. Modules: require and module.exports
  3. Built-in modules and npm
  4. Reading files
  5. Writing files and JSON
  6. Asynchronous Node
  7. Events
  8. Handling errors
  9. Config and environment variables
  10. Checkpoint: a command-line to-do app

Unit 3: HTTP and APIs · lessons 21-32

Requests, responses, status codes, Express routes, middleware, validation and API keys.

See the 12 lessons
  1. Requests and responses
  2. Your first Express server
  3. JSON responses and status codes
  4. Route parameters and query strings
  5. POST and request bodies
  6. Validating input
  7. CRUD: create, read, update, delete
  8. Middleware
  9. Routers and project structure
  10. Error handling in Express
  11. Authentication basics
  12. Checkpoint: a library API

Unit 4: Databases · lessons 33-44

Real SQL on a real SQLite database: queries, joins, aggregates, transactions and indexes.

See the 12 lessons
  1. Why databases? Your first SELECT
  2. Filtering and sorting
  3. Insert, update, delete
  4. Counting and grouping
  5. Keys and JOIN
  6. Many-to-many and LEFT JOIN
  7. Designing tables and constraints
  8. Indexes and speed
  9. SQL from Node.js
  10. SQL injection
  11. Transactions
  12. Checkpoint: an orders API on SQLite

How every lesson works

  1. WatchA short animated figure shows the idea.
  2. PredictGuess what the code prints before you run it.
  3. PlayChange the code and see what happens.
  4. FixFind the bug in broken code.
  5. BuildWrite it yourself. Automatic checks tell you what works.
  6. RecallOne question to lock it in.

How you clear this level

Pass the test30 questions. You need 75% to pass. It opens after you finish all 44 lessons, and you get a limited number of attempts (normally 1), so revise first.
Build all 2 boss projectsNotes REST API and Shop API with SQLite. It opens after the last lesson. Automatic checks run your program and tell you what works, and each project has a limited number of attempts (normally 1).
Earn your certificateBoth done: you get the certificate. Full Stack is the next stop when you want it.

Good to know

  • TypeScript and SQLite download once the first time you use them, so you need internet then. Node and Express are a faithful simulation that runs in your browser.
  • Your progress is saved to your account, so you can continue on another phone or laptop.
  • One account works on up to 2 devices.
Backend Climber: TypeScript, Node.js, APIs and SQL | ZERO TO AI