Week1

Data Modeling

ER Model

Relation Model

ER→Relation Mapping

Week2

SQL Introduction

SQL Expressions

SQL Data Definition Language

DBMSs, PostgreSQL, SQLite

ER → SQL DDL

Week3

SQL: Sample DB

SQL: Updating

SQL: Queries (i)

SQ: Views

SQL: Queries (ii): Joins