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