Lecture 00
Introduction
Database
Lecture 01
CS2102 IT2002 IT5008
SQL Create Populate Tables Constraints
Lecture 02
CS2102 IT2002 IT5008
SQL Queries Simple
Lecture 03
CS2102 IT2002 IT5008
SQL Queries Aggregate Joins
Lecture 04
CS2102 IT2002 IT5008
Design Entity Relationship Model Diagram
Lecture 05
CS2102 IT2002 IT5008
SQL Queries Nested
Lecture 06
CS2102 IT2002 IT5008
Theory Algebra
Lecture 07
IT2002 IT5008
Programming Procedures Functions Triggers
Lecture 08
IT2002 IT5008
Normalization FD
Lecture 09
IT2002 IT5008
Normalization Normal Form BCNF
Lecture 10
IT2002 IT5008
Normalization Normal Form 3NF
Lecture 11
IT2002 IT5008
Revision Triggers FD Normalization