Books

Unleash the hidden power of Excel to manage and analyze hierarchical data like never before. "Adam on: Excel Outlining with TreeWiz" is your ultimate guide to mastering this complex skill. Transform your Excel worksheets into dynamic, easy-to-navigate data trees with TreeWiz.

Tired of the cumbersome copy+paste routine in Excel tables? Step into the future with "Adam on: Excel Table Management with TableWiz." This comprehensive guide will teach you how to leverage metadata to automate, streamline, and elevate your Excel workflows like never before!

Unlock the power of data in the cloud! 'Building Cloud Data Platforms Solutions' is your passport to designing, implementing, and managing robust data solutions seamlessly. Journey through cutting-edge technology, expert strategies, and real-world examples. Elevate your data game – your cloud adventure starts now.

Develop an Ionic/Angular application powered by PHP/MySQL with GD library integration for dynamic image generation and manipulation

Develop cutting-edge Ionic applications using the MEAN stack (MongoDB, Express, Angular and Node) with projects featuring the Spotify and YouTube APIs

Build robust cross-platform apps powered by PouchDB, CouchDB, Ionic/Angular, Capacitor and ElectronJS

Learn to develop cutting-edge Progressive Web Apps using Ionic Framework and Angular powered by a Cloud Firestore, Firebase Storage and Firebase Hosting backend.

Introducing the ultimate guide to building modern data warehouses with Azure! Whether you're new to the field or a seasoned professional, this book is packed with valuable insights, practical tips, and real-world examples. From designing robust data pipelines to implementing scalable analytics solutions.

SQL 101 Crash Course is a comprehensive beginner's guide that takes you through the world of SQL, right from understanding databases to mastering complex queries. This book is designed to provide you with a solid foundation in SQL, along with practical examples and real-world scenarios to reinforce your learning.

Basic information about EdgeDB.

Whether you're a novice or an experienced PostgreSQL administrator, this book has everything you need to take your database management skills to the next level and become a PostgreSQL expert.

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.

Learn databases from the bottom up by coding your own, in small steps, and with simple Go code (language agnostic).Atomicity & durability. A DB is more than files!Persist data with fsync.Crash recovery.KV store based on B-tree.Disk-based data structures.Space management with a free list.Relational DB on top of KV.Learn how tables and indexes are related to B-trees.SQL-like query language; parser & interpreter.Concurrent transactions with copy-on-write data structures.

An exploration of one of the most fundamental concepts in computer science: the NULL value. Learn how NULL can be used and how its misuse can lead to serious errors and vulnerabilities. Whether you're a seasoned programmer or just curious about the history & inner workings of computing, this is a must-read that'll deepen your understanding of NULL!

The eBook is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL.