Название: CompTIA DataSys+ Study Guide: Exam DS0-001
Автор: Мikе Сhaррlе, Shаrif Nijim
Издательство: Sybex
Год: 2024
Страниц: 459
Язык: английский
Формат: pdf, epub
Размер: 55.3 MB

Your all-in-one guide to preparing for the CompTIA DataSys+ exam. In CompTIA DataSys+ Study Guide: Exam DS0-001, a team of accomplished IT experts delivers a practical and hands-on roadmap to succeeding on the challenging DS0-001 exam and in a new or existing career as a data systems professional. In the book, you’ll explore the essentials of databases, their deployment, management, maintenance, security, and more. Whether you’re preparing for your first attempt at the CompTIA DataSys+ exam or for your first day on the job at a new database-related IT position, this book walks you through the foundational and intermediate skills you need to have to succeed. It covers every objective tested by the DS0-001 and skills commonly required in the real-world. Structured Query Language is the standard programming language for managing and manipulating data stored in relational databases. It is used by organizations of all sizes and in various industries to store, retrieve, and analyze data. SQL is essential for working with relational databases because it allows developers and database administrators to create data structures and manipulate data. Scripting is the process of automating a series of tasks. Relational databases support SQL, making it easy for developers, analysts, and administrators to use the same language to work with various relational databases, from PostgreSQL to Oracle.

Название: Postgres: The First Experience
Автор: Раvеl Luzаnоv, Еgоr Rоgоv, Igоr Lеvshin
Издательство: Postgres Professional
Год: 2023
Страниц: 175
Язык: английский
Формат: pdf (true)
Размер: 10.4 MB

This short pamphlet provides an overview of PostgreSQL DBMS, covering the history of its development, the main features, and a product roadmap. I you are just getting started, you can use this book as a step-by-step installation and configuration guide. PostgreSQL is the most feature-rich free open-source database system. Originally developed in the academic environment, it has managed to bring together a wide developer community through its long history. Nowadays, PostgreSQL offers everything that most customers need, and it is actively used all over the world to create high-load business-critical systems. PostgreSQL is one of the most popular databases. Based on the solid foundation of academic development, over several decades PostgreSQL has evolved into an enterprise-level product that is now a real alternative to commercial databases. You can see it for yourself by looking at the key features of PostgreSQL 15, which is the latest released version right now.

Название: Graph Database and Graph Computing for Power System Analysis
Автор: Rеnсhаng Dаi, Guаngуi Liu
Издательство: Wiley-IEEE Press
Год: 2024
Страниц: 514
Язык: английский
Формат: pdf (true), epub
Размер: 24.3 MB

Understand a new way to model power systems with this comprehensive and practical guide. Graph databases have become one of the essential tools for managing large data systems. Their structure improves over traditional table-based relational databases in that it reconciles more closely to the inherent physics of a power system, enabling it to model the components and the network of a power system in an organic way. The authors’ pioneering research has demonstrated the effectiveness and the potential of graph data management and graph computing to transform power system analysis. Graph Database and Graph Computing for Power System Analysis presents a comprehensive and accessible introduction to this research and its emerging applications. Programs and applications conventionally modeled for traditional relational databases are reconceived here to incorporate graph computing. The result is a detailed guide which demonstrates the utility and flexibility of this cutting-edge technology. Databases play an important role in scientific and non-scientific applications. In power system analysis, equipment such as generators, transmission lines, transformers, loads, shunt capacitors/reactors, circuit breakers, nodes, buses, and their properties are typically organized in structured tables in a database. In power system applications, relational databases are widely used to store and manage power system data and models.

Название: Maximum Availability Architecture (MAA) with Oracle GoldenGate MicroServices in HUB Architecture: Learn how to use Oracle GoldenGate to improve the availability, reliability, and scalability of your mission-critical systems
Автор: Luсiа Нustаtуоvа
Издательство: BPB Publications
Год: 2024
Страниц: 1273
Язык: английский
Формат: pdf, epub
Размер: 48.4 MB

A step-by-step guide for designing, implementing, and managing Oracle GoldenGate with HUB Architecture. Oracle GoldenGate is a software product that allows you to replicate data from one database to another. If you are interested in using Oracle GoldenGate Microservices (OGG MA) in HUB configuration for database upgrade, migration, and data replication, then this book is a valuable resource for you. This book provides step by step instructions, explanation about the whole architecture design for Oracle GoldenGate Microservices in HUB configuration including HA (High Availability) and DR (Disaster Recovery). This new technology is explained in the real project’s examples for the database upgrade/migration, data replication using OGG MA in HUB configuration, using REST API, command line solutions or web interface. Everything is explained from the beginning of the architecture design until full installation and administration. Book contains also real example of the code, how to handle different activities via REST API. Via Cloud Control will be installed OGG plugin to monitor all components. Architecture designed is proven at the end of the book, where is explained via example/execution that solution works as designed in the DR and HA situation.

Название: SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Автор: Angelo Bobak
Издательство: Apress
Год: 2023
Страниц: 1069
Язык: английский
Формат: pdf
Размер: 84.1 MB

This is a book on applying Microsoft SQL Server aggregate, analytical, and ranking functions across various industries for the purpose of statistical, reporting, analytical, and historical performance analysis using a series of built-in SQL Server functions affectionately known as the window functions! No, not window functions like the ones used in the C# or other Microsoft Windows application programming. They are called window functions because they implement windows into the data set generated by a query. These windows allow you to control where the functions are applied in the data by creating partitions in the query data set. “What’s a partition?” you might ask. This is a key concept you need to understand to get the most out of this book. Suppose you have a data set that has six rows for product category A and six rows for product category B. Each row has a column that stores sales values that you wish to analyze. The data set can be divided into two sections, one for each product category. These are the partitions that the window functions use. For intermediate to advanced SQL Server developers and data architects.

Название: Реляционные базы данных в примерах. Практическое пособие для программистов и тестировщиков
Автор: Kyликoв C.C.
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 1.0.24)
Страниц: 425
Язык: русский
Формат: pdf, djvu
Размер: 16.1 MB

Эта книга посвящена практическому взгляду на реляционную теорию и проектирование реляционных баз данных. Здесь не рассматриваются такие фундаментальные основы, как реляционная алгебра и реляционное счисление, но с множеством примеров и пояснений показаны основные понятия и подходы, необходимые для проектирования баз данных. Все схемы баз данных в этой книге приведены в нотации UML 2.1, созданы с использованием Sparx Enterprise Architect и (если речь идёт об уровнях проектирования, для которых это актуально) ориентированы на MySQL 8.0, Microsoft SQL Server 2019, Oracle 18c. Скорее всего, приведённые решения будут успешно работать на более новых версиях этих СУБД, но не на более старых.

Название: Работа с MySQL, MS SQL Server и Oracle в примерах. 2-е издание. Практическое пособие для программистов и тестировщиков
Автор: Kyликoв C.C.
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 2.0.28)
Страниц: 592
Язык: русский
Формат: pdf
Размер: 10.4 MB

Основное внимание в книге уделено практике использования SQL для решения типовых задач. В ней не рассматривается теория реляционных баз данных (предполагается, что вы с ней знакомы или сможете найти недостающую информацию), но представлено более 500 SQL-запросов: от базового выбора до использования представлений, триггеров, хранимых процедур и функций. Все примеры представлены в виде постановки и решения задач с использованием MySQL, MS SQL Server и Oracle, даны описания и анализ типичных ошибок. Все решения работают на MySQL Community Server 8.x, Microsoft SQL Server Express 2019 и Oracle 18c Express Edition и могут работать с более новыми версиями этих СУБД, но не будут работать со старыми версиями.

Название: Microsoft Azure Administrator Exam Prep (AZ-104): Practice Labs, Mock Exams, and Real Scenarios to Get You Certified on the Microsoft Azure Platform, 2nd Edition
Автор: Lalit Rawat
Издательство: BPB Publications
Год: 2023
Страниц: 376
Язык: английский
Формат: pdf (true)
Размер: 49.7 MB

In cloud computing, getting certified as an Azure Administrator is one of the most highly sought-after sets of abilities. Author Lalit Rawat brings the lab's experience to this updated and extended second edition to help you launch your test preparation with the practical practice of how a certified Azure administrator handles enterprise cloud architecture. This book will help you understand the fundamental and more advanced aspects of Azure administration. In-depth coverage is provided for various topics, including how to sync your existing on-premises active directory with the Azure directory and how to use the user management features of Azure Active Directory. The book also provides an exam-based scenario explanation for the Azure Virtual Machine, the Azure Storage Account, and the Azure Networking service. The book also includes topics such as Azure Monitor, Azure networking, on-premises to Azure connectivity, site-to-site connections, express route, and disaster and backup recovery solutions.

Название: SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management, 2nd Edition
Автор: Michael Kaufmann, Andreas Meier
Издательство: Springer
Год: 2023
Страниц: 263
Язык: английский
Формат: pdf (true), epub
Размер: 42.1 MB

This textbook offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques and examine upcoming innovations. In the first five chapters, the authors analyze in detail the management, modeling, languages, security, and architecture of relational databases, graph databases, and document databases. Moreover, an overview of other SQL- and NoSQL-based database approaches is provided. In addition to classic concepts such as the entity and relationship model and its mapping in SQL database schemas, query languages or transaction management, other aspects for NoSQL databases such as non-relational data models, document and graph query languages (MQL, Cypher), the Map/Reduce procedure, distribution options (sharding, replication) or the CAP theorem (Consistency, Availability, Partition Tolerance) are explained.

Название: Data Curious: Applying Agile Analytics for Better Business Decisions (Third Early Release)
Автор: Carl Allchin, Sarah Nooravi
Издательство: O’Reilly Media, Inc.
Год: 2023-06-22
Страниц: 158
Язык: английский
Формат: epub (true), mobi
Размер: 10.1 MB

Citizen data analysts are emerging to fill in the gaps left by traditional and slow business intelligence processes. Business functions such as finance, supply chain, and sales are now leading new data/analytics initiatives rather than partnering with centralized IT or analytics teams. But there is a knowledge gap—these new "citizen data analysts" understand their area of business, but unlike their IT counterparts, they do not have a background in data processing technology.