Название: Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Автор: Kathi Kellenberger, Clayton Groom, Ed Pollack
Издательство: Apress
Год: 2019
Страниц: 221
Язык: английский
Формат: pdf (true), epub
Размер: 20.8 MB

Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019.

Название: Использование макросов в Excel
Автор: Стивен Роман
Жанр: Учебное пособие
Издательство: Питер
Год: 2004
Страниц: 512
Язык: Русский
Формат: pdf
Размер: 11,76 Mb

Несмотря на мощные функциональные возможности, обеспечиваемые пользовательским интерфейсом Excel, существует ряд задач, выполнение которых возможно только программным путем. Книга «Использование макросов в Excel» представляет собой введение в программирование на Excel VBA, содержащее примеры решения различных практических задач, возникающих при работе в Excel.

Название: AIX 7.2, PowerVM - UNIX, Virtualization, and Security. An administrator’s guide
Автор: Sebastian Biedron
Издательство: Amazon Digital Services LLC
Год: 2018
Страниц: 452
Язык: английский
Формат: epub, pdf
Размер: 14.8 MB

Get to know the AIX operating system! Operating systems from the UNIX family are known for their high reliability and performance. This is why many companies use such systems to manage key application servers. One of the systems that belongs to this family is AIX, which has gained popularity in recent years due to its significant potential for virtualization as well as the fact that its security configuration meets the strictest security requirements. From this book, you will learn how the AIX operating system works and how to work with it as an administrator. You will learn the best practices. Further, you will learn about the way PowerVM, one of the most flexible and most reliable virtualization solutions, works. You will also learn numerous ways to ensure the security of both the operating system and the applications operating under its control.

Название: Pro SQL Server 2019 Administration: A Guide for the Modern DBA Second Edition
Автор: Peter A. Carter
Издательство: Apress
Год: 2019
Формат: true pdf/epub
Страниц: 940
Размер: 53 Mb
Язык: English

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL.

Название: Excel. Единый справочник
Автор: Шитов В.Н.
Издательство: М.: Гроссмедиа
Год: 2005
Формат: pdf
Страниц: 512
Размер: 15 mb
Язык: русский

В книге описаны основные методы работы с популярным продуктом Microsoft Excel, предназначенным для работы с электронными таблицами. В издании приводится огромное количество примеров и иллюстраций по работе с электронными таблицами. Читатель найдет много советов и приемов, которые потом может применить в самостоятельной работе. Книга рассчитана на пользователей с различным уровнем подготовки.

Название: Operating Systems for Supercomputers and High Performance Computing (High-Performance Computing Series)
Автор: Balazs Gerofi (Editor), Yutaka Ishikawa (Editor), Rolf Riesen (Editor), Robert W. Wisniewski (Editor)
Издательство: Springer
Год: 2019
Формат: true pdf/epub
Страниц: 400
Размер: 25.8 Mb
Язык: English

Few works are as timely and critical to the advancement of high performance computing than is this new up-to-date treatise on leading-edge directions of operating systems. It is a first-hand product of many of the leaders in this rapidly evolving field and possibly the most comprehensive.

Название: T-SQL Window Functions: For data analysis and beyond (2nd Edition)
Автор: Itzik Ben-Gan
Издательство: Microsoft Press
Год: 2019
Страниц: 352
Язык: английский
Формат: epub
Размер: 44.2 MB

Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions.

Название: Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python, Second Edition (Early Release)
Автор: Peter Bruce, Andrew Bruce, and Peter Gedeck
Издательство: O’Reilly Media,
Год: 2019
Формат: epub/azw3/pdf(conv.)
Размер: 10.8 Mb
Язык: English

Statistical methods are a key part of data science, yet few data scientists have formal statistical training. Courses and books on basic statistics rarely cover the topic from a data science perspective. The second edition of this practical guide—now including examples in Python as well as R—explains how to apply various statistical methods to data science, tells you how to avoid their misuse, and gives you advice on what’s important and what’s not.

Название: ICT Innovations 2019. Big Data Processing and Mining: 11th International Conference, ICT Innovations 2019
Автор: Sonja Gievska and Gjorgji Madjarov
Издательство: Springer
Год: 2019
Формат: PDF
Размер: 20 Мб
Язык: английский / English

This book constitutes the refereed proceedings of the 11th International ICT Innovations Conference, ICT Innovations 2019, held in Ohrid, Macedonia, in October 2019. The 18 full papers presented were carefully reviewed and selected from 75 submissions. They cover the following topics: sensor applications and deployments, embedded and cyber-physical systems, robotics, network architectures, cloud computing, software infrastructure, software creation and management, models of computation, computational complexity and cryptography, design and analysis of algorithms, mathematical optimization, probability and statistics, data management systems, data mining, human computer interaction (HCI), artificial intelligence, machine learning, life and medical sciences, health care information systems, bioinformatics.

Название: Big Data Analytics: Systems, Algorithms, Applications
Автор: C.S.R. Prabhu, Aneesh Sreevallabh Chivukula
Издательство: Springer
Год: 2019
Формат: PDF
Размер: 12 Мб
Язык: английский / English

This book provides a comprehensive survey of techniques, technologies and applications of Big Data and its analysis. The Big Data phenomenon is increasingly impacting all sectors of business and industry, producing an emerging new information ecosystem. On the applications front, the book offers detailed descriptions of various application areas for Big Data Analytics in the important domains of Social Semantic Web Mining, Banking and Financial Services, Capital Markets, Insurance, Advertisement, Recommendation Systems, Bio-Informatics, the IoT and Fog Computing, before delving into issues of security and privacy.