SQL and Relational Theory, 2nd Edition

How to Write Accurate SQL Code



Bookstore > Books > SQL and Relational Theory, 2nd Edition

Price$16.10 - $82.43
Rating
AuthorC.J. Date
PublisherO'Reilly Media
Published2011
Pages448
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101449316409
ISBN-139781449316402
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 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 your use of SQL.

This 2nd edition includes new material on recursive queries, "missing information" without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you'll learn how to deal with a host of common SQL dilemmas.


  1. (4 books)



4 5 141

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

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 reasoning be...

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

Drupal for Education and E-Learning, 2nd Edition

Drupal for Education and E-Learning, 2nd Edition

by James G. Robertson, Bill Fitzgerald

As social networks become more popular, their role in the classroom has come under scrutiny. Drupal offers a wide variety of useful tools for educators. Within a single Drupal site, you can set up social bookmarking, podcasting, video hosting, formal and informal groups, rich user profiles, and other features commonly associated with soci...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2013

Pro SharePoint Disaster Recovery and High Availability, 2nd Edition

Pro SharePoint Disaster Recovery and High Availability, 2nd Edition

by Stephen Cummins

Few IT professionals take the time to learn what needs to be known to do disaster recovery well. Most labor under the pretense that good administration equals close to five-nines uptime. Most technical people do not see the value of planning for disasters until the unexpected has already happened, and the effects of a disaster involving a...

Price:  $53.11  |  Publisher:  Apress  |  Release:  2013

HTML5 and JavaScript Projects, 2nd edition

HTML5 and JavaScript Projects, 2nd edition

by Jeanine Meyer

Build on your basic knowledge of HTML5 and JavaScript to create substantial HTML5 applications. Through the many interesting projects you can create in this book, you'll develop HTML5 skills for future projects, and extend the core skills you may have learned with its companion book, The Essential Guide to HTML5.HTML5 and JavaScript Proje...

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

Seven Databases in Seven Weeks, 2nd Edition

Seven Databases in Seven Weeks, 2nd Edition

by Luc Perkins, Jim Wilson, Eric Redmond

Data is getting bigger and more complex by the day, and so are your choices in handling it. Explore some of the most cutting-edge databases available - from a traditional relational database to newer NoSQL approaches - and make informed decisions about challenging data storage problems. This is the only comprehensive guide to the world of...

Price:  $25.00  |  Publisher:  The Pragmatic Programmers  |  Release:  2018

Learning Cocoa with Objective-C, 2nd Edition

Learning Cocoa with Objective-C, 2nd Edition

by Apple Computer Inc, James Duncan Davidson

Learning Cocoa with Objective-C is the "must-have" book for people who want to develop applications for Mac OS X, and is the only book approved and reviewed by Apple engineers. Based on the Jaguar release of Mac OS X 10.2, this edition of Learning Cocoa includes examples that use the Address Book and Universal Access API...

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

Managing Risk and Information Security, 2nd Edition

Managing Risk and Information Security, 2nd Edition

by Malcolm Harkins

Examine the evolving enterprise security landscape and discover how to manage and survive risk. While based primarily on the author's experience and insights at major companies where he has served as CISO and CSPO, the book also includes many examples from other well-known companies and provides guidance for a management-level audience.Ma...

Price:  $22.68  |  Publisher:  Apress  |  Release:  2016