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 SQL Challenge
Friday Authentication web apps
Execute Program
Finalise previous courses
Topics
Database schema design and normalization
SQLite database management and querying
SQL syntax, focusing on SELECT and INSERT queries
Implementing CRUD operations in a web application
React component design and state management
Building responsive and dynamic user interfaces with React
Integrating backend APIs with React frontend
Managing relational data in web applications
Security considerations in database design and querying (e.g., SQL injection prevention)
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
Implement CRUD operations for products and orders
Ensure proper state management for the shopping cart functionality
Additional Skills
Database relationship modeling (one-to-many, many-to-many)
Using foreign keys in relational databases
Optimizing database queries for performance
Implementing search functionality in both frontend and backend
Error handling and data validation in full-stack applications
Last updated