Analytic SQL in SQL Server 2014/2016КНИГИ » ОС И БД
Название: Analytic SQL in SQL Server 2014/2016 Автор: Riadh Ghlala Издательство: Wiley-ISTE Год: 2019 Страниц: 164 Язык: английский Формат: pdf (true), djvu Размер: 10.1 MB
Nowadays, data analysis is a skill that is in high demand in order to develop indicators and metrics to monitor our information systems. In order to pursue this mission, several methods, techniques and tools have been developed to cover this need in various aspects.
Database Management Systems (DBMS), along with their querying language, Structured Query Language (SQL), are considered a very important path in data analysis. Based on analytic queries directly executed on the server side, a wide range of indicators can be developed without going through intermediate application layers.
This book, composed of four chapters, studies SQL as a tool for data management and analysis. Although the concepts of this language are standardized, this book presents them with the Microsoft SQL Server Database Management System (DBMS) and focuses primarily on the analytical aspect of this language.
Analytical processing, also known as OnLine Analytical Processing (OLAP), consists of interrogating the data in order to develop synthetic information that can be used as indicators for the decision-maker. Business Intelligence (BI) has emerged as a field which seeks to support managers in decision-making. It encompasses the techniques, methods and tools for conducting analytically-based IT solutions, which are referred to as OLAP (OnLine Analytical Processing). Within this field, SQL has a role as a leader and is continuously evolving to cover both transactional and analytical data management.
This book discusses the functions provided by Microsoft SQL Server 2014/2016 in terms of business intelligence. The analytic functions are considered as an enrichment of the SQL language. They combine a series of practical functions to answer complex analysis requests with all the simplicity, elegance and acquired performance of the SQL language.
Drawing on the wide experience of the author in teaching and research, as well as insights from contacts in the industry, this book focuses on the issues and difficulties faced by academics (students and teachers) and professionals engaged in data analysis with the SQL Server 2014/2016 database management system.
SQL Server Execution Plans, Third Edition Название: SQL Server Execution Plans, Third Edition Автор: Grant Fritchey Издательство: Red Gate Books ISBN: 1910035246 Год: 2018 Страниц: 515 ...
Microsoft SQL Server 2008 For Dummies Название: Microsoft SQL Server 2008 For Dummies Автор: Mike Chapple Издательство: For Dummies Год: 2008 Формат: PDF Страниц: 408 Для сайта:...
Beginning Microsoft SQL Server 2012 Programming Название: Beginning Microsoft SQL Server 2012 Programming Автор: Paul Atkinson, Robert Vieira Издательство: John Wiley & Sons Год: 2012 Формат:...
Practical Guide for Oracle SQL, T-SQL and MySQL Название: Practical Guide for Oracle SQL, T-SQL and MySQL Автор: Preston Zhang Издательство: CRC Press Год: 2017 ISBN: 9781138105188 Формат: pdf...
Exam Ref 70-761 Querying Data with Transact-SQL Название: Exam Ref 70-761 Querying Data with Transact-SQL Автор: Itzik Ben-Gan Издательство: Microsoft Press Год: 2017 Страниц: 352 Формат: True PDF...
Data Analysis Using SQL and Excel, 2nd Edition Название: Data Analysis Using SQL and Excel, 2nd Edition Автор: Gordon S. Linoff Издательство: Wiley Год: 2015 Страниц: 792 Формат: PDF, EPUB Размер:...
Securing SQL Server: DBAs Defending the Database Название: Securing SQL Server: DBAs Defending the Database Автор: Peter A. Carter Издательство: Apress Год: 2016 Страниц: 164 Формат: PDF Размер: 11...
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Навигация
Вход на сайт
Реклама
Analytic SQL in SQL Server 2014/2016 
