Analytic SQL in SQL Server 2014/2016 (Hardcover)

Riadh Ghlala

ISBN 10: 1786304120 / ISBN 13: 9781786304124

Published by ISTE Ltd and John Wiley & Sons Inc, London, 2019

About this Item

Hardcover. 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. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Seller Inventory # 9781786304124

Bibliographic Details

• Title: Analytic SQL in SQL Server 2014/2016 (Hardcover)
• Publisher: ISTE Ltd and John Wiley & Sons Inc, London
• Publication Date: 2019
• Language: English
• ISBN 10: 1786304120
• ISBN 13: 9781786304124
• Binding: Hardcover
• Condition: new

About this title

Synopsis

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.

About the Author

Riadh Ghlala is Associate Professor in Computer Science at the Higher Institute of Technological Studies of Radès (Tunisia) and Microsoft Certified Solution Expert (MCSE) in Data Management and Analytics. He has taught various computer courses, notably in data management, at several academic institutions.