SQL and Relational Theory, 3rd Edition

How to Write Accurate SQL Code



Bookstore > Books > SQL and Relational Theory, 3rd Edition

Price$26.99 - $28.00
Rating
AuthorC.J. Date
PublisherO'Reilly Media
Published2015
Pages582
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101491941170
ISBN-139781491941171
EBook Hardcover Paperback

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 edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. A special feature of this edition is a new appendix on NoSQL and relational theory.


  1. (4 books)


4 5 151

Similar Books


SQL and Relational Theory

SQL and Relational Theory

by C. J. Date

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 reasoni...

Price:  $3.50  |  Publisher:  O'Reilly Media  |  Release:  2009

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

Microsoft Excel 2010: Data Analysis and Business Modeling, 3rd Edition

Microsoft Excel 2010: Data Analysis and Business Modeling, 3rd Edition

by Wayne L. Winston

Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of...

Price:  $4.54  |  Publisher:  Microsoft Press  |  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

Learn Python the Hard Way, 3rd Edition

Learn Python the Hard Way, 3rd Edition

by Zed A. Shaw

Zed Shaw has perfected the world's best system for learning Python. Follow it and you will succeed-just like the hundreds of thousands of beginners Zed has taught to date! You bring the discipline, commitment, and persistence; the author supplies everything else.In Learn Python the Hard Way, 3rd Edition, you'll learn Python by w...

Price:  $8.12  |  Publisher:  Addison-Wesley  |  Release:  2013

Windows 10 For Dummies, 3rd Edition

Windows 10 For Dummies, 3rd Edition

by Andy Rathbone

Millions of Windows users have turned to Windows For Dummies for quick, friendly, and easy-to-understand help with their computers. Windows 10 For Dummies, 3rd Edition continues this tradition as it helps you navigate the twists and turns of Windows. Start at the beginning to discover the basics of the Windows interface or flip to later c...

Price:  $15.10  |  Publisher:  Wiley  |  Release:  2018

Beginning Hibernate, 3rd Edition

Beginning Hibernate, 3rd Edition

by Joseph Ottinger, Jeff Linwood, Dave Minter

Beginning Hibernate, 3rd Edition is ideal if you're experienced in Java with databases (the traditional, or "connected," approach), but new to open-source, lightweight Hibernate, a leading object-relational mapping and database-oriented application development framework.This book packs in information about the relea...

Price:  $38.28  |  Publisher:  Apress  |  Release:  2014