 |
SQL in a Nutshell, 2nd Edition
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - SQL Pocket Guide, 2nd Edition (Stock Expected September 5th); Jonathan Gennick, $9.95, 34% Off!
- SQL Cookbook; Anthony Molinaro, $24.95, 38% Off!
- XML in a Nutshell, 3rd Edition; Eilliotte Harold, et al, $24.95, 38% Off!
- PostgreSQL; Korry Douglas, et al, $31.95, 36% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
SQL in a Nutshell applies the eminently useful "Nutshell" format to
Structured Query Language (SQL), the elegant--but complex--descriptive language
that is used to create and manipulate large stores of data. For SQL programmers,
analysts, and database administrators, the new second edition of SQL in a
Nutshell is the essential date language reference for the world's top SQL
database products. SQL in a Nutshell is a lean, focused, and thoroughly
comprehensive reference for those who live in a deadline-driven world.
This invaluable desktop quick reference drills down and documents every SQL
command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL
Server) and open source implementations (PostgreSQL, and MySQL). It describes
every command and reference and includes the command syntax (by vendor, if the
syntax differs across implementations), a clear description, and practical examples
that illustrate important concepts and uses. And it also explains how the leading
commercial and open sources database product implement SQL. This wealth of information
is packed into a succinct, comprehensive, and extraordinarily easy-to-use format
that covers the SQL syntax of no less than 4 different databases.
When you need fast, accurate, detailed, and up-to-date SQL information, SQL
in a Nutshell, Second Edition will be the quick reference you'll reach for
every time. SQL in a Nutshell is small enough to keep by your keyboard,
and concise (as well as clearly organized) enough that you can look up the syntax
you need quickly without having to wade through a lot of useless fluff. You
won't want to work on a project involving SQL without it.
Table of Contents
Preface
1. SQL History and Implementations
The Relational Model and ANSI SQL
History of the SQL Standard
SQL Dialects
2. Foundational Concepts
Database Platforms Described in This Book
Categories of Syntax
SQL2003 and Vendor-Specific Datatypes
Constraints
3. SQL Statement Command Reference
How to Use This Chapter
SQL Platform Support
SQL Command Reference
4. SQL Functions
Types of Functions
ANSI SQL Aggregate Functions
ANSI SQL Window Functions
ANSI SQL Scalar Functions
Platform-Specific Extensions
5. Database Programming
Database Programming Overview
Opening a Database Connection
Closing a Database Connection
Managing Transactions
Executing Statements
Retrieving Data
Bound Parameters
Error Handling
Examples
A. Sybase Adaptive Server
B. Shared and Platform-Specific Keywords
Index
About the Author
Kevin E. Kline serves as the lead information architect
for shared information services at Deloitte & Touche LLP. When he's not
pulling out his hair over work issues, he likes to spend time with his wife
and kids, garden, restore his '66 Chevy truck, and play classical guitar. After
finishing SQL in a Nutshell, Kevin doesn't want to look at a computer
outside of work hours for months! Kevin is the author of Transact-SQL Programming
for O'Reilly & Associates. He is also the co-author of Professional SQL
Server 6.5 Admin (WROX Press) and author of Oracle CDE: Reference and
User's Guide (Butterworth-Heinemann).
|
|
