Books & Videos

Table of Contents

Introduction

09m 3s

Types

29m 5s

Relations

35m 12s

Relational Algebra - Part 1

23m 4s

Relational Algebra - Part 2

25m 30s

Relation Variables

40m 14s

Time and the Database

29m 41s

What's the Problem?

25m 35s

Intervals

32m 50s

Expand and Collapse

13m 41s

Pack and Unpack I - The Single Attribute Case

25m 11s

Pack and Unpack II - The Multiattribute Case

21m 26s

Generalizing the Relational Operators

30m 5s

Database Design I - Structure - Part 1

37m 39s

Database Design I - Structure - Part 2

15m 19s

Database Design II - Keys and Related Constraints - Part 1

16m 42s

Database Design II - Keys and Related Constraints - Part 2

17m 43s

Database Design III - General Constraints

32m 32s

Queries

18m 46s

Updates - Part 1

28m 16s

Updates - Part 2

20m 3s

Logged Time and Stated Time

30m 47s

Point and Interval Types Revisited

28m 0s

Numeric Types

20m 34s

Interval Types Revisited

18m 5s

SQL Support - Periods

29m 31s

SQL Support - Queries

16m 8s

SQL Support - System Time

17m 59s

SQL Support - Summary and Assessment

20m 11s

Appendixes

25m 14s