Building on What We've Learnt

Introduction: Building on What We’ve Learnt

In Module 1, we learnt how to build CRUD APIs that stored data in arrays.

In Module 2 Lesson 1, we learnt SQL commands to modify database data.

In Lesson 2, we connected Express APIs to databases for reading data. Now we’ll combine all this knowledge to build complete CRUD APIs that persist data to the database.

In this lesson, we’ll:

• Extend our database-connected API to support all CRUD operations: Create, Read, Update, and Delete.
• Take the SQL commands we learnt in Lesson 1 (INSERT, UPDATE, DELETE) and integrate them into Express API endpoints, just like we did with SELECT in Lesson 2.
• Apply the HTTP methods we learnt in Module 1 (POST, PUT, PATCH, DELETE) to work with real database data instead of arrays.