The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...

Master modern database and search technologies with this comprehensive four-book bundle. Learn PostgreSQL administration, SQL performance optimization, production vector search with Qdrant, and Elasticsearch, from core concepts to enterprise-scale deployment and optimization.
Bought separately
$116
Minimum price
$65.00
$79.00
About the Bundle
Modern software systems depend on fast, reliable, and intelligent data platforms. Whether you're operating mission-critical PostgreSQL clusters, optimizing SQL performance across multiple database engines, building Retrieval-Augmented Generation (RAG) applications with vector search, or deploying large-scale search infrastructure with Elasticsearch, mastering these technologies requires far more than learning syntax. It requires understanding how systems work internally, why performance bottlenecks occur, and how to design architectures that remain reliable under real production workloads.
The Database & Search Systems Professional Bundle brings together four comprehensive references that span the complete modern data stack. Rather than focusing on isolated tutorials or introductory examples, these books emphasize production engineering, architectural understanding, operational excellence, and performance optimization. Together they provide thousands of pages of practical guidance, detailed explanations, hands-on examples, and real-world best practices suitable for database administrators, backend engineers, platform engineers, DevOps professionals, search engineers, AI practitioners, and technical architects.
The journey begins with The PostgreSQL Administrator's Handbook, a comprehensive guide to deploying, securing, monitoring, scaling, and maintaining PostgreSQL in production. From storage internals and query processing to replication, backup strategies, disaster recovery, automation, and performance tuning, it equips readers with the knowledge needed to confidently manage modern PostgreSQL environments.
Next, Mastering SQL Performance Optimization develops a deep understanding of how relational databases execute queries across PostgreSQL, MySQL, SQL Server, Oracle, and SQLite. Readers learn to interpret execution plans, design effective indexes, optimize joins, reduce latency, improve concurrency, and systematically solve performance problems using techniques that transfer across database platforms.
As AI-powered applications increasingly rely on semantic retrieval, Mastering Qdrant for RAG Applications explores the architecture and operation of production vector databases. The book covers embeddings, similarity search, HNSW indexing, quantization, hybrid search, metadata filtering, distributed deployments, security, monitoring, and large-scale Retrieval-Augmented Generation systems while demonstrating integrations with leading AI frameworks and programming languages.
Completing the collection, Mastering Elasticsearch provides a full exploration of one of the world's most widely deployed search and analytics platforms. From index design and Query DSL to relevance tuning, aggregations, vector search, cluster administration, scaling, monitoring, and production operations, the book prepares readers to build high-performance search systems capable of serving millions of users and processing massive datasets.
Although each title stands on its own, together they form a unified learning path covering transactional databases, SQL optimization, semantic vector retrieval, and large-scale search infrastructure. The concepts complement one another, enabling readers to understand not only how individual technologies function, but also how they integrate into modern distributed applications, data platforms, and AI systems.
Whether your goal is becoming a PostgreSQL administrator, a database performance specialist, a search engineer, a platform architect, or an AI infrastructure engineer, this bundle provides the practical knowledge, architectural insight, and production-tested techniques needed to design, optimize, operate, and scale the data systems that power today's software.
About the Books
This is a complete guide to administering PostgreSQL in production environments. Whether you are deploying your first database server or managing a fleet of high-availability clusters, this book walks you through everything from architecture internals and installation to security hardening, backup and recovery strategies, replication setups, performance tuning, and automated operations. It covers PostgreSQL 17 and 18 (the latest stable releases as of mid-2026) with practical examples, real-world configurations, hands-on labs, and production-tested best practices drawn from the official documentation and community expertise.
Slow SQL queries cost real money. Every millisecond of latency compounds across thousands of concurrent users, driving up infrastructure bills and degrading user experience. This book teaches you how databases execute queries internally, so you can systematically diagnose and resolve performance problems across PostgreSQL, MySQL, SQL Server, Oracle, and SQLite. Through execution plan analysis, indexing strategies, join optimization, schema design principles, concurrency management, and real-world case studies, you will build the skills to transform sluggish queries into high-performance operations that scale under production load.
Retrieval-Augmented Generation has become the dominant architecture for production AI applications, and vector databases form its critical retrieval layer. This book takes you from the fundamentals of embeddings and similarity search through to advanced distributed deployments of Qdrant, the high-performance open-source vector database written in Rust. You will learn every facet of Qdrant's feature set: collections, points, payloads, HNSW indexing, quantization, hybrid search with dense and sparse vectors, metadata filtering, faceting, sharding, replication, security, monitoring, and scaling. Through detailed code examples in Python, JavaScript, Go, Java, C#, and Rust, you will build complete RAG pipelines integrated with LangChain, LlamaIndex, Haystack, and a wide range of embedding providers. This is not a tutorial collection; it is a comprehensive reference that explains the why behind every feature, the trade-offs between every configuration choice, and the production engineering practices that separate experimental prototypes from systems serving millions of queries per day.
Elasticsearch is the world's most popular search and analytics engine, powering everything from e-commerce product search to real-time log analysis at global scale. This book takes you on a complete journey from absolute beginner to production-ready expert. You will learn how Elasticsearch works under the hood, how to deploy it across any environment, how to design indexes for maximum performance, how to write sophisticated queries using the full Query DSL, how to tune relevance and ranking, how to leverage modern vector and semantic search, and how to operate clusters reliably in production. Every chapter includes hands-on code examples in Python, Java, JavaScript, and REST API, along with real-world case studies drawn from actual deployments. Whether you are building your first search feature or managing a multi-terabyte cluster serving millions of queries per day, this book gives you the knowledge and practical skills to succeed.
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.