Название: Advanced Analytics with Excel 2019: Perform Data Analysis Using Excel’s Most Popular Features
Автор: Manisha Nigam
Издательство: BPB Publications
Год: 2020
Формат: ePUB, PDF
Страниц: 701
Размер: 50 Mb
Язык: English

Book explains and simplify the usage of Excel features and functionalities, with the help of examples. It starts with ‘Getting Started with Excel’ and ‘Performing functions with shortcut keys’ which will help you in getting started with Excel. Then ‘Formulas and Functions’ gives an initial understanding of what are operators, formulas, functions, their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, ‘SmartArt and Organization Chart’ give details on the different chart types available in Excel.

Название: RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBMS
Автор: Dr. Madhavi Vaidya
Издательство: BPB Publications
Год: 2021
Формат: ePUB, PDF
Страниц: 548
Размер: 10 Mb
Язык: English

Relational Database Management Systems In-Depth brings the fundamental concepts of database management systems to you in more elaborated learning with conceptual clarity of RDBMS.
This book brings an extensive coverage of theoretical concepts on types of databases, concepts of relational database management systems, normalization and many more. You will explore exemplification of Entity Relational Model concepts that would teach the readers to design accurate business systems. Backed with a series of examples, you can practice the fundamental concepts of RDBMS and SQL queries including Oracle’s SQL queries, MySQL and SQL Server.

Название: MCA Microsoft 365 Teams Administrator Study Guide: Exam MS-700
Автор: Ben Lee
Издательство: Sybex
Год: 2022
Страниц: 529
Язык: английский
Формат: pdf (true)
Размер: 28.41 MB

This Study Guide helps you understand the job role and responsibilities of a Microsoft 365 Teams Administrator. It's your one-stop resource for learning new skills, preparing to take the exam, and boosting your career! Cloud technology has become a major component of how services are delivered to customers. It's creating new roles and expanding others in all areas of technology. The Microsoft 365 Certified Associate Teams Administrator certification shows you're keeping pace with today's technology. MCA Microsoft 365 Certified Teams Administrator Study Guide is your best resource for understanding the job roles and responsibilities of a Teams Administrator and preparing to take the certification Exam MS-700.

Название: Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease
Автор: Ashwin Pajankar
Издательство: BPB Publications
Год: 2020
Формат: ePUB, PDF
Страниц: 279
Размер: 10 Mb
Язык: English

This book starts with the concepts in RDBMS (Relational Database Management Systems) and SQL (Structured Query Language). The first few chapters cover the definitions and a brief explanation of all the important concepts. They also cover the installation of MariaDB and MySQL on Windows and Raspberry Pi, as well as the setup of various tools used to connect to MySQL and MariaDB server processes. We will also understand how to install sample schemas and how to use basic SQL queries. Then we move on to the SELECT query in detail. The book explores the data retrieval aspect of SQL queries in detail with the WHERE clause and NULL handling in detail. The book also explores the functions available in MySQL. Those are single row and group functions. Then we explore how to combine the data from multiple sources. The technique is known as Joins, and we will learn ANSI style and the old-style syntax for all the types of Joins.

Название: Efficient MySQL Performance (Early Release)
Автор: Daniel Nichter
Издательство: O’Reilly Media, Inc.
Год: 2021-09-15: Fourth Release
Формат: ePUB
Страниц: 362
Размер: 10 Mb
Язык: English

You'll find several books on MySQL basics today, but only one that covers advanced MySQL performance--and nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching developers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by DBAs.

Название: Windows Internals, Part 1-2, 7th Edition
Автор: Andrea Allievi, Alex Ionescu, Mark E. Russinovich, David A. Solomon
Издательство: Microsoft Press, Pearson
Год: 2017-2022
Формат: True PDF, ePUB
Страниц: 800+1777
Размер: 58,2 Mb, 64,3 Mb
Язык: English

The definitive guide to modern Windows internals: new coverage of virtualization, file systems, boot, security, and more.
For advanced computing professionals, this is the definitive up-to-date guide to how Windows core components behave “under the hood.” Using it, experienced developers can build more powerful and scalable software, administrators can debug complex system and performance problems, and security researchers can harden their systems. This Seventh Edition is fully updated through the May 2021 (21H1/2104) updates to Windows 10 and Windows Server (2022, 2019, and 2016). It adds extensive content on Hyper-V, plus fully rewritten chapters on the boot process, new storage technologies, and Windows system and management mechanisms.

Название: Tensor Computation for Data Analysis
Автор: Yipeng Liu, Jiani Liu, Zhen Long, Ce Zhu
Издательство: Springer
Год: 2021
Формат: True PDF
Страниц: 347
Размер: 10 Mb
Язык: English

Tensor is a natural representation for multi-dimensional data, and tensor computation can avoid possible multi-linear data structure loss in classical matrix computation-based data analysis.
This book is intended to provide non-specialists an overall understanding of tensor computation and its applications in data analysis, and benefits researchers, engineers, and students with theoretical, computational, technical and experimental details. It presents a systematic and up-to-date overview of tensor decompositions from the engineer's point of view, and comprehensive coverage of tensor computation based data analysis techniques. In addition, some practical examples in machine learning, signal processing, data mining, computer vision, remote sensing, and biomedical engineering are also presented for easy understanding and implementation.

Название: Segmentation Analytics with SAS Viya: An Approach to Clustering and Visualization
Автор: Randall S. Collica
Издательство: SAS Institute Inc.
Год: 2021
Страниц: 136
Язык: английский
Формат: pdf (true), epub
Размер: 18.8 MB, 20.9 MB

Better understand your customers using segmentation analytics in SAS Viya! Segmentation Analytics with SAS Viya: An Approach to Clustering and Visualization demonstrates the use of clustering and machine learning methods for the purpose of segmenting customer or client data into useful categories for marketing, market research, next best offers by segment, and more. This book highlights the latest and greatest methods available that show the power of SAS Viya while solving typical industry issues. Packed with real-world examples, this book provides readers with practical methods of using SAS Visual Data Mining and Machine Learning (VDMML), SAS Model Studio, SAS Visual Statistics, SAS Visual Analytics, and coding in SAS Studio for segmentation model development and analysis. This book is designed for analysts, data miners, and data scientists who need to use the all in-memoryplatform of SAS Viya for the purposes of clustering and segmentation. Understanding how customers behave is a primary objective of most organizations, and segmentation is a key analytic method for achieving that objective.

Название: Data Management at Scale: Best Practices for Enterprise Architecture
Автор: Piethein Strengholt
Издательство: O’Reilly
Год: 2020
Формат: True PDF, ePUB
Страниц: 348
Размер: 15,5 Mb, 10 Mb
Язык: English

As data management and integration continue to evolve rapidly, storing all your data in one place such as a data warehouse is no longer scalable. In the very near future, data will need to be distributed and available for several technological solutions. With this practical book, you’ll learn how to migrate your enterprise from a complex and tightly coupled data landscape to a more flexible architecture ready for the modern world of data consumption.

Название: Изучаем SQL. Генерация, выборка и обработка данных, 3-изд
Автор: Болье Алан
Издательство: Диалектика
Год: 2021
Формат: PDF
Страниц: 404
Размер: 36 Mb
Язык: Русский

Нынешний век можно без преувеличения назвать веком информации, но информация без возможности ее выборки и обработки - это не более чем просто набор байтов в хранилищах данных. Такую возможность эффективной выборки и обработки данных уже несколько десятилетий предоставляет разработчикам язык SQL. Он тесно связан с реляционными базами данных. Но несмотря на это в последнее время, когда все большее значение приобретают большие объемы данных, упомянутый язык развивается таким образом, чтобы облегчить поиск данных в базах данных, построенных на различных технологиях. Данная книга отличается широким охватом как тем (от азов SQL до таких сложных вопросов, как аналитические функции и работа с большими базами данных), так и конкретных баз данных (MySQL, Oracle Database, SQL Server) и особенностей реализации тех или иных функциональных возможностей SQL на этих серверах.