SQL and Relational Theory

How to Write Accurate SQL Code

Ranked #39 in SQL, Ranked #83 in Databases

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:


Should database access granted be through views instead of base tables?...
more

Similar Books

If you like SQL and Relational Theory, check out these similar top-rated books:


Learn: What makes Shortform summaries the best in the world?