Databases

"How Does Computer Science Work?" answers 28 key questions every software engineer should know, unraveling the technologies that shape our digital world. From how browsers work and cryptography secures data to AI, Web3, and quantum computing, this book bridges curiosity and understanding. Perfect for students, self-taught programmers, and seasoned developers, it’s your ultimate guide to mastering foundational concepts and cutting-edge innovations in computer science.

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, where, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

This PostgreSQL book gets you up to speed with PostgreSQL 16. It helps you get quick solutions to all your basic and advanced DBA challenges with a hands-on approach that helps you resolve problems while understanding the reasoning

This book will show you how to develop models and create dynamic dashboards using LookML. You’ll explore advanced features to gain deeper insights and make informed decisions. 

With practical approach and detailed examples, this book covers newest features of Apache Airflow 2.x and it's potential for workflow orchestration, operational best practices, and data engineering

The book provides a foundation of building intuitive dashboards using Kibana 8.x and application of data analysis techniques to research, mine and aggregate information to convey business insights and improve decision making.

Official pandas documentation, while thorough, does not contain many useful examples. This book guides you, as if you were looking over the shoulder of an expert, through situations that you are highly likely to encounter.

Python Feature Engineering Cookbook, Third Edition, walks you through tools and methods to craft powerful features from tabular, transactional, and time-series data for robust machine learning models.

Machine learning is an important driver of innovation in software products. This book will help you take your machine learning prototype to the next level and scale it up using concepts such as data provisioning, processing, and quality control.

Machine learning is an important driver of innovation in software products. This book will help you take your machine learning prototype to the next level and scale it up using concepts such as data provisioning, processing, and quality control.

Learn T-SQL Querying, Second Edition, is an up-to-date reference designed to help you write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis tasks.

Polars Cookbook is a compilation of practical recipes for efficient data wrangling using Python Polars. The book teaches you how to solve common data problems using Polars, create solutions tailored towards your specific use case, and more.

Overcome common challenges in data management, visualization, and security with this updated edition of Microsoft Power BI Performance Best Practices, and ramp-up your Power BI solutions, achieve faster insights, and drive better business outcomes.

In today’s project-based, SCRUM “infested” web development work scene you are either a Junior starting out or a Senior who lacks in-depth knowledge. There seems to be no in-between! After reading this book you will be a Medior PHP Developer who can deliver a web application from start to finish!