> For the complete documentation index, see [llms.txt](https://founders-and-coders.gitbook.io/coursebook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://founders-and-coders.gitbook.io/coursebook/src/course/syllabus/developer/week06-project04-databases/overview.md).

# 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](https://github.com/foundersandcoders/sql-challenge)

### Friday [Authentication web apps](https://learn.foundersandcoders.com/learn/auth/)

## 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