9780071746878

Practical SQL Queries for Microsoft SQL Server 2008 R2

  • ISBN 13:

    9780071746878

  • ISBN 10:

    0071746870

  • Edition: 1st
  • Format: Paperback
  • Copyright: 11/04/2010
  • Publisher: McGraw-Hill Education

Note: Not guaranteed to come with supplemental materials (access cards, study guides, lab manuals, CDs, etc.)

Extend Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Rental Options

List Price $52.00 Save

Free Shipping Free Shipping On Every Order
Usually Ships in 2-3 Business Days

Summary

Extract real, actionable business intelligence by utilizing the power of SQL queriesFeaturing 300 ready-to-use SQL queriesPractical SQL Queries for SQL Server 2008shows 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 customization Specific 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 skillsComplete 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

Author Biography

Read more

Table of Contents

Read more

Write a Review