Free Trial

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

Overview

Chris Date is the world's best known relational advocate. In this online seminar, he shows how to write SQL code that's logically correct; how to avoid various SQL traps and pitfalls; and, more generally, how to use SQL as if it were a true relational language.

  • Appreciate how relational principles provide SQL's logical underpinnings.

  • Understand the breadth and depth of those principles.

  • Know how to formulate complex SQL code with confidence that it's correct.

  • Be able to use SQL relationally.

SQL is ubiquitous. But SQL is also complicated, difficult, and error prone -- much more so than SQL advocates would have you believe. There's a lot of bad practice in the way SQL is used, and testing SQL can never be exhaustive. If you have any hope of writing correct SQL, you must follow some discipline: the discipline of using SQL relationally.

It's a fact: SQL is the standard language for relational databases, but that doesn't make it relational! SQL departs from relational theory in all too many ways. Duplicate rows and nulls provide two obvious examples, but they're not the only ones. In this class, you'll learn relational theory, how SQL departs from the theory, and how to avoid the problems that can cause. By using the relational model as an organizing principle, and learning various features of the model in depth, you'll discover the best ways to implement SQL. And you'll enjoy the benefits of working with a truly relational system.

Exercises are an integral part of the class, and your discussion and interaction are encouraged. We are capturing these sessions on video and all students are required to sign a release form prior to the commencement of the class, a copy of which may be downloaded in advance. Hard copy forms will be provided at the event.

Subscriber Reviews

Average Rating: 4.842105263157895 out of 5 rating Based on 19 Ratings

"Pure relational/SQL wisdom from the source" - by greg606 on 02-AUG-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Incredible!
The most valuable course for IT guys.
The book covers much the same which makes it even more valuable as the knowledge can be deepened.

Report as Inappropriate

"C.J. Date's SQL and Relational Theory Master Class" - by Anonymous on 02-JUL-2011
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
very well done!
Report as Inappropriate

"Software Developer" - by jtang on 05-SEP-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
After graduating my master degree in Computer Science with specialty in database, this video presented by database master C.J. Date helps me to understand and review database theory in a way no one else could.
If you want to have a solid foundation on database theory, this is the one.

Report as Inappropriate

"Solid DB Fundamentals" - by maa on 03-JUN-2010
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
Both his books and presentations on the subject are worth the time and effort.
Report as Inappropriate

Table of Contents

Chapter/Selection

Time

Setting the Scene Part 1

Play Video

00:42:44

Setting the Scene Part 2

Preview

00:36:23

Types and domains Part 1

Preview

00:30:30

Types and domains Part 2

Preview

00:17:28

Types and domains Part 3

Preview

00:30:09

Tuples and Relations, Rows and Tables Part 1

Preview

00:17:07

Tuples and Relations, Rows and Tables Part 2

Preview

00:40:21

No Duplicates, No Nulls Part 1

Preview

00:18:19

No Duplicates, No Nulls Part 2

Preview

00:32:28

Base Relvars, Base Tables Part 1

Preview

00:19:51

Base Relvars, Base Tables Part 2

Preview

00:24:16

Base Relvars, Base Tables Part 3

Preview

00:20:49

SQL and Relational Algebra I: The Original Operators Part 1

Preview

01:00:26

SQL and Relational Algebra I: The Original Operators Part 2

Preview

00:58:11

SQL and Relational Algebra II: Additional Operators Part 1

Preview

00:29:26

SQL and Relational Algebra II: Additional Operators Part 2

Preview

00:47:12

SQL and Constraints Part 1

Preview

00:40:31

SQL and Constraints Part 2

Preview

00:38:35

SQL and Views Part 1

Preview

00:28:27

SQL and Views Part 2

Preview

00:27:59

SQL and logic I: Relational Calculus Part 1

Preview

00:44:49

SQL and logic I: Relational Calculus Part 2

Preview

00:25:32

SQL and logic I: Relational Calculus Part 3

Preview

00:26:07

SQL and logic I: Relational Calculus Part 4

Preview

00:27:36

SQL and Logic II: Using Logic to Write SQL Code Part 1

Preview

00:19:36

SQL and Logic II: Using Logic to Write SQL Code Part 2

Preview

00:27:03

Further SQL Topics

Preview

00:20:56

The Relational Model

Preview

00:38:53

A Relational Approach to Missing Information

Preview

00:32:21

Database Design Theory Part 1

Preview

00:44:28

Database Design Theory Part 2

Preview

00:24:03

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • cj_date_FINAL.pdf.zip