PostgreSQL. Профессиональный SQL

Автор: Natali26 от 1-09-2025, 12:17, Коментариев: 0

Категория: КНИГИ » ОС И БД

PostgreSQL. Профессиональный SQLНазвание: PostgreSQL. Профессиональный SQL
Автор: Моргунов Е. П.
Издательство: ДМК-пресс
Год: 2025
Формат: pdf, djvu
Страниц: 445
Размер: 10,07 М
Язык: русский

Вы научитесь: понимать план выполнения и писать эффективные запросы; применять встроенные оконные и статис-тические функции; расширять функциональность сервера собственными функциями и про-Цедурами; работать с иерархическими структурами и графами с помощью рекурсив-ных табличных выражений. Материал построен на версии PostgreSQL 17, актуальной на момент издания.

 

Learning Power Query: Simplify data cleaning and analysis with Excel's most powerful tool

Автор: literator от 30-08-2025, 18:38, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Learning Power Query: Simplify data cleaning and analysis with Excel's most powerful tool
Автор: Adam Szczepan Kopeć
Издательство: BPB Publications
Год: 2025
Страниц: 581
Язык: английский
Формат: epub (true)
Размер: 24.88 MB

In a time where data drives decision-making, Excel continues to be a vital resource for professionals. Power Query greatly enhances its functionality. As businesses increasingly seek automation and scalable solutions, proficiency in Power Query and the M language is a crucial advantage for data practitioners. This book fulfills that demand by combining technical accuracy with practical examples. Beginning with basic transformations and progressing to advanced query logic, parameterization, and custom M solutions, each chapter fosters technical expertise. Readers will discover how to import data from diverse sources, enhance performance, troubleshoot queries, and tackle intricate business problems using clean and efficient M code. This book is for developers, architects, and solution consultants who are now exploring cloud-native architecture principles for design and development with Agile and DevOps to modernize existing applications or create brand-new cloud-native products.
 

SQL Crash Course: Learn essential skills in querying, security, and database management

Автор: literator от 30-08-2025, 16:42, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: SQL Crash Course: Learn essential skills in querying, security, and database management
Автор: Thomas Liddle
Издательство: BPB Publications
Год: 2025
Страниц: 451
Язык: английский
Формат: pdf, epub (true)
Размер: 10.66 MB

SQL is the foundational language for interacting with relational databases and is the backbone of data management. Whether you are new to databases or looking to sharpen your data skills, this book provides the essential knowledge to retrieve, modify, and manage data effectively using SQL. This book begins with database theory, explaining relational databases and core SQL syntax. It then progresses to data retrieval and manipulation operations, including advanced techniques, such as joins, subqueries, and set operators. You will learn to manage database objects with indexes, views, and triggers, explore advanced SQL techniques like window functions and common table expressions (CTEs), and learn how to optimize queries for peak performance. The book culminates in practical projects that apply everything you have learned to real-world scenarios, preparing you for immediate, hands-on application. This book is ideal for aspiring data analysts, developers, and database administrators who are new to SQL. Readers should have a basic understanding of computer operations, but no programming background is required to get started.
 

Payment and Bank Communication Management with SAP

Автор: literator от 28-08-2025, 20:37, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Payment and Bank Communication Management with SAP
Автор: Adrian Matys, Jean-Michele Szczecina
Издательство: Rheinwerk Publishing
Год: 2025
Страниц: 1537
Язык: английский
Формат: epub (true)
Размер: 23.6 MB

Organized, precise payment processing and bank communication is key when it comes to financial transactions! Learn how SAP S/4HANA enables you to send and receive payment data from your bank using SAP Bank Communication Management, in-house banking, advanced payment management, and other solutions and tools. Walk through implementing connectivity standards like SWIFT and EBICs, configuring master data, and mapping format data. With information adopting ISO 20022, designing a “payment factory,” and automating bank statement processing, this guide is the only one you need! Get step-by-step instructions for implementing SAP’s payments and bank communication solutions. Configure batching rules and two-person verification, set up inbound and outbound processing, and maintain key settings. Learn how to process different types of payments, from payments “in the name of” to intercompany payments. Walk through SAP S/4HANA’s solutions like advanced payment management, in-house banking, and cash management.
 

Linux Made Simple - 10th Edition , 2025

Автор: literator от 28-08-2025, 06:37, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Linux Made Simple - 10th Edition , 2025
Автор: Katharine Marsh (Editor)
Издательство: Future Publishing
Год: 2025
Страниц: 148
Язык: английский
Формат: pdf
Размер: 84.1 MB

With the internet driving a new world of information exchange, business start-ups and online gaming, coders have suddenly become the gatekeepers to these new realms. Combine the huge interest in learning how to create and control these worlds with the surge of cool devices, such as the Raspberry Pi, and you've got a head of technological steam the world hasn't seen since the coding craze of the early 1980s. So no matter if you're looking to relive those heady '80s coding days or are a newbie looking to take your first steps into the coding world, you hold in your hands the ideal guide to start coding. Thanks to a new generation of open free software, we all can access operating systems, development tools, compilers and the programming languages needed to create professional programs, apps and tools. We'll show you how to get up and running with a Linux system, then access everything you need freely online. Coding is easy, exciting and fun.
 

Linux Unlocked: From Novice to Expert

Автор: literator от 27-08-2025, 16:19, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Linux Unlocked: From Novice to Expert
Автор: S. Rathore
Издательство: Independently published
Год: December 15, 2024
Страниц: 242
Язык: английский
Формат: pdf
Размер: 50.3 MB

Unlock the power of Linux with this comprehensive guide designed to take you from a complete novice to an expert user. Whether you're new to Linux or looking to deepen your understanding, Linux Unlocked: From Novice to Expert offers step-by-step instructions, practical tips, and clear explanations to help you master one of the most powerful and flexible operating systems in the world. Designed for readers of all levels, Linux Unlocked breaks down complex topics into easy-to-understand lessons, allowing you to build your skills at your own pace. Whether you’re aiming to switch to Linux, enhance your career, or simply explore a new and exciting world of computing, this book is your ultimate guide to unlocking the full potential of Linux.
 

Data Product Management in the AI Age: Design and Manage Your Data Strategy to Get Ahead

Автор: literator от 27-08-2025, 05:18, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Data Product Management in the AI Age: Design and Manage Your Data Strategy to Get Ahead
Автор: Jessika Milhomem
Издательство: Apress
Год: 2025
Страниц: 374
Язык: английский
Формат: pdf
Размер: 14.6 MB

A practical guide to mastering data product management—bridging strategy, architecture, and execution for the AI era. We have firmly entered the age of Artificial Intelligence (AI). Data, the backbone of this technology, is more crucial than ever. If the algorithm is the brain, data is the content that feeds it. This book argues that to succeed in this era, organizations should adopt a holistic approach to data—one that uses product management principles to inform how data is sourced, designed, managed, maintained, optimized, and leveraged. This book is divided into two sections, moving from fundamentals to practical applications. For data leaders and managers responsible for designing and delivering data products, as well as product managers who want to collaborate more effectively with data teams. Analytics engineers, data engineers, data scientists, and Machine Learning engineers will find practical guidance for building impactful data solutions. Developers and data professionals aiming to move into leadership or product roles will also find valuable insights throughout.
 

Complete A+ Guide to IT Hardware and Software: CompTIA A+ Core 1 and Core 2 Exams (V15), 10th Edition

Автор: literator от 26-08-2025, 17:55, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Complete A+ Guide to IT Hardware and Software: CompTIA A+ Core 1 and Core 2 Exams (V15), 10th Edition
Автор: Cheryl A. Schmidt, Christopher A. Lee
Издательство: Pearson Education
Год: 2026
Страниц: 1176
Язык: английский
Формат: epub
Размер: 100.2 MB

Master IT Hardware, Software, and Troubleshootingand Fully Prepare for the Latest CompTIA Core 1 and Core 2 Exams (V15). The Complete A+ Guide to IT Hardware and Software is your all-in-one, real-world, full-color resource for building the skills you need to become a confident, job-ready IT technician--and for passing the updated CompTIA A+ Core 1 and Core 2 Exams (V15). Built around the latest A+ exam objectives, this comprehensive guide helps you connect, configure, manage, and troubleshoot todays most widely used devices, operating systems, and cloud-based technologies--all in the context of real IT scenarios. Youll gain hands-on expertise with Windows 11, macOS, Linux, Chrome OS, Android, iOS, mobile and IoT devices, Active Directory, cybersecurity, scripting, and more. Perfect for students, instructors, and career changers alike, this guide will prepare you for both certification success and on-the-job performance in todays fast-moving IT environments.
 

AWS Certified Data Engineer Associate Study Guide

Автор: literator от 25-08-2025, 22:00, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: AWS Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Автор: Sakti Mishra, Dylan Qu, Anusha Challa
Издательство: O’Reilly Media, Inc.
Год: 2025
Страниц: 565
Язык: английский
Формат: epub
Размер: 16.4 MB

There's no better time to become a data engineer. And acing the AWS Certified Data Engineer Associate (DEA-C01) exam will help you tackle the demands of modern data engineering and secure your place in the technology-driven future. Authors Sakti Mishra, Dylan Qu, and Anusha Challa equip you with the knowledge and sought-after skills necessary to effectively manage data and excel in your career. Whether you're a data engineer, data analyst, or machine learning engineer, you'll discover in-depth guidance, practical exercises, sample questions, and expert advice needed to leverage AWS services effectively and achieve certification. Our primary audience is any technical practitioner who wants to prepare for the DEA-C01 certification.
 

Делопроизводство и секретарская работа на персональном компьютере

Автор: umkaS от 25-08-2025, 10:51, Коментариев: 0

Категория: КНИГИ » ОС И БД

Название: Делопроизводство и секретарская работа на персональном компьютере
Автор: Попов С.Л.
Издательство: СОЛОН-Пресс
Год: 2017
Cтраниц: 423
Формат: pdf
Размер: 102 мб
Язык: русский

В книге С.Л. Попова, ученого и технического писателя, содержатся сведения о системах документации, организации делопроизводственного процесса и технике делопроизводственных операций, в том числе с использованием персонального компьютера. Представлен материал по разработке электронных документов на основании шаблонов, ведению баз данных документов и дел, использованию сети Интернет и электронной почты в делопроизводстве. С этой целью рассмотрены необходимые вопросы работы в среде операционных систем Windows и использования прикладных программ Word, Excel, Outlook Express, Internet Explorer компании Microsoft.