
SQL in a Nutshell
O'Reilly (Publisher)
2nd Edition
Published on 2. November 2004
Book
Paperback/Softback
710 pages
978-0-596-00481-1 (ISBN)
Article exhausted; check for reprint
Description
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.
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.
More details
Edition
2., Aufl.
Language
English
Place of publication
Sebastopol
United States
Target group
Professional and scholarly
ELT/ESL
Edition type
Revised edition
Dimensions
Height: 230 mm
Width: 156 mm
Weight
843 gr
ISBN-13
978-0-596-00481-1 (9780596004811)
Schweitzer Classification
Other editions
New editions

Book
06/2022
4th Edition
O'Reilly
€74.50
Article not available at the moment

Kevin Kline | Brand Hunt | Daniel Kline
SQL in a Nutshell
Book
12/2008
3rd Edition
O'Reilly
€37.00
Article exhausted; check for reprint
Additional editions

E-Book
09/2004
1st Edition
O'Reilly
€37.49
Available for download

E-Book
09/2004
1st Edition
O'Reilly
€29.49
Available for download
Previous edition

Book
01/2001
O'Reilly
€24.50
Article exhausted; check for reprint
Persons
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). Daniel Kline is an Assistant Professor of English at the University of Alaska, Anchorage, where he specializes in medieval literature, literary and cultural theory, and computer-assisted pedagogy. He completed his Ph.D. at Indiana University, Bloomington, and in addition to numerous scholarly presentations, Dan recently has published academic essays in Literary and Linguistic Computing, Philological Quarterly, Chaucer Review, and Essays in Medieval Studies. When he's not spending time with his wife and two boys, Dan frets over his pet project, the Electronic Canterbury Tales. Brand Hunt is a Project Manager and Software Developer at Systems Research and Development (http://srdsoftware.com) . The team at SRD is a world leader in systems for privacy-friendly identity recognition and relationship awareness. Prior to SRD, Brand worked at Rogue Wave software. Beyond work, Brand enjoys playing board games, pinochle, and snowboarding with his family and friends.
Content
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