Web Application Development Module 3: Database Design and Implementation
About This Course
Designing a database for a web application is essential for delivering a reliable, scalable, and secure user experience. A well-designed web application database not only enhances application performance but also enables organisations to deliver seamless user experiences and achieve their business objectives effectively.
This practical course teaches participants to design, implement, and manage relational databases for dynamic web applications. Through hands-on projects building real-world applications (like movie review platforms and sports databases), participants will learn about core SQL operations and integrate databases with back-end systems (e.g., Express) and front-end frameworks (e.g., React) and build scalable, robust data layers essential for modern web application infrastructure, including implementing full CRUD functionality.
What You'll Learn
- Create relational databases using Structured Query Language (SQL), including tables with primary/ foreign keys.
- Write SQL queries to insert, retrieve, update, and delete data (CRUD operations).
- Link multiple tables using JOIN operations for data relationships.
- Build basic database-driven web apps with JavaScript/ Node.js integration.
- Apply input sanitisation to prevent SQL injection vulnerabilities.