Practical SQL queries for Microsoft SQL server 2008 R2 [

Practical SQL queries for Microsoft SQL server 2008 R2 [

"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 appli...

Full description

Bibliographic Details
Main Author: Tennick, Art (Author)
Format: Book
Language:English
Published: New York : McGraw-Hill , c2011
Subjects:
Querying (Computer science)
Relational databases
SQL (Computer program language)
Online Access:McGraw Hill
Table of Contents:
  • 1. Select : single table
  • 2. Where
  • 3. Order by
  • 4. Select : multiple tables
  • 5. Aggregates
  • 6. Select : new tables
  • 7. Except/intersect/union
  • 8. Group by
  • 9. System functions
  • 10. Subqueries
  • 11. Delete/insert/update
  • 12. Views/user-defined functions
  • 13. Stored procedures/programming
  • 14. Data definition language (DDL) and data control language (DCL)
  • 15. After you finish

Similar Items