[ 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:
- 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