Free Trial

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

Overview

If you want to build databases that are robust, flexible, and accurate, you have to come to grips with design theory. But this theory is riddled with difficult terms and concepts that don’t seem to have much to do with design in practice. In this two-day master class, renowned expert C.J. Date bridges the gap by introducing design theory in ways practitioners can understand. This painless introduction to design theory is for database professionals familiar with the relational model.

Subscriber Reviews

Average Rating: 4.875 out of 5 rating Based on 8 Ratings

"Definitely worth the attention" - by mko on 15-NOV-2013
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Database Design and Relation Theory is targeted on database professionals. It means that you have to have some database related background already. If you don't, start with something else before you get into this one - for sure! Otherwise you might get lost in definitions and all the concepts presented in the seminar.

Video training is based on the book with the same title. So, you can choose either the book itself, or this companion material. By the way, together with the Video training you get all the slides as well. This way it is super easy to follow the seminar in case you want to focus on some particular slide. And you always have the possibility to refresh your memory quickly in case there are references to topics that have been already discussed.

The way material is presented is very concise and formal. You actually take a part in an academic lecture discussing Database Design. It will require lots of attention from your side and your brain will have to do work here. There is no chance for getting an easy path through it, unless you are already familiar with all the topics. You need to poses basic mathematical skills in terms of algebra of sets, basic knowledge of logic, and you should be familiar (maybe more suitable here would be comfortable) with the mathematical approach to proving theorems. It doesn't mean you will have to do this. But if you know what is it all about, it will be easier for you to follow the contents of the material.

As for the time. Don't assume you will spent the same amount of time as specified in the description. I'd easily multiply it by two. The point here is that you will definitely need to go through the slides carefully (from time to time) to get the concepts fully understood. Sometimes you will probably jump back to what you have already seen just to recall some concepts and to make sure you are on the right track with you way of thinking.

Even though this one is not an easy go, I'd definitely suggest it to people who are involved in database design. You might get surprised with some examples that are really counterintuitive. And (I must admit here) I was told some ideas in the past that were wrong by definition. Here, I got them explained once again - this time, the correct way.

Report as Inappropriate

"An absolute must" - by desmond54 on 25-APR-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Any developer who uses a database - and if you don't, why do you think you are a developer - should watch this. I did so as part of my Safari subscription - what a great deal - and have also bought the digital version of the book.

I recommend downloading the presentation slides from the Extras tab for reference as you are watching.

Watch the video and then read the book.

Well done O'Reilly and C.J. !!!

Report as Inappropriate

Table of Contents

Chapter/Selection

Time

Preamble

Play Video

00:29:37

A Review of Relational Basics

Preview

00:29:29

Normalization - Preliminaries

Preview

00:16:06

Normalization - FDs and BCNF (informal) - Part 1

Preview

00:35:23

Normalization - FDs and BCNF (informal) - Part 2

Preview

00:27:02

Normalization - FDs and BCNF (formal)

Preview

00:36:25

Normalization - Preserving FDs

Preview

00:33:10

Normalization - FD Axiomatization

Preview

00:13:14

Denormalization

Preview

00:20:42

Normalization - JDs and 5NF (informal)

Preview

00:27:10

Normalization - JDs and 5NF (formal) - Part 1

Preview

00:22:42

Normalization - JDs and 5NF (formal) - Part 2

Preview

00:27:11

Normalization - Implicit Dependencies - Part 1

Preview

00:29:50

Normalization - Implicit Dependencies - Part 2

Preview

00:11:21

Normalization - The Chase

Preview

00:18:03

Normalization - MVDs and 4NF

Preview

00:36:41

Normalization - Other Normal Forms - Part 1

Preview

00:28:18

Normalization - Other Normal Forms - Part 2

Preview

00:27:14

Orthogonality

Preview

00:30:25

Redundancy - Part 1

Preview

00:35:50

Redundancy - Part 2

Preview

00:11:57

Redundancy - Part 3

Preview

00:21:24

The Primacy of Primary Keys

Preview

00:20:18

Redundancy Revisited

Preview

00:19:37

Extras

The publisher has provided additional content related to this title.


Description
Content

Visit the errata page for C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

  • Errata

Visit the catalog page for C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

  • Catalog Page

Download the supplemental electronic content for C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class

  • Supplemental Content