• 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, 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
• The Mirror Site (2) - PDF
• Book Homepage

• Database Lifecycle Management: Achieving Continuous Delivery

  This book describes how to apply the business and technical approaches of Database Lifecycle Management (DLM) in order to make database change management processes more visible, predictable and measurable.

• The Internals of PostgreSQL (Hironobu Suzuki)

  This book describes the internals of PostgreSQL for database administrators and system developers. The main purposes of this book are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

• Introduction to SQL (Bobby Iliev)

  SQL knowledge is essential for anyone involved in programming, data science, and data management. This is an introduction to SQL that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects.

• A Primer on SQL (Rahul Batra)

  This book is an introduction to the basics of SQL. No prior experience with SQL is necessary, but some knowledge of working with computers in general is required. It is not intended as a reference work or for a full time database administrator.

• SQL Queries Succinctly (Nick Harrison)

  This book shows you how to craft queries in SQL, from basic CRUD statements and slicing and dicing the data, to applying filters and using aggregate functions to summarize the data, solving common problems, navigating hierarchical data, etc.

• SQL for Web Nerds (Philip Greenspun)

  This book covers data modeling, simple queries, complex queries, transactions, triggers, views, style, PL/SQL, trees, handling dates in Oracle, limits in Oracle, tuning, data warehousing, foreign and legacy data and normalization.

• Essential SQL (Krzysztof Kowalczyk)

  This book provides clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) as well as those diving in more complex topics. Examples are linked to online playground that allows you to play with them.

• Structured Query Language (WikiBooks)

  This book provides a short description of SQL, its origins, basic concepts and components, and many examples. The book follows the specifications of the SQL:2011 standard developed by a common committee of ISO and IEC.

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.