Databases

Learn how to install, configure, and use the MonetDB analytical database on Ubuntu Linux. This practical guide walks through real examples and command-line workflows, helping you quickly understand how MonetDB works and how to use it effectively for analytical SQL workloads.

Learn how real databases work by following this practical guide to building your own in a programming language of your choice.Build a language from scratch- Create an interpreter that can parse, type check and run SQL queries. Start with running simple queries and build up to more complex ones.Learn SQL (the fun way) - Gain a deeper understanding of SQL. Cover the order of execution of queries, how SQL uses ternary logic and the techniques that databases use to join and group data efficiently. Compare your implementation with databases such as PostgreSQL, MySQL, SQLite and DuckDB.Improve as a programmer- The perfect project to practice how to structure and refactor code as you grow the feature set of your database server. The 200+ included test cases provide a safety net for refactoring your code, giving you freedom to experiment. Learn computer science topics including creating a recursive descent parser, building a type checker and implementing iterators.

Modelación de base de datos relacional.Normalización y documentación de base de datos.Programación DDL en MySQL, Oracle y SQL Server.

You know Java. The hard part is the @Transactional method that quietly opens no transaction, the list endpoint that issues a thousand queries, and the service field two threads corrupt under load — failures that produce no compiler error, no stack trace, and no failing test. This is a field manual about those failures and the skills that surround them: reading a codebase you did not write, changing it safely, and diagnosing it when it breaks.

Supabase wired into Claude and Cursor over MCP, with RLS designed for agent access, service_role blast radius contained, and ten failure modes diagnosed.

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.

Go beyond the basics and learn how to get the most from RocksDB. This practical guide explains the architecture behind its speed, shows how to tune it for real workloads and helps you solve performance issues with confidence. Packed with code examples and production-focused advice, it is built for developers who need storage that scales.

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.

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

An Oracle DBA handed a MySQL database is surprised twice: first by how little seems to be there, then by how much of what you know doesn't carry over. All 79 chapters translate what you already do in Oracle — architecture, execution plans, indexing, replication, failover — into the language of MySQL 8.4, with every result measured on real servers. Continuously updated.

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.