Practical SQL Queries for Microsoft SQL Server 2008 R2 : Database & ERP - OMG - Art Tennick

Practical SQL Queries for Microsoft SQL Server 2008 R2

By: Art Tennick

Paperback | 4 November 2010 | Edition Number 1

At a Glance

Paperback


$110.95

or 4 interest-free payments of $27.74 with

 or 

Aims to ship in 10 to 15 business days

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 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 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

More in Database Programming

SQL For Dummies : 9th edition - Allen G. Taylor

RRP $57.95

$36.50

37%
OFF
SQL Tuning : O'Reilly Ser. - Dan Tow

RRP $75.95

$33.80

55%
OFF
SQL Pocket Guide : A Guide to SQL Usage - Alice Zhao

RRP $68.50

$32.50

53%
OFF
MySQL Pocket Reference 2e : Pocket Reference (O'Reilly) - George Reese
Head First SQL : Head First - Lynn Beighley

RRP $114.00

$50.40

56%
OFF
Learning Oracle PL/SQL : Learning Ser. - Bill Pribyl

RRP $95.00

$43.25

54%
OFF
Mastering Oracle SQL 2e : O'Reilly Ser. - Sanjay Mishra

RRP $95.00

$43.25

54%
OFF
Head First PHP & MySQL : Head First - Lynn Beighley

RRP $104.50

$46.90

55%
OFF
LINQ Pocket Reference : Pocket Reference (O'Reilly) - Joseph Albahari
Oracle PL/SQL Best Practices : O'Reilly Ser. - Steven Feuerstein

RRP $57.00

$28.25

50%
OFF
PHP & MySQL : The Missing Manual - Brett Mclaughlin

RRP $76.00

$35.75

53%
OFF
SQL Programming - Robin Nixon

Fold-Out Book or Chart

RRP $19.99

$19.75

Relational Theory for Computer Professionals : Theory in Practice - C. J. Date
97 Things Every Programmer Should Know : OREILLY - Kevlin Henney

RRP $76.00

$35.75

53%
OFF
Learning SQL : Generate, Manipulate, and Retrieve Data - Alan Beaulieu