Название: SQL: The Practical Guide to Master Relational Databases, SQL Syntax, and Sublanguages for Effective Database Management
Автор: Kerem Koseoglu
Издательство: Rheinwerk Publishing
Год: 2025
Страниц: 492
Язык: английский
Формат: True PDF, True EPUB
Размер: 10.5 MB, 10.8 MB

Whether you’re managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-world applications! Understand the fundamentals of relational databases and schemas. Learn the elements of database structures, from tables to views to keys. Then review more advanced concepts like normalization, stored procedures, triggers, and authorization. Structured Query Language (SQL) is a programming language that’s used to manage, manipulate, and query contents of relational database systems. Use the sublanguages of SQL for your daily tasks. Start by creating and altering database objects. Insert, update, and delete data in tables and then modify multiple tables together. Query data from single or combined tables and limit data access using authorizations.

Название: Vector Databases: A Practical Introduction
Автор: Nitin Borwankar
Издательство: O’Reilly Media, Inc.
Год: 2026
Страниц: 293
Язык: английский
Формат: True PDF, True EPUB
Размер: 14.5 MB

The AI revolution is here, and at its core lies a game-changing technology that most developers haven't fully explored: vector databases. From powering semantic search to enabling Large Language Models (LLMs) and Generative AI, vector databases are reshaping how we build applications with unstructured data like text, images, and audio. But how do you go from curious to capable with this vital technology? That's where this book comes in. In this hands-on guide, author Nitin Borwankar takes you through the "why, what, and how" of vector databases, starting with the basic theory behind vector embeddings and progressing to building applications with real-world tools. You'll learn about Word2vec, how to convert open source SQL databases like SQLite3 and PostgreSQL into vector databases, and integrate them into retrieval-augmented generation (RAG) applications. Whether you're a Python developer, data engineer, or ML practitioner, this book gives you the foundation to leverage vector databases confidently in your AI projects. Prerequisites include Python programming proficiency, a basic understanding of databases and SQL, and familiarity with running LLMs locally for the RAG chapters.

Название: Windows Server 2025 on Azure: Deploy, secure, and optimize modern enterprise workloads using cloud-native features and hotpatching
Автор: Padmaja U.K.
Издательство: BPB Publications
Год: 2026
Страниц: 368
Язык: английский
Формат: pdf, epub (true)
Размер: 14.6 MB

Windows Server 2025 is Microsoft’s latest enterprise operating system for running and managing core business applications, networks, and IT infrastructure. As organizations increasingly adopt modern, cloud-ready workloads, combining Windows Server 2025 with Azure delivers the scalability, flexibility, and security needed to run hybrid and cloud environments efficiently. This book shows how to get the most from Windows Server 2025 on Microsoft Azure, guiding you through deploying and managing cloud-ready workloads securely and efficiently. It covers hybrid infrastructure and cloud-native features like Azure Arc and hotpatching. You will learn strategies for storage, backup, disaster recovery, high availability, auto-scaling, and cost optimization, enabling Windows Server workloads to be resilient, scalable, and optimized in the cloud. By the end of this book, you will be competent in deploying, managing, and optimizing Windows Server 2025 on Azure. You will have gained practical skills in maintaining a secure, automated, and cost-efficient cloud infrastructure, helping you to confidently manage modern, hybrid, and cloud-ready IT environments. This book is for IT professionals, system administrators, cloud architects, and DevOps engineers looking to master Windows Server 2025 on Azure.

Название: Linux Performance: A comprehensive guide to using performance insights to improve capacity planning, scalability, and production stability
Автор: Ayan Kumar Nath
Издательство: BPB Publications
Год: 2026
Страниц: 424
Язык: английский
Формат: epub (true)
Размер: 18.6 MB

As systems grow in complexity and scale, performance engineering has become a specialized discipline rather than an afterthought. Linux remains the execution environment for most performance-critical workloads, making a deep understanding of its internals, metrics, and behavior essential for performance specialists. This book delivers a systematic approach to Linux performance engineering, combining theory with practical analysis. It covers core performance metrics, kernel evolution, and formal methodologies for measurement and diagnosis. It explores advanced use of Linux performance tools, workload analysis techniques, queueing models, and bottleneck theory, along with real-world considerations for tuning and optimization across CPU, memory, storage, and networking subsystems. After completing this book, performance specialists will be able to conduct rigorous performance investigations, explain system behavior with clarity, and apply targeted optimizations backed by data. This book is for SREs, DevOps, and systems engineers with basic Linux command-line knowledge. It serves performance engineers, researchers, and students ready to master kernel internals, hardware subsystems, and eBPF tracing tools to optimize production-scale, real-world Linux infrastructures.

Название: Microsoft Fabric Data Engineer (DP-700) Study Guide: The Definitive Blueprint for Unified Data Solutions and Exam Success (Early Release)
Автор: Michael John Peña
Издательство: O’Reilly Media, Inc.
Год: 2026-04-07
Страниц: 227
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

Microsoft Fabric is becoming essential for enterprise data professionals. Whether you're preparing for the DP-700 exam or looking to deepen your real-world skills, this study guide is your trusted companion. Author Michael John Pena, a leading Fabric trainer and early DP-700 achiever, delivers exam-aligned coverage packed with practical insights. Each chapter translates complex concepts into clear, applicable guidance for building modern analytics solutions with Fabric's unified architecture. The Chapter 1 takes you deep into the configuration options that transform a generic Fabric workspace into a finely tuned data engineering environment. You will learn how to configure Spark compute for specific workloads, manage library dependencies through environments, organize data across domains for governance, optimize OneLake storage, and orchestrate data workflows with pipelines and triggers. By the end, you will be able to configure workspace settings including Spark, SQL, and OneLake configurations, manage workspace identity and trusted workspace access, implement domain assignments for organizational governance, and apply appropriate compute settings for workload optimization.

Название: Google Cloud Certified Professional Cloud Database Engineer Study Guide
Автор: Jake Holmquist
Издательство: Sybex
Год: 2026
Страниц: 387
Язык: английский
Формат: pdf (true), epub
Размер: 10.1 MB

Discover a smarter and faster way to prep for the Google Professional Cloud Database Engineer certification exam. In the Google Cloud Certified Professional Cloud Database Engineer Study Guide, recognized Cloud and AI leader Jake Holmquist walks you through the recently released Google Professional Cloud Database Engineer certification exam. This Sybex Study Guide provides 100% coverage of every tested domain competency, from capacity and usage planning to cloud database migrations, applications, access management, backup and recovery, monitoring, and more―everything you need to design and build scalable and highly available cloud database solutions. Whether you are looking to grow your career or position yourself for real-world success at your first job as a Google Cloud database practitioner, the author explains how to succeed on the challenging exam on your first attempt. This exam certifies that you have the necessary skills to select the right database for the job—whether it’s a relational database like Cloud SQL or Spanner, a NoSQL solution like Bigtable or Firestore, or an in-memory store like Memorystore. It proves you can not only deploy these systems but also handle migrations, manage day-to-day operations, and implement robust security and disaster recovery plans. Achieving this certification demonstrates to employers that you are a top-tier professional capable of handling their most critical data assets.

Название: SAP List Viewer Object Model for ABAP Developers: Building Dynamic, Interactive, and User-Friendly ALV Reports
Автор: William Lawlor
Издательство: Apress
Год: 2026
Страниц: 206
Язык: английский
Формат: pdf (true), epub
Размер: 11.1 MB

This book is the ultimate resource for building interactive, professional-grade ALV reports using ABAP’s powerful SALV framework. Starting with the evolution of ALV and your first grid implementation, the book walks you through the essentials of the CL_SALV_TABLE object. From mastering column properties and controlling standard toolbar functions to applying sorting, filtering, and custom display settings, you'll gain the tools to tailor the user experience to fit any business requirement. Step-by-step examples and clear guidance help you build polished, functional reports quickly and efficiently. As the book progresses, you'll explore more advanced techniques, including user interaction through event handling, custom toolbar functions, aggregation logic, and dynamic selections. You’ll dive into layout variants, cell-level customization, ALV in Dynpro, form-based outputs, and print-ready formats. Special focus is given to ALV with Integrated Data Access (IDA) for handling large data volumes, as well as hierarchical and tree structures using CL_SALV_HIERSEQ_TABLE and CL_SALV_TREE. This book is for ABAP Developers and SAP Technical Consultants.

Название: Excel at 40: The 40 Best Features in Microsoft Excel As of September 2025
Автор: Bill Jelen
Издательство: Holy Macro! Books
Год: September 30, 2025 (the 40th anniversary of Excel)
Страниц: 207
Язык: английский
Формат: epub
Размер: 34.4 MB

Celebrate 40 years of Excel innovation by exploring its best features—from AutoSum and Pivot Tables to Copilot and Python—learning how each advancement reshaped data work, analysis, and automation for modern professionals. This book highlights 40 defining features that have made Excel indispensable since its creation. It opens with early innovations like AutoSum, Freeze Panes, and Pivot Tables before progressing to advanced tools such as Power Query, Dynamic Arrays, and the Copilot AI revolution. Each chapter presents history, context, and application, helping readers appreciate both legacy and cutting-edge updates. Through storytelling and expert insights, the book connects Excel’s past and present, offering a complete perspective on how the tool empowers business intelligence and everyday efficiency. Practical guidance throughout helps readers understand not only how to use each feature but why it matters in the evolution of data work. This book is designed for Excel professionals, data analysts, and business users eager to deepen their understanding of Excel’s core and emerging capabilities. Basic familiarity with Excel formulas and data manipulation is expected. Those curious about AI-assisted features and the integration of Python and Copilot will find it especially relevant.

Название: Microsoft Power Platform: Architecting enterprise solutions through professional delivery methodologies and secure environment governance
Автор: Goloknath Mishra
Издательство: BPB Publications
Год: 2026
Страниц: 348
Язык: английский
Формат: pdf, epub (true)
Размер: 15.4 MB

The guiding principles for an architect is the comprehensive roadmap to understanding the platform’s core components and why they matter for today’s businesses. Microsoft Power Platform is transforming how enterprises build solutions in today’s fast-paced digital era. By enabling low-code innovation and empowering citizen developers, it helps organizations accelerate transformation while staying agile and competitive. This book is the leading engine for modern enterprise digital transformation, and mastering its architecture is essential for building scalable, low-code solutions. This book is a guiding principle for an architect as it serves as your comprehensive roadmap to understanding the platform’s core components and why they are vital for today’s business landscape. It provides architects with guiding principles across multiple chapters. Each chapter offers practical insights, frameworks, and strategies to balance innovation with compliance and scalability. This book is written for IT architects, solution designers, consultants, and technology leaders who work with Microsoft Power Platform.

Название: Build Your First Home Server, 2nd Edition
Автор: R.R. Arnob
Издательство: PublishDrive
Год: 2026
Страниц: 149
Язык: английский
Формат: epub (true)
Размер: 18.1 MB

Learn Proxmox, Docker Compose, Jellyfin, Sonarr, Radarr, Immich, Adguard, WireGuard & More. The Second Edition of Build Your First Home Server is fully updated to reflect today's modern self-hosting ecosystem, improved security practices, and real-world automation workflows. Tired of expensive streaming subscriptions, privacy concerns, and limited control? This book shows you how to design, deploy, and manage your own powerful home server using open-source tools and best practices—without relying on third-party services. This edition replaces GUI-dependent workflows with Docker Compose–based deployments, giving you reproducible, version-controlled, and portable setups. Content has been refined with updated Proxmox virtualization techniques, cleaner container orchestration, and improved *Arr automation for media management. Self-hosting involves running software or services on your own hardware, giving you full control instead of relying on third-party providers. You can set up a self-hosted server on various devices, including something as compact and affordable as a Raspberry Pi. Instead of using platforms like Netflix/HBO, Spotify, Google Photo, or Google Drive, self-hosting allows you to deploy and manage alternatives like Jellyfin, Navidrome, Immich, and Nextcloud and directly on your device.