[ Home | Contact ]

SQL: Visual QuickStart Guide, 3rd Edition

Description

Format: Trade paperback, 496 pages, 7" x 9"
Publisher: Peachpit Press, June 2008
ISBN-10: 0321553578
ISBN-13: 978-0321553577
List price: USA $34.99, Canada $37.99, UK £19.99
Buy it: Amazon.com, Amazon.ca, Amazon.co.uk

Features

• Teaches the SQL programming language and the relational model to beginning and intermediate programmers
• Covers the core language for ANSI/ISO (standard) SQL:2003 and product-specific variations for:
  • Microsoft Access
  • Microsoft SQL Server
  • Oracle
  • IBM DB2
  • MySQL
  • PostgreSQL
• Hundreds of examples of varied difficulty encourage you to experiment and explore
• The split-page format separates examples from the flow of the text
• The layout makes it a good quick reference for experienced programmers
• Concise, lightweight, and cheap
• Extensively cross-referenced; includes a 14-page index
• Excerpts are available
• Download this book's companion files

New to this Edition

• Covers the most recent versions of Access, SQL Server, Oracle, DB2, MySQL, and PostgreSQL
• Adds a chapter on SQL tricks
• Includes new programming tips and other odds and ends
• The following sections and sidebars are new or revised:
  • Companion Website
  • Other DBMSes
  • Microsoft Access
  • Microsoft SQL Server
  • Oracle
  • IBM DB2
  • MySQL
  • PostgreSQL
  • Learning Database Design
  • Creating the Sample Database
  • Unique Identifiers
  • Sorting by Substrings
  • Sorting and Nulls
  • Column Aliases and WHERE
  • Avoiding Division by Zero
  • Aggregating and Nulls
  • UNION Commutativity
  • Displaying Table Definitions
  • ACID
  • Advanced SQL Books
  • Retrieving Metadata
  • Working with Dates
  • Calculating a Median
  • Finding Extreme Values
  • Changing Running Statistics Midstream
  • Pivoting Results
  • Working with Hierarchies