Chris Date is the world's best known relational advocate. In this online seminar, he shows howto 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.
Table of contents
- Setting the Scene Part 1
- Setting the Scene Part 2
- Types and domains Part 1
- Types and domains Part 2
- Types and domains Part 3
- Tuples and Relations, Rows and Tables Part 1
- Tuples and Relations, Rows and Tables Part 2
- No Duplicates, No Nulls Part 1
- No Duplicates, No Nulls Part 2
- Base Relvars, Base Tables Part 1
- Base Relvars, Base Tables Part 2
- Base Relvars, Base Tables Part 3
- SQL and Relational Algebra I: The Original Operators Part 1
- SQL and Relational Algebra I: The Original Operators Part 2
- SQL and Relational Algebra II: Additional Operators Part 1
- SQL and Relational Algebra II: Additional Operators Part 2
- SQL and Constraints Part 1
- SQL and Constraints Part 2
- SQL and Views Part 1
- SQL and Views Part 2
- SQL and logic I: Relational Calculus Part 1
- SQL and logic I: Relational Calculus Part 2
- SQL and logic I: Relational Calculus Part 3
- SQL and logic I: Relational Calculus Part 4
- SQL and Logic II: Using Logic to Write SQL Code Part 1
- SQL and Logic II: Using Logic to Write SQL Code Part 2
- Further SQL Topics
- The Relational Model
- A Relational Approach to Missing Information
- Database Design Theory Part 1
- Database Design Theory Part 2
- Title: C.J. Date's SQL and Relational Theory Master Class
- Release date: April 2010
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449389659
You might also like
Design Patterns in the Real World, an Analysis-Based Approach
Alan Holub takes coders deep into the reality of Gang-of-Four design patterns, those reusable guides to …
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …