• Title SQL Performance Explained: Everything Developers Need to Know about SQL Performance
• Author(s) Markus Winand
• Publisher: Markus Winand (2012); eBook (CC Edition)
• License(s): CC BY-NC-ND 3.0
• Paperback 204 pages
• eBook HTML (CC Edition), and PDF
• Language: English, Deutsch, French, Spanish, Japanese
• ISBN-10: 3950307826
• ISBN-13: 978-3950307825
• Share This:  

Book Description

This book helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product.

SQL indexing is the most effective SQL tuning method and requires the same care as schema design yet it is often neglected during development.

Starting with the basics of indexing and the WHERE clause, it guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

Its systematic structure makes this book both a textbook and a reference manual that should be on every developer's bookshelf.

• Markus Winand is the SQL Renaissance Ambassador. He is on a mission to introduce developers to the evolution of SQL in the 21st century. Markus can be hired as trainer, speaker and consultant via winand.at.

• Amazon

• SQL - The Structured Query Language
• Oracle Databases
• PostgreSQL
• Database Theory and Systems
• Microsoft SQL Server

• SQL Performance Explained (Markus Winand)
• The Mirror Site (1) - PDF
• Book Homepage

• Developing Time-Oriented Database Applications in SQL
• SQL Queries Succinctly (Nick Harrison)
• Structured Query Language - A Practical Introduction (Akeel I. Din)
• SQL: A Comparative Survey, 2nd Edition (Hugh Darwen)