SQL

84 hand-picked SQL problems, fully solved and explained — from your first SELECT to interview-ready queries. Seven volumes of pure practice: a problem, the data, the answer, and why it works. No theory chapters, no filler, every query tested against a real database. Solve first, read second.

What happens when AI starts making the decisions behind your database queries? This practical guide explores how modern optimizers work, then shows how machine learning and reinforcement learning can improve them. Learn to build, test and deploy AI-driven optimization systems that deliver real performance gains.

What if you could build a graph database the way SQLite is built to disappear into an application? This book takes you inside the engine, from storage pages and transactions to traversal, queries and crash recovery. With complete working code, you’ll build a fast, durable embedded graph database from the ground up.

The Databricks platform and data-engineering playbook for the engineers who own pipelines, govern catalogs, and keep workloads on schedule. Sixteen chapters on Unity Catalog, Lakeflow, identity, observability, and performance. Azure examples; concepts mapped to AWS and GCP.

The bugs live in the data. From your first SELECT to migration testing, NoSQL, and GDPR-compliant masking — with exercises all the way.

Kill N+1 queries, read EXPLAIN-friendly EF patterns, and ship faster ASP.NET APIs with a dense EF Core performance cookbook.

Aprende a combinar SQL, Python, estadística y Machine Learning para priorizar posibles fraudes en retail. Un enfoque práctico, técnico y aplicado, con ejemplos, visualizaciones y códigos de apoyo.

DuckDB is changing how developers think about analytics. This practical guide takes you from its architecture and SQL capabilities to performance tuning, cloud storage and production deployments. Learn how DuckDB works, where it shines and how to build fast, flexible analytical systems around it.

Go from your first SQL query to solving real database problems with confidence. This hands-on guide covers everything from SQL fundamentals and data analysis to advanced queries, optimization and production best practices, with practical examples that work across today’s major database systems.

Your query planner doesn't know how many rows will match. It guesses. This book shows you exactly how — and why it's sometimes wrong.

DuckDB has changed how people work with data by bringing fast analytical queries to a lightweight embedded database. Whether you are exploring Parquet files, building data pipelines or embedding analytics into your application, this handbook shows you how to get the most out of DuckDB with practical examples and real-world techniques.

SQLite is everywhere but running it well in production takes more than flipping a few settings. This book goes beyond the basics to show how SQLite really works, then walks through the patterns, tools and tradeoffs behind reliable, high-performance deployments. Packed with practical examples, it's built for engineers who want confidence in production.

Slow SQL queries waste time, increase costs, and limit scalability. Mastering SQL Performance Optimization teaches you how to analyze execution plans, optimize queries and indexes, and solve real-world performance bottlenecks across today's leading database platforms.

Your ORM works until it doesn't: a query returns ten thousand duplicated rows, a migration refuses a partitioned table, or the feature the product needs is one PostgreSQL has had for years. Twenty-one chapters that close the gap — LINQ translation, query plans, JSONB, full-text search, PostGIS and pgvector, then auditing, multi-tenancy and deployment. Every listing run against a live database. Every output captured, never typed.