In this module, we will cover SQL databases and their integration with REST APIs. We will learn MySQL fundamentals, build database-connected Express APIs, and implement data relationships.
We will cover:
- SQL Database Setup: MySQL installation, database/table creation, and core CRUD operations (INSERT, SELECT, UPDATE, DELETE)
- API-Database Integration: Connecting Express to MySQL with mysql2, parameterised queries, and pagination
- Complete CRUD APIs: Building full REST APIs with proper validation, error handling, and TypeScript interfaces
- Data Relationships: Foreign keys, JOIN queries, and CASCADE DELETE behaviour between related tables