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. Prior attendance at the C.J. Date Master Class SQL and Relational Theory: How to Write Accurate SQL Code is highly recommended. Classroom exercises are an integral part of the seminar, and attendee discussion and interaction are encouraged. You’ll receive a workbook containing copies of C.J. Date’s course slides.
Once you complete of this course, you will:
- Understand, and be able to apply, the scientific principles of normalization and orthogonality that underlie design practice
- Know which normal forms are important, how they differ from one another, and how to achieve them
- Understand dependencies and the concepts of dependency inference and dependency preservation
- Generally, understand the contributions (and the limitations) of design theory
Along the way, you’ll review aspects of design you should already be familiar with—although perhaps from unfamiliar perspective—and then explore in depth aspects you’re probably not familiar with. You’ll receive clear and accurate explanations and definitions of all pertinent concepts, without spending a lot of time on well-known material such as 2NF and 3NF.
About the speaker:
C.J. Date has a stature that’s unique in the database industry. Best known for his bestselling textbook, An Introduction to Database Systems (Addison-Wesley), he has been working with relational database theory since 1970. He enjoys a well-deserved reputation for his ability to explain complex technical issues in a clear and understandable fashion.
Table of Contents
- Preamble 00:29:38
- A Review of Relational Basics 00:29:30
- Normalization - Preliminaries 00:16:07
- Normalization - FDs and BCNF (informal) - Part 1 00:35:24
- Normalization - FDs and BCNF (informal) - Part 2 00:27:02
- Normalization - FDs and BCNF (formal) 00:36:26
- Normalization - Preserving FDs 00:33:11
- Normalization - FD Axiomatization 00:13:14
- Denormalization 00:20:42
- Normalization - JDs and 5NF (informal) 00:27:11
- Normalization - JDs and 5NF (formal) - Part 1 00:22:42
- Normalization - JDs and 5NF (formal) - Part 2 00:27:12
- Normalization - Implicit Dependencies - Part 1 00:29:51
- Normalization - Implicit Dependencies - Part 2 00:11:22
- Normalization - The Chase 00:18:03
- Normalization - MVDs and 4NF 00:36:42
- Normalization - Other Normal Forms - Part 1 00:28:18
- Normalization - Other Normal Forms - Part 2 00:27:14
- Orthogonality 00:30:26
- Redundancy - Part 1 00:35:51
- Redundancy - Part 2 00:11:58
- Redundancy - Part 3 00:21:24
- The Primacy of Primary Keys 00:20:18
- Redundancy Revisited 00:19:37
- Title: C.J. Date's Database Design and Relational Theory: Normal Forms and All That Jazz Master Class
- Release date: April 2012
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449336370