SQL is ubiquitous, but it's also complicated, difficult, and error prone. In this video, C.J. Date -- the world's best-known relational advocate -- shows you 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.
What makes SQL so complicated? Duplicate rows and nulls provide two obvious examples, but they're not the only ones. With C.J. Date's clear and concise instruction, you'll learn relational theory, how SQL departs from the theory, and how to avoid the problems that can cause.
You should have at least an elementary familiarity with database concepts in general and the SQL language in particular before watching the video. After viewing the video, you will:
- Have a solid understanding of relational theory
- Appreciate how that theory provides SQL's logical underpinnings
- Understand the breadth and depth of that theory
- Know how to formulate complex SQL code with confidence that it's correct
- Generally, be able to use SQL relationally
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.