Developing Time-Oriented Database Applications in SQL
by Richard T. Snodgrass
Publisher: Morgan Kaufmann 1999
Number of pages: 528
Richard Snodgrass and his colleagues have explored temporal data concepts over the last two decades. They now have a fairly complete solution to the problems. Indeed the concepts are now being added to the SQL language standard. This book summarizes their work and presents it in a very accessible and useful way.
Home page url
Download or read it online for free here:
by Philip Greenspun
Introduction to SQL: data modeling, simple queries, complex queries, transactions, triggers, views, style, PL/SQL and Java, trees, handling dates in Oracle, limits in Oracle, tuning, data warehousing, foreign and legacy data and normalization.
by Markus Winand
SQL performance problems are everywhere, everyday. This book is a free SQL tuning e-book for developers. It avoids unnecessary details about database internals but highlights the one topic that is most often neglected: proper indexing.
This book is a compact comparative reference for several SQL language dialects. It lists particular common tasks and problems resolved in terms of several SQL server implementations. When possible, it tries to emphasize an universal solution.
Structured Query Language (SQL) is a widely-used query language for using database. This book provides a detailed description of SQL, its origins, its programming, and its uses. The book follows the specifications of the SQL:2008 ISO standard.