SQL and Relational Theory: How to Write Accurate SQL Code by C. J. Date

Description

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, show more 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. show less

Recommendations

The Art of SQL by Stephane Faroult

The Art of SQL

Stephane Faroult

SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin

SQL Antipatterns: Avoiding the Pitfalls of Database Programming

Bill Karwin

Java in a Nutshell [2nd edition] by David Flanagan

Java in a Nutshell [2nd edition]

David Flanagan

Programming the Perl DBI by Tim Bunce

Programming the Perl DBI

Tim Bunce

Database in Depth: Relational Theory for Practitioners by C. J. Date

Database in Depth: Relational Theory for Practitioners

C. J. Date

SQL Pocket Guide by Jonathan Gennick

SQL Pocket Guide

Jonathan Gennick

Code Complete: A Practical Handbook of Software Construction by Steve McConnell

Code Complete: A Practical Handbook of Software Construction

Steve McConnell

SQL in a Nutshell: A Desktop Quick Reference by Kevin Kline

SQL in a Nutshell: A Desktop Quick Reference

Kevin Kline

High Performance MySQL: Optimization, Backups, Replication, and Load Balancing by Jeremy D. Zawodny

High Performance MySQL: Optimization, Backups, Replication, and Load Balancing

Jeremy D. Zawodny

Joe Celko's Trees and Hierarchies in SQL for Smarties by Joe Celko

Joe Celko's Trees and Hierarchies in SQL for Smarties

Joe Celko

Refactoring Databases: Evolutionary Database Design by Scott W. Ambler

Refactoring Databases: Evolutionary Database Design

Scott W. Ambler

Fundamentals of Database Systems by Ramez Elmasri

Fundamentals of Database Systems

Ramez Elmasri

Databases, Types and the Relational Model (3rd Edition) by C. J. Date

Databases, Types and the Relational Model (3rd Edition)

C. J. Date

Beautiful Code: Leading Programmers Explain How They Think by Andy Oram

Beautiful Code: Leading Programmers Explain How They Think

Andy Oram

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design by Michael J. Hernandez

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design

Michael J. Hernandez

Refactoring SQL Applications by Stephane Faroult

Refactoring SQL Applications

MySQL Cookbook by Paul DuBois

MySQL Cookbook

Paul DuBois

SQL for Dummies by Allen G. Taylor

SQL for Dummies

Allen G. Taylor

CSS Pocket Reference by Eric A. Meyer

CSS Pocket Reference

Eric A. Meyer

The Relational Database Dictionary by Chris J. Date

The Relational Database Dictionary

Chris J. Date

Purely Functional Data Structures by Chris Okasaki

Purely Functional Data Structures

Chris Okasaki

SQL Tuning by Dan Tow

SQL Tuning

Dan Tow

Learning SQL by Alan Beaulieu

Learning SQL

Alan Beaulieu

Sams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben Forta

Sams Teach Yourself SQL in 10 Minutes (3rd Edition)

Ben Forta

The Productive Programmer by Neal Ford

The Productive Programmer

Neal Ford

The Practice of Programming by Brian W. Kernighan

The Practice of Programming

Brian W. Kernighan

Applied Mathematics for Database Professionals by Lex deHaan

Applied Mathematics for Database Professionals

Lex deHaan

Joe Celko's SQL for Smarties: Advanced SQL Programming, Third Edition by Joe Celko

Joe Celko's SQL for Smarties: Advanced SQL Programming, Third Edition

Joe Celko

Implementation Patterns by Kent Beck

Implementation Patterns

Kent Beck

MySQL and mSQL by Randy Jay Yarger

MySQL and mSQL

Randy Jay Yarger

Programming C# 4.0: Building Windows, Web, and RIA Applications for the .NET 4.0 Framework by Ian Griffiths

Programming C# 4.0: Building Windows, Web, and RIA Applications for the .NET 4.0 Framework

Ian Griffiths

Mastering Regular Expressions by Jeffrey E. F. Friedl

Mastering Regular Expressions

Jeffrey E. F. Friedl

Joe Celko's SQL Programming Style by Joe Celko

Joe Celko's SQL Programming Style

Joe Celko

PHP and MySQL Web Development by Luke Welling

PHP and MySQL Web Development

Luke Welling

Programming Perl (3rd Edition) by Larry Wall

Programming Perl (3rd Edition)

Larry Wall

NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence by Pramod J. Sadalage

NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence

Pramod J. Sadalage

Agile Principles, Patterns, and Practices in C# by Robert C. Martin

Agile Principles, Patterns, and Practices in C#

Robert C. Martin

Working Effectively with Legacy Code by Michael Feathers

Working Effectively with Legacy Code

Michael Feathers

Regular Expressions Cookbook by Jan Goyvaerts

Regular Expressions Cookbook

Jan Goyvaerts

Access Database; Design & Programming by Steven Roman

Access Database; Design & Programming

Steven Roman

97 Things Every Software Architect Should Know: Collective Wisdom from the Experts by Richard Monson-Haefel

97 Things Every Software Architect Should Know: Collective Wisdom from the Experts

Richard Monson-Haefel

Refactoring: Improving the Design of Existing Code by Martin Fowler

Refactoring: Improving the Design of Existing Code

Martin Fowler

Web Database Applications with PHP and MySQL by Hugh E. Williams

Web Database Applications with PHP and MySQL

Hugh E. Williams

Expert C Programming by Peter van der Linden

Expert C Programming

Peter van der Linden

Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann

Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Martin Kleppmann

Programming Language Pragmatics by Michael L. Scott

Programming Language Pragmatics

Michael L. Scott

Refactoring HTML: Improving the Design of Existing Web Applications by Elliotte Rusty Harold

Refactoring HTML: Improving the Design of Existing Web Applications

Elliotte Rusty Harold

97 Things Every Programmer Should Know: Collective Wisdom from the Experts by Kevlin Henney

97 Things Every Programmer Should Know: Collective Wisdom from the Experts

Kevlin Henney

The Practical SQL Handbook: Using Structured Query Language (3rd Edition) by Judith S. Bowman

The Practical SQL Handbook: Using Structured Query Language (3rd Edition)

Judith S. Bowman

Complete Recommendations

Member Reviews

Featured Recent Thumbs

All Ratings
1
3
1
No Rating

2 reviews

tlockney 137 reviews

Reading this on my phone as an epub, so it's a bit slow going. I have the older edition of this in print, but it's changed enough that I'm trying to stick to the newer material.

Sep 7, 2014

tlockney 137 reviews

Reading this on my phone as an epub, so it's a bit slow going. I have the older edition of this in print, but it's changed enough that I'm trying to stick to the newer material.

Feb 5, 2012

Ratings

akbibliophile 34 reviews

Dec 16, 2011

ananthakumaran

Jan 2, 2021

colinstrickland 3 reviews

Members

Recently Added By: StrayerUni, potator, ascaland, zhuazhua88, colinstrickland, fagaggia, awlopata

All Members

Author Information

C. J. Date

45 Works 1,508 Members

C.J. Date has a stature that's unique in the database industry. Best known for his bestselling textbook, An Introduction to Database Systems (Addison-Wesley), he has been working with relational database theory since 1970. He enjoys a well-deserved reputation for his ability to explain complex technical issues in a clear and understandable fashion.

Series

Theory in Practice

40 works

Classifications

More Classifications

Statistics

Members: 116
Popularity: 278,215
Reviews: 2
Rating: (4.00)

Languages: English
Media: Paper, Ebook
ISBNs: 11
UPCs: 1
ASINs: 1

SQL and Relational Theory: How to Write Accurate SQL Code

by C. J. Date

Series:Theory in Practice

On This Page

Description

Tags

Recommendations

Member Reviews

Members

Author Information

Series

Classifications

Statistics

Quick Facts

Author

Popular Covers

Find It

Links

Popularity

Ratings

Helpers