Sql In A Nutshell - Brossura

Kline, Kevin E.; Hunt, Brand; Kline, Daniel

Brossura

ISBN 10: 0596004818 ISBN 13: 9780596004811

Casa editrice: Oreilly & Associates Inc, 2004

Riassunto

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.

Su questo libro

L'autore:

Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring tools. Kevin is also a founding board member and former President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin's most popular book is SQL in a Nutshell published by O'Reilly Media. Kevin is also the author of monthly magazine columns for SQL Server Magazine and Database Trends & Applications. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections.

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.

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. Dan can be reached at afdtk@uaa.alaska.edu.

Contenuti:

Preface; Why This Book?; Who Should Read This Book?; How This Book Is Organized; Conventions Used in This Book; How to Use This Book; How to Contact Us; Safari Enabled; Resources; Changes in the Second Edition; Acknowledgments; Chapter 1: SQL History and Implementations; 1.1 The Relational Model and ANSI SQL; 1.2 History of the SQL Standard; 1.3 SQL Dialects; Chapter 2: Foundational Concepts; 2.1 Database Platforms Described in This Book; 2.2 Categories of Syntax; 2.3 SQL2003 and Platform-Specific Datatypes; 2.4 Constraints; Chapter 3: SQL Statement Command Reference; 3.1 How to Use This Chapter; 3.2 SQL Platform Support; 3.3 SQL Command Reference; Chapter 4: SQL Functions; 4.1 Types of Functions; 4.2 ANSI SQL Aggregate Functions; 4.3 ANSI SQL Window Functions; 4.4 ANSI SQL Scalar Functions; 4.5 Platform-Specific Extensions; Chapter 5: Database Programming; 5.1 Database Programming Overview; 5.2 Opening a Database Connection; 5.3 Closing a Database Connection; 5.4 Managing Transactions; 5.5 Executing Statements; 5.6 Retrieving Data; 5.7 Bound Parameters; 5.8 Error Handling; 5.9 Examples; Appendix A: Sybase Adaptive Server; A.1 Sybase Adaptive Server Datatypes; A.2 Sybase Adaptive Server SQL Statements; A.3 Sybase Adaptive Server SQL Functions; A.4 Sybase Adaptive Server Keywords; Appendix B: Shared and Platform-Specific Keywords; Colophon;|

• Preface
• Chapter 1: SQL History and Implementations
• Chapter 2: Foundational Concepts
• Chapter 3: SQL Statement Command Reference
• Chapter 4: SQL Functions
• Chapter 5: Database Programming
• Appendix A: Sybase Adaptive Server
• Appendix B: Shared and Platform-Specific Keywords
• Colophon

Su questa edizione

• Editore: Oreilly & Associates Inc
• Data di pubblicazione: 2004
• ISBN 10: 0596004818
• ISBN 13: 9780596004811
• Rilegatura: Copertina flessibile
• Numero edizione: 2
• Numero di pagine: 691