Databases

Ship the NEXUS-1 backend for real: a genuine SQL Server on every test run, a dispatcher proven under a killed process, structured logs with a correlation id, and a CI gate that will not package a red build. Two hundred tests, one Dockerfile, one honest boundary.

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.

Mastering Qdrant for RAG Applications is your practical guide to building production-ready RAG systems with the leading open-source vector database. Learn how to design, optimize, and scale high-performance vector search using Qdrant through clear explanations, real-world examples, and hands-on code.

Give the tested core a database and a public API — without letting either touch its rules. Build NEXUS-1's Infrastructure and API layers in .NET: EF Core, repositories, the outbox, RFC 7807, JWT. 654 tables, one seam that stays signed — every rule proven by watching it fail.

Every click, online transaction, social media interaction, business operation, healthcare record, mobile application, and connected device generates data. However, raw data alone cannot create value. The real power lies in discovering meaningful patterns, hidden relationships, useful knowledge, future trends, and actionable insights from that data.

Build a working SQL database engine in C++20 -- from raw pages to a realquery executor -- one compilable, measured challenge at a time. Everyperformance claim is a benchmark you run yourself; every unit ends with areal bug, caught red-handed and fixed. Nothing asserted. Everythingdemonstrated.

Master PostgreSQL administration with a practical guide to deploying, securing, optimizing, and operating production databases. Covering PostgreSQL 17 and 18, this book combines real-world examples, hands-on labs, and proven best practices for reliable, high-performance systems.

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.

CQRS in Practice is a hands-on guide to designing scalable, maintainable software with Command Query Responsibility Segregation. Through practical examples and real-world insights, you'll learn when CQRS is the right choice, how to implement it effectively, and how to avoid the pitfalls of overly complex architectures.

Two builds, one schema, zero faith required. From Table to Twin walks an industrial digital twin's SQL Server and EF Core backbone by hand and from code, then prints exactly where Database First and Code First disagree — for .NET developers who check every table against a live, running console.

One entity. One mapping. Clean context. From Entity to Context shows how to organize enterprise EF Core Code First projects with configuration classes, Fluent API, migrations, indexes, relationships, and a clean DbContext across the NEXUS-1 digital-twin schema.

One database. Seventeen sectors. Fully keyed. From Schema to System maps the complete SQL Server / EF Core data backbone behind the NEXUS-1 digital twin, showing how telemetry, alarms, root-cause analysis, reinforcement learning, compliance, reporting, and audit become one queryable system.

Become SnowPro Core certified in Snowflake!

My book is out. Not a SQL tutorial. Not a beginner's guide to databases. It's for the person who writes queries every day and still wonders — why did that take 4 seconds? Why did those two records overwrite each other? Why did the system collapse under load when everything looked fine? My Database as a Developer. 8 chapters. Real answers.

Master distributed systems through visual diagrams — from clock drift and CAP to Paxos, Raft, and distributed transactions, explained with clear illustrations instead of dense academic papers.