Practical SQL Queries for Microsoft SQL Server 2008 R2 - Softcover
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
"synopsis" may belong to another edition of this title.
From the Publisher:
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.
"About this title" may belong to another edition of this title.
- PublisherMcGraw Hill
- Publication date2010
- ISBN 10 0071746870
- ISBN 13 9780071746878
- BindingPaperback
- Edition number1
- Number of pages336
- Rating
Buy New
Learn more about this copy
US$ 29.28
Shipping:
US$ 4.00
Within U.S.A.
Top Search Results from the AbeBooks Marketplace
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw Hill
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: new. New. Fast Shipping and good customer service. Seller Inventory # Holz_New_0071746870
Buy New
US$ 29.28
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw Hill
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: new. New. Seller Inventory # Wizard0071746870
Buy New
US$ 30.90
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw Hill
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: new. New Copy. Customer Service Guaranteed. Seller Inventory # think0071746870
Buy New
US$ 30.58
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw-Hill Education
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Softcover
Quantity: 1
Seller:
Rating
Book Description Condition: new. Seller Inventory # FrontCover0071746870
Buy New
US$ 32.77
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw-Hill Education
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Softcover
Quantity: > 20
Seller:
Rating
Book Description Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books!. Seller Inventory # OTF-Y-9780071746878
Buy New
US$ 37.25
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw Hill
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Softcover
Quantity: 19
Seller:
Rating
Book Description Condition: New. Seller Inventory # ABLIING23Feb2215580013966
Buy New
US$ 38.26
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw-Hill Education
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Paperback
Quantity: > 20
Seller:
Rating
Book Description Paperback. Condition: New. Brand New!. Seller Inventory # 0071746870
Buy New
US$ 43.74
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw-Hill Osborne Media
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Paperback
Quantity: 1
Seller:
Rating
Book Description Paperback. Condition: New. 1. Seller Inventory # DADAX0071746870
Buy New
US$ 45.76
Convert currency
Stock Image
Practical SQL Queries for Microsoft SQL Server 2008 R2
Published by
McGraw Hill
(2010)
ISBN 10: 0071746870
ISBN 13: 9780071746878
New
Softcover
Quantity: > 20
Seller:
Rating
Book Description Condition: New. Seller Inventory # I-9780071746878
Buy New
US$ 47.00
Convert currency
Stock Image
Practical Sql Queries for Microsoft Sql Server 2008 R2
Seller:
Rating
Book Description Condition: New. Seller Inventory # 6666-ING-9780071746878
Buy New
US$ 42.43
Convert currency