Practical SQL Queries for Microsoft SQL Server 2008 R2

ISBN13：9780071746878
出版社：Mcgraw-Hill; Inc.
作者：TENNICK
出版日：2010/10/14
裝訂：平裝
版次：1
關鍵字： Practical SQL Queries for Microsoft SQL Server 2008 R2、 Practical、 SQL、 Queries、 for、 Microsoft、 Server、 2008、 R2、 Mcgraw-Hill, Inc.、 TENNICK、外文書、 Computer programming, programs, data、

杜威圖書分類

：

Computer programming, programs, data

定價

：NT$ 1700 元

優惠價

： 90 折 1530 元

無庫存，下單後進貨(到貨天數約45天)

下單可得紅利積點：45 點

商品簡介

作者簡介

商品簡介

Extract real, actionable business intelligence by utilizing the power of SQL queries

Featuring 300 ready-to-use SQL queries Practical SQL Queries for SQL Server 2008 shows how to write SQL queries within Microsoft’s BI stack, but well over 90% of the SQL queries will work with relational databases from other vendors. This solutions-based guide contains more than 300 SQL queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

Query: Introduction and description of query and its use

Syntax: Complete syntax

Result: Screen shot showing the data returned from the SQL Server relational database by the query

Analysis: Analysis of the results and tips for customizationSpecific emphasis is placed on writing SQL for use within Microsoft SQL Server Management Studio (SSMS) connecting to SQL Server – however, the techniques and queries can also be utilized across Reporting Services (SSRS), Integration Services (SSIS), Winforms and Webforms, and in a large variety of third-party front-ends.

Practical SQL Queries for SQL Server 2008

Includes 300+ ready-to-use, easily customizable SQL queries, all available for download

Features a practical, hands-on approach with a minimum of difficult concepts and theory

Explains how to visualize actionable BI

Helps to dramatically improve analysis and decision-making skills

Complete coverage of SQL queries
Select – single table; Where; Order By; Select – multiple tables; Aggregates; Select – new tables; Except/Intersect/Union; Group By; System functions; Subqueries; Delete/Insert/Update; Views/User-defined functions; Stored procedures/Programming; DDL (data definition language)/DCL

作者簡介

Art Tennick has worked in relational database design and SQL queries for more than 20 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Art is the author of Practical MDX Queries for Microsoft SQL Server Analysis Services 2008, Practical DMX Queries for Microsoft SQL Server Analysis Services 2008, and Practical PowerPivot & DAX Formulas for Excel 2010. His website is www.MrCube.net.

主題書展