Overview
This course covers database schema, SQL, database normalization, hypermedia systems, Query By Example (QBE), primary and foreign keys, data redundancy, and schema building. The teaching method includes theoretical explanations and practical examples. The intended audience for this course is individuals interested in learning about database systems and SQL.
Syllabus
Database Schema.
SQL.
Database Normalisation.
Hypermedia Systems.
QBE: Why "Query By Example" Was Developed.
QBE: A Concrete Example.
QBE's Design Principles.
QBE's Relationship To SQL.
Primary & Foreign Keys.
Loans Database: Data Redundancy.
Loans Database: Identifying the Tables.
Loans Database: Building the Schema.
Flight Database: Identifying Records.
Flight Database: SQL Query.
Taught by
Eddie Woo