The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!

SQL is code
Learn how to deal with SQL in your developer workflow: versioning, testing, code reviewing, deployment. Best practice and tools are covered.

Practical examples
Learn advanced SQL with practical examples and datasets that help you get the most of the book! Every query solves a practical use case and is given in context.

Database modelling
The book covers (de-)normalisation with simple practical examples to dive into this seemingly complex topic, including Caching and Indexing Strategy.

SQL for developers
This book is for developers, covering advanced SQL techniques for data processing. Learn how to get exactly the result set you need in your application’s code!

Write efficient SQL
Writing efficient SQL is easier than it looks, and begins with database modeling and writing clear code. The book teaches you how to write fast queries!

Batteries included
The book comes with open data sets and instructions to get them so that you can run all the SQL queries at home, edit them and learn from them. Advanced psql setup is even included!

https://theartofpostgresql.com/

向开发者传授SQL的书。学会用简单的查询来取代成千上万行的代码!

SQL就是代码

学习如何在开发者的工作流程中处理SQL：版本、测试、代码审查、部署。涵盖了最佳实践和工具。

实际例子

通过实际的例子和数据集来学习高级SQL，帮助你充分利用本书的内容 每一个查询都解决了一个实际的用例，并在上下文中给出。

数据库建模

本书涵盖了（去）规范化的内容，通过简单的实际例子来深入探讨这个看似复杂的话题，包括缓存和索引策略。

面向开发者的SQL

本书是为开发人员准备的，涵盖了数据处理的高级SQL技术。学习如何在你的应用程序的代码中准确地获得你需要的结果集!

编写高效的SQL

编写高效的SQL比看起来更容易，从数据库建模和编写清晰的代码开始。本书教你如何写出快速查询!

附带电池

本书附带开放的数据集和获取数据的说明，这样你就可以在家里运行所有的SQL查询，编辑它们并从中学习。甚至还包括高级psql设置!

https://theartofpostgresql.com/