Week06 Project04 Databases Overview

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