The mountain › Level 3 of 5
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.
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
- Why TypeScript?FREE
- Types and inferenceFREE
- Arrays and tuplesFREE
- Object types and interfacesFREE
- Typed functionsFREE
- Union types and narrowing
- Literal types
- Generics
- Typing async code and API data
- 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
- What is Node.js?
- Modules: require and module.exports
- Built-in modules and npm
- Reading files
- Writing files and JSON
- Asynchronous Node
- Events
- Handling errors
- Config and environment variables
- 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
- Requests and responses
- Your first Express server
- JSON responses and status codes
- Route parameters and query strings
- POST and request bodies
- Validating input
- CRUD: create, read, update, delete
- Middleware
- Routers and project structure
- Error handling in Express
- Authentication basics
- 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
- Why databases? Your first SELECT
- Filtering and sorting
- Insert, update, delete
- Counting and grouping
- Keys and JOIN
- Many-to-many and LEFT JOIN
- Designing tables and constraints
- Indexes and speed
- SQL from Node.js
- SQL injection
- Transactions
- Checkpoint: an orders API on SQLite
How every lesson works
- WatchA short animated figure shows the idea.
- PredictGuess what the code prints before you run it.
- PlayChange the code and see what happens.
- FixFind the bug in broken code.
- BuildWrite it yourself. Automatic checks tell you what works.
- 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.