LESSONPLAN.md

Lesson Plan Databases Week 1

Agenda

The purpose of this class is to introduce to the student:

• The how and why of data and the storing of it
• What kind of database MySQL is
• What Structured Query Language (SQL) is
• The basic commands of SQL (CREATE, SELECT, UPDATE, DELETE)

Core concepts

FIRST HALF (12.00 - 13.30)

Before you start, ask around and see if everyone has successfully installed the MySQL Community Edition Server

1. The how and why of data and the storing of it

• Explain why we need databases
• Show how a JavaScript array is a simple form of a database

const musicians = [
  "John Coltrane",
  "Miles Davis",
  "Thelonious Monk",
  "Sonny Rollins"
];

musicians.push("Steve Lehman");

• The importance of storing data in the right data structure

2. What Structured Query Language (SQL) is

Do exercise

SECOND HALF (14.00 - 16.00)

3. What kind of database MySQL is

4. The basic commands of SQL (CREATE, SELECT, UPDATE, DELETE)