Summary

A Japanese-language guide to writing good SQL by Mick. SQL is a language specialized for manipulating data and lets you work with it flexibly, but because it follows its own distinct logic, not understanding that logic correctly produces SQL that is hard to read and that performs poorly. The book explains good and bad ways of writing the operations performed routinely: conditional branching, aggregation, loops, joins, and updates. Throughout, it has readers read the execution plan that shows how the database processes each query internally, aiming to build a felt understanding of why a given way of writing a query is more efficient, and why it improves readability and maintainability.

Target Readers

• Web application engineers who work with a database regularly, and database engineers
• Developers whose SQL has become hard to read or slow to run because they haven't fully grasped SQL's own distinct logic
• Readers who want to understand why a particular way of writing a query is more efficient, and why it improves readability and maintainability, by learning to read execution plans

Colophon

Publisher

Gijutsu-Hyohron

ISBN

978-4774173016

Published

Apr 2015

List price

¥2,838incl. taxMay differ from the actual selling price on Amazon