SQL and Relational Theory

How to Write Accurate SQL Code



Bookstore > Books > SQL and Relational Theory

Price$77.83 - $96.26
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. (3 books)



4 5 216

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:  $27.34  |  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

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

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 appeared, there...

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

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

Streaming Systems

Streaming Systems

by Tyler Akidau, Slava Chernyak, Reuven Lax

Streaming data is a big deal in big data these days. As more and more businesses seek to tame the massive unbounded data sets that pervade our world, streaming systems have finally reached a level of maturity sufficient for mainstream adoption. With this practical guide, data engineers, data scientists, and developers will learn how to wo...

Price:  $42.99  |  Publisher:  O'Reilly Media  |  Release:  2018

Exam Ref 70-762 Developing SQL Databases

Exam Ref 70-762 Developing SQL Databases

by Louis Davidson, Stacia Varga

Prepare for Microsoft Exam 70-762, Developing SQL Databases - and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on t...

Price:  $25.00  |  Publisher:  Microsoft Press  |  Release:  2017