Databases

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.

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.

Build real-world software by coding a Redis server from scratch.Network programming. The next level of programming is programming for multiple machines. Think HTTP servers, RPCs, databases, distributed systems.Data structures. Redis is the best example of applying data structures to real-world problems. Why stop at theoretical, textbook-level knowledge when you can learn from production software?Low-level C. C was, is, and will be widely used for systems programming and infrastructure software. It’s a gateway to many low-level projects.From scratch. A quote from Richard Feynman: “What I cannot create, I do not understand”. You should test your learning with real-world projects!

A visual guide for understanding Modern Data Pipelines Testing Techniques

Data Cleaning: The Ultimate Practical Guide is a guide to understanding what dirty data is, and how it gets into your dataset.This book will help you prevent most types of dirty data getting into your dataset, and clean out quickly and efficiently the remaining errors, so you can have clean, fit-for-purpose and analysis-ready data.