SQL and Relational Theory, 2nd Edition

How to Write Accurate SQL Code



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

Price$16.10 - $78.33
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 153

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

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

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

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition

by Ben Forta

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.This handy pocket guide starts with ...

Price:  $17.59  |  Publisher:  SAMS Publishing  |  Release:  2017

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

by Marco Russo, Alberto Ferrari

Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to u...

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

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

PHP and MySQL Recipes, 2nd Edition

PHP and MySQL Recipes, 2nd Edition

by Frank M. Kromann

This book is a source of instant solutions, including countless pieces of useful code that you can copy and paste into your own applications, giving you answers fast and saving you hours of coding time. You can also use this book as a reference to the most important aspects of the latest PHP scripting language, including the vital functio...

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

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