Databases

Stop treating PostgreSQL like slightly broken MySQL and start using it the way it was designed.

The software landscape is more crowed than ever! New frameworks seem to arrive weekly.  There are tons of books out there about mastering specific frameworks, but here is one to help you master the one constant factor, no matter where you are:  constructing the source code. Build great things in any programming notation; the rules are inside...

Stop memorizing SQL answers. Start solving real problems.Master 42 practical SQL challenges with tested queries, clear explanations, and hands-on exercises designed to build confidence for technical interviews.

Understand Firebase through visual explanations of identity, data, security rules, backend processing, delivery, and operations.

Understand DynamoDB through visual explanations of access patterns, keys, queries, consistency, data modeling, and reliable operations.

Understand Redis data structures, caching, persistence, replication, and reliable operations through clear visual explanations.

This book will walk you through the best practices to use the indexes.

An in-depth, by examples ,look to the forgotten powerful tool .The jsonb type

Costruisci da zero un archivio documentale completo con Django 6.1, HTMX e ricerca per significato con pgvector, fino alla messa in produzione.

Learn pandas, the most widely used data analysis library.

Running ClickHouse at petabyte scale takes more than knowing SQL. This practical guide shows experienced engineers how to design, deploy and operate production clusters, from data modeling and ingestion to Kubernetes, query tuning, observability, disaster recovery and cost control, with real-world patterns and concrete configurations throughout.

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.

86 recipes for the JasperReports reports that should work but do not, each a question Stack Overflow never settled, every claim run on 6.20.6 first.

47 Cognos Analytics report recipes, every one reproduced on a live 12.1.2 instance, with the exact error text and the fix that clears it.

35 recipes for the SSRS and Power BI paginated report traps that waste afternoons, every one deployed and rendered on a live server first.