SQL and Relational Theory, 2nd Edition
How to Write Accurate SQL Code
Price | $16.10 - $78.33
|
Rating | |
Author | C.J. Date |
Publisher | O'Reilly Media |
Published | 2011 |
Pages | 448 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1449316409 |
ISBN-13 | 9781449316402 |
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.
- C.J. Date (4 books)
4 5 153
Similar Books
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
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
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
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
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
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
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
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