Analytic SQL in SQL server 2014/2016
Material type:
TextLanguage: English Publication details: New Jersey: Wiley Data and Cybersecurity, 2019. Description: ix, 139pISBN: 9781119649274Subject(s): Data Analysis Fundamentals with the SQL Language | Operators and Functions | Transactional and analytical data managementDDC classification: 005.7585 Online resources: Click here to access online
| Item type | Current library | Call number | Status | Date due | Barcode |
|---|---|---|---|---|---|
| e-Books | Dr. S. R. Ranganathan Library Ebook (Online Access) | 005.7585 (Online Access) (Browse shelf(Opens below)) | Available | EB0037 |
Browsing Dr. S. R. Ranganathan Library shelves, Shelving location: Ebook (Online Access) Close shelf browser (Hides shelf browser)
|
|
|
|
|
|
|
||
| 005.74 (Online Access) Advances in data science: symbolic, complex, and network data | 005.74 (Online Access) Blockchain for real world applications | 005.74023 From big data to smart data | 005.7585 (Online Access) Analytic SQL in SQL server 2014/2016 | 005.8 Cybersecurity and third-party risk: third party threat hunting | 005.8 Effective vulnerability management: managing risk in the vulnerable digital ecosystem | 005.8 Emerging threats and countermeasures in cybersecurity |
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.