Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Über dieses Produkt
Product Identifiers
PublisherMcgraw-Hill Education
ISBN-100071746870
ISBN-139780071746878
eBay Product ID (ePID)102799144
Product Key Features
Number of Pages336 Pages
Publication NamePractical Sql Queries for Microsoft Sql Server 2008 R2
LanguageEnglish
Publication Year2010
SubjectCertification Guides / General, Databases / General
TypeTextbook
AuthorArt Tennick
Subject AreaComputers
FormatTrade Paperback
Dimensions
Item Height0.6 in
Item Weight19.4 Oz
Item Length9.2 in
Item Width7.4 in
Additional Product Features
Intended AudienceTrade
LCCN2010-037507
Dewey Edition22
IllustratedYes
Dewey Decimal005.7585
Table Of ContentChapter 1. Select: Single Table; Chapter 2. Where; Chapter 3. Order By; Chapter 4. Select: Multiple Tables; Chapter 5. Aggregates; Chapter 6. Select: New Tables; Chapter 7. Except/Intersect/Union; Chapter 8. Group By; Chapter 9. System Functions; Chapter 10. Subqueries; Chapter 11. Delete/Insert/Update; Chapter 12. Views/User-Defined Functions; Chapter 13. Stored Procedures/Programming; Chapter 14. Data Definition Language (DDL) and Data Control Language (DCL); Chapter 15. After You Finish; Index
SynopsisFeaturing 300 ready-to-use SQL queries, this hands-on guide explains how to extract real, actionable business intelligence--and increase effective decision-making--by utilizing the power of SQL queries, 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