SQL and Relational Theory 3rd Ed (O'Reilly)
Monday, 29 February 2016

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

<ASIN:1491941170>

data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. There is also a new appendix on NoSQL and relational theory.

Author: C.J. Date 
Publisher: O'Reilly
Date: November 16, 2015
Pages: 582
ISBN: 978-1491941171
Print: 1491941170
Kindle: B017S0YPOG

 

 

See the I Programmer review of the previous edition written by SQL guru Joe Celko

Visit Book Watch Archive for hundreds more titles. 

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for new additions to Book Watch and for new reviews.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Banner
 


Your AI Survival Guide

Author: Sol Rashidi
Publisher: Wiley
Date: April 2024
Pages: 224
ISBN: 978-394272631
Print: 1394272634
Kindle: B0CYLXSVW5
Audience: General
Rating: 3.5
Reviewer: Kay Ewbank

This is a book aimed at executives and managers who work in companies that don't yet use AI, with the aim of providing information to [ ... ]



Expert Performance Indexing in Azure SQL and SQL Server 2022

Author: Edward Pollack & Jason Strate
Publisher: Apress
Pages: 659
ISBN: 9781484292143
Print: 1484292146
Kindle: B0BSWH65ST
Audience: DBAs & SQL devs
Rating: 4 or 1 (see review)
Reviewer: Ian Stirk 

This book discusses indexes, a primary means of improving performance in SQL Server, how does  [ ... ]


More Reviews