- Home
- Computers
- Certification Guides
- Practical SQL Queries for Microsoft SQL Server 2008 R2
Practical SQL Queries for Microsoft SQL Server 2008 R2
List Price:
$68.00
- Availability: Confirm prior to ordering
- Branding: minimum 50 pieces (add’l costs below)
- Check Freight Rates (branded products only)
Branding Options (v), Availability & Lead Times
- 1-Color Imprint: $2.00 ea.
- Promo-Page Insert: $2.50 ea. (full-color printed, single-sided page)
- Belly-Band Wrap: $2.50 ea. (full-color printed)
- Set-Up Charge: $45 per decoration
- Availability: Product availability changes daily, so please confirm your quantity is available prior to placing an order.
- Branded Products: allow 10 business days from proof approval for production. Branding options may be limited or unavailable based on product design or cover artwork.
- Unbranded Products: allow 3-5 business days for shipping. All Unbranded items receive FREE ground shipping in the US. Inquire for international shipping.
- RETURNS/CANCELLATIONS: All orders, branded or unbranded, are NON-CANCELLABLE and NON-RETURNABLE once a purchase order has been received.
Product Details
Author:
Art Tennick
Format:
Paperback
Publisher:
McGraw Hill LLC (November 4, 2010)
Audience:
General/trade
ISBN-13:
9780071746878
ISBN-10:
0071746870
Weight:
19.36oz
Dimensions:
7.4" x 9.2" x 0.63"
Case Pack:
22
File:
McGrawHill-MH_ONIX_V30_US_onix30_all(26_05_26)-20260526.xml
Folder:
McGrawHill
As low as:
$52.36
List Price:
$68.00
Publisher Identifier:
P-MCGRAW
Discount Code:
A
Pages:
336
Pub Discount:
55
Imprint:
McGraw Hill
Overview
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
