Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. In this video, Chris Date shows you what a real relational product would be like, and how and why it would be so much better than what’s currently available.

Subscriber Reviews

Average Rating: 5 out of 5 rating Based on 4 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

Part 1: Foundations

Introduction

Preview

00:18:24

Basic Database Concepts Part 1

Play Video

00:19:29

Basic Database Concepts Part 2

Preview

00:06:19

Relations Part 1

Preview

00:16:56

Relations Part 2

Preview

00:10:37

Relations Part 3

Preview

00:03:00

Keys and Foreign Keys Part 1

Preview

00:24:28

Keys and Foreign Keys Part 2

Preview

00:09:11

Keys and Foreign Keys Part 3

Preview

00:01:51

Relational Operators 1 - Part 1

Preview

00:17:43

Relational Operators 1 - Part 2

Preview

00:14:22

Relational Operators 1 - Part 3

Preview

00:10:09

Relational Operators 1 - Part 4

Preview

00:22:37

Relational Operators 1 - Part 5

Preview

00:08:15

Relational Operators 2 - Part 1

Preview

00:20:49

Relational Operators 2 - Part 2

Preview

00:17:46

Relational Operators 2 - Part 3

Preview

00:02:08

Constraints and Predicates Part 1

Preview

00:15:27

Constraints and Predicates Part 2

Preview

00:21:46

Constraints and Predicates Part 3

Preview

00:02:43

The Relational Model Part 1

Preview

00:32:06

The Relational Model Part 2

Preview

00:04:34

Entr'acte

Entr'acte Transactions Part 1

Preview

00:13:41

Entr'acte Transactions Part 2

Preview

00:20:45

Entr'acte Design Theory Part 1

Preview

00:15:05

Entr'acte Design Theory Part 2

Preview

00:13:29

Entr'acte Design Theory Part 3

Preview

00:23:58

Part 2: SQL

SQL Tables Part 1

Preview

00:28:34

SQL Tables Part 2

Preview

00:04:19

SQL Tables Part 3

Preview

00:04:14

SQL Operators 1 - Part 1

Preview

00:21:53

SQL Operators 1 - Part 2

Preview

00:13:10

SQL Operators 1 - Part 3

Preview

00:25:06

SQL Operators 1 - Part 4

Preview

00:06:21

SQL Operators 2 - Part 1

Preview

00:16:09

SQL Operators 2 - Part 2

Preview

00:27:27

SQL Operators 2 - Part 3

Preview

00:01:59

SQL Constraints

Preview

00:20:42

SQL vs. the Relational Model Part 1

Preview

00:21:39

SQL vs. the Relational Model Part 2

Preview

00:08:37

References Complete

Preview

00:09:42

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the catalog page for Relational Theory for Computer Professionals

  • Catalog Page

Visit the errata page for Relational Theory for Computer Professionals

  • Errata