Web Development
The data layer is a critical factor in the success of any web application, particularly with the rise of data breaches and security regulations all over the world. This module will focus on understanding and designing databases for the web, using the popular open-source MySQL database software, while touching on Postgres, another widely-used database.
Through this course, participants will learn about data integrity, normalisation, database structure, security; for hands-on, participants will create a simple web app to authenticate users and retrieve user data.
Install, set up, and run a MySQL database on Windows, Mac, and the cloud
Describe the characteristics of a relational database, and understand SQL terms such as databases, schemas, tables, and rows
Build simple to intermediate SQL queries to extract data from a given dataset
Work with multiple tables using multiple keys and different types of join operations
Understand the need for, and perform simple data normalisation
Understand how and why database security issues arise, and how to guard against them
Create a functional CRUD (Create, Read, Update, Delete) web app with user authentication against a MySQL database
Appreciate the availability of different SQL implementations
