Week of October 14th

This week focuses on building a dynamic e-commerce web application, integrating React for the frontend with a Node.js/Express backend and SQLite database. The emphasis is on creating a full-stack application with database integration and state management in React.

Workshops

Monday

Friday

Execute Program

• Finalise previous courses

Topics

• Database schema design and normalization

• SQLite database management and querying

• SQL syntax, focusing on SELECT and INSERT queries

Project

• Develop an e-commerce web application with the following features:

• Design and implement a SQLite database schema for products, orders, and users

• Create a React frontend that communicates with an Express backend

Additional Skills

• Database relationship modeling (one-to-many, many-to-many)

• Using foreign keys in relational databases

• Optimizing database queries for performance