SQL Performance Explained
by Markus Winand
Number of pages: 207
SQL performance problems are everywhere, everyday. SQL Performance Explained 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.
Download or read it online for free here:
In this SQL tutorial, you will learn how to use the SQL language to: Store, retrieve and manipulate data in SQL server; Select, insert, update and delete rows in SQL tables; Create database and tables in SQL server and all other SQL concepts.
by Richard T. Snodgrass - Morgan Kaufmann
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. This book summarizes their work and presents it in a very accessible and useful way.
by Mark McIlroy - Blue Sky Technology
An introduction to the use of SQL to retrieve data and generate query result tables. The book covers SQL queries and is suitable for beginners and intermediate users. This includes an on-line environment where you can try out the examples.
by Ryan Stephens, Ron Plew - Sams
This book presents the key features of SQL in an easy to understand format with updated code examples. The material covers transactions, constructs, embedded databases, object-oriented programming, and MySQL, a very popular open source database.