SQL and Relational Theory

How to Write Accurate SQL Code



Bookstore > Books > SQL and Relational Theory

Price$3.50 - $48.07
Rating
AuthorC. J. Date
PublisherO'Reilly Media
Published2009
Pages428
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-100596523068
ISBN-139780596523060
EBook Hardcover Paperback

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. 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. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.


  1. (4 books)


4 5 243

Similar Books


SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

by C.J. Date

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.This third e...

Price:  $26.99  |  Publisher:  O'Reilly Media  |  Release:  2015

SQL and Relational Theory, 2nd Edition

SQL and Relational Theory, 2nd Edition

by C.J. Date

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to you...

Price:  $16.10  |  Publisher:  O'Reilly Media  |  Release:  2011

View Updating and Relational Theory

View Updating and Relational Theory

by C.J. Date

Views are virtual tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn't just desirable, it's crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appea...

Price:  $25.49  |  Publisher:  O'Reilly Media  |  Release:  2012

Database Design and Relational Theory, 2nd Edition

Database Design and Relational Theory, 2nd Edition

by C. J. Date

Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured and usable in the face of changing business models and software systems.This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is the scien...

Price:  $39.99  |  Publisher:  Apress  |  Release:  2019

Hands On Google Cloud SQL and Cloud Spanner

Hands On Google Cloud SQL and Cloud Spanner

by Navin Sabharwal, Shakuntala Gupta Edward

Discover the methodologies and best practices for getting started with Google Cloud Platform relational services - CloudSQL and CloudSpanner.The book begins with the basics of working with the Google Cloud Platform along with an introduction to the database technologies available for developers from Google Cloud. You'll then take an ...

Price:  $31.60  |  Publisher:  Apress  |  Release:  2020

Data Analysis Using SQL and Excel

Data Analysis Using SQL and Excel

by Gordon S. Linoff

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why ...

Price:  $19.00  |  Publisher:  Wiley  |  Release:  2007

LINQ to Objects Using C# 4.0

LINQ to Objects Using C# 4.0

by Troy Magennis

Using LINQ to Objects, .NET developers can write queries over object collections with the same deep functionality that was once available only with SQL and relational databases. Now, for the first time, developers have a comprehensive and authoritative guide to applying LINQ to Objects in real-world software. Microsoft MVP Troy Magennis i...

Price:  $36.22  |  Publisher:  Addison-Wesley  |  Release:  2010

MySQL Connector/Python Revealed

MySQL Connector/Python Revealed

by Jesper Wisborg Krogh

Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database. This book takes you from the initial installation of the connector through basic query execution, then...

Price:  $24.27  |  Publisher:  Apress  |  Release:  2018