/databases

Course structure for relational databases class using MySQL as an example

Primary LanguageHTML

Databases

Relational Database Systems

About

This three-week program aims to introduce the fundamental concepts of databases using MySQL.

Key Objectives

By the end of this module, students should have a familiarity with and basic understanding of the following:

  • Entities
  • The relational model
  • The Structured Query Language (SQL)
  • The construction of a database system
  • MySQL as an example of a relational database system

Lesson Plan

Lesson 1: MySQL and Node Setup! Create, Insert and Select !

Objective: This class aims to incorporate JavaScript code to operate the MySQL database. MySQL client can be used to demonstrate SQL queries however, students should know how to make a MySQL database connection from JavaScript, run queries from JavaScript and capture results of queries in JavaScript.

Lesson 2: Group by, Having and Joins. Promisification of JS client with prepared statements

Objective: This class introduces more clauses (group by, having) in the select statement. MySQL joins (inner, self, left and right) should be explained with demonstration (Employee table with reportsTo field and Department table with its PK in Employee table is suitable for this demonstration). Promise based JavaScript program with SQL prepared statements should be understood by students. The program can be found in the Week2 folder (Credits: @remarcmij)

Lesson 3: Database design, normal forms, SQL injection

Objective: This class invites students to discuss Entity Relationship Diagram (ERD). Students should be able to explain their choices of entities, relationships, attributes etc. SQL injection should be explained with a demonstration (with a simple JS client). Concepts of database transaction, ACID properties, normal forms should be introduced with examples / live coding (creating a transaction, committing and rollback-ing).

Handing in homework

Take a look at this video made by Daan, he explains how your homework needs to be handed in.

Also review the Git workflow material from the JavaScript3 module, use this as a reference.