SQL And Relational Theory is the counterpart and work book to the 16 hour video training program SQL And Relational Theory Master Class by the same author who is both an expert in the field and can lay out the principles in a way that is easily understood.
Just because you work with SQL server does not make you a master at it. But by taking the time and learning SQL's underlying theory, you have the best guarantee that your SQL code will be correct and that your system will be robust and maintainable. In SQL And Relational Theory, you will learn how to apply relational theory directly to your use of SQL.
For this book, it is assumed that you are a database practitioner and reasonably familiar with SQL. It is also assumed that you have a working knowledge of either the SQL standard or at least one SQL product. It is not presumed that you have a deep knowledge of relational theory. This book contains 12 chapters and is 432 pages in length.
1, "Setting the Scene," begins by looking at the relational model as well as a discussion on terms and how the ones that are most common are the ones that cause the most confusion – these include the terms table, row, and column. There is also a review of the original relational model.
2, "Types and Domains," shows that relations can have attributes of any type and that these can be as complex as you like. Here you will learn about types and relations, what a type is, type checking, and collations in SQL.
3, "Tuples and Relations, Rows and Tables," takes a careful look at tuples and relations (what are referred to as rows and tables, in SQL parlance) which are the fundamental building blocks of the relational model. Here the author defines these concepts more precisely and what the consequences are of these more precise definitions.
4, "No Duplicates, No Nulls," are two of the most obvious SQL departures from the relational model. Here you will see what is wrong with duplicates, the issues that they can have, and how to avoid them. Then you will see the same discussions about the effects of null values on your implementation.
5, "Base Relvars, Base Tables," takes a closer look at the differences between relation values – relations, and relation variables – relvars. In this chapter you will take at the issues that are relevant to relvars in particular.
6, "SQL and Relational Algebra I: The Original Operators," discusses the original relational operators (join, union, intersect, etc.) in depth. It also examines certain ancillary but important issues such as the significance of proper attribute (or column) naming.