CITATION

Tennick, Art. Practical SQL Queries for Microsoft SQL Server 2008 R2. US: McGraw-Hill Osborne Media, 2010.

Practical SQL Queries for Microsoft SQL Server 2008 R2

Authors:

Published:  October 2010

eISBN: 9780071746885 0071746889 | ISBN: 9780071746878

Book description:

400+ ready-to-use, powerful SQL queries

Learn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications.

  • Enter, maintain, and retrieve database data

  • Search records using the Where clause

  • Sort SQL query results with the Order By clause

  • Create tables and perform joins on tables

  • Perform set operations using Union, Intersect, and Except

  • Group data and produce totals with the Group By clause

  • Manipulate and transform data using built-in functions

  • Create reusable views and user-defined functions

  • Use stored procedures to change SQL dynamically based on conditional factors

  • Create, maintain, and secure database objects with DDL and DCL

  • Deliver SQL query results to end users

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.

Keywords: PRACTICAL SQL QUERIES, SQL SERVER 2008, BOOK, GUIDE, HOW TO, ART TENNICK, SINGLE TABLE, SELECT, ORDER BY, MULTIPLE TABLES, AGGREGATES, NEW TABLES, INTERSECT, UNION, GROUP BY, SYSTEM FUNCTIONS, SUBQUERIES, DELETE, INSERT, UPDATE, VIEWS, USER-DEFINED, FUNCTIONS, STORED, PROCEDURES, PROGRAMMING, DDL, DATA DEFINITION LANGUAGE, DCL, DATA CONTROL LANGUAGE, BUSINESS INTELLIGENCE, BI, STRUCTURED QUERY LANGUAGE, SSMS, MICROSOFT SQL SERVER MANAGEMENT STUDIO, SSRS, REPORTING SERVICES, SSIS, INTEGRATION SERVICES, WINFORMS, WEBFORMS, MICROSOFT SQL SERVER 2008 T-SQL FUNDAMENTALS, BEGINNING T-SQL 2008, BUSINESS INTELLIGENCE, BI, CRYSTAL REPORTS 2008 THE COMPLETE REFERENCE, BUSINESSOBJECTS XI THE COMPLETE REFERENCE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, VISUALIZING INFORMATION WITH MICROSOFT OFFICE VISIO 2007, MICROSOFT OFFICE 2007 BUSINESS INTELLIGENCE 0071494243, BUSINESS INTELLIGENCE WITH MICROSOFT OFFICE PERFORMANCEPOINT SERVER 2007, SUCCESSFUL BUSINESS INTELLIGENCE, SAP BUSINESS INFORMATION WAREHOUSE REPORTING, CRCP CRYSTAL REPORTS CERTIFIED PROFESSIONAL ALL-IN-ONE EXAM GUIDE, ORACLE CRM ON DEMAND REPORTING, ORACLE DISCOVERER 10G HANDBOOK, APPLIED SAP BI 7.0 WEB REPORTS, THE POWER TO PREDICT, RESHAPING YOUR BUSINESS WITH WEB 2.0, CRM AT THE SPEED OF LIGHT, EVENT PROCESSING, PRACTICAL MDX QUERIES, HANDS-ON MICROSOFT SQL SERVER 2008 INTEGRATION SERVICES, BUILDING INTEGRATED BUSINESS INTELLIGENCE SOLUTIONS WITH SQL SERVER 2008 R2 & OFFICE 2010, IBM COGNOS 8 BUSINESS INTELLIGENCE: THE OFFICIAL GUIDE, DATA WAREHOUSE DESIGN, ORACLE ESSBASE & ORACLE OLAP, STAR SCHEMA THE COMPLETE REFERENCE, PRACTICAL POWERPIVOT & DAX FORMULAS FOR EXCEL 2010, PRACTICAL MDX QUERIES FOR MICROSOFT SQL SERVER ANALYSIS SERVICES 2008, PRACTICAL DMX QUERIES FOR MICROSOFT SQL SERVER ANALYSIS SERVICES 2008