SQL in a Nutshell: A Desktop Quick Reference Guide by Kline

Description: About this productProduct InformationFor programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book. Product IdentifiersPublisherO'reilly Media, IncorporatedISBN-100596518846ISBN-139780596518844eBay Product ID (ePID)69571511Product Key FeaturesAuthorKevin K LinePublication NameSql in a Nutshell : a Desktop Quick Référence GuideFormatTrade PaperbackLanguageEnglishFeaturesRevisedSubjectData Modeling & Design, Programming Languages / Sql, Data ProcessingSeriesIn a Nutshell (O'reilly) Ser.Publication Year2008TypeTextbookSubject AreaComputersNumber of Pages591 PagesDimensionsItem Length9 inItem Height1.2 inItem Width6 inItem Weight22.6 OzAdditional Product FeaturesEdition Number3LCCN2009-497288Lc Classification NumberQa76.73.S67Edition DescriptionRevised EditionTable of ContentPreface; Why This Book?; Who Should Read This Book?; How This Book Is Organized; How to Use This Book; Resources; Changes in the Third Edition; Conventions Used in This Book; Using Code Examples; How to Contact Us; Safari® Books Online; 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 SQL2003 and Platform-Specific Datatypes; 2.3 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;Shared and Platform-Specific Keywords;Colophon;Copyright Date2008Target AudienceScholarly & ProfessionalDewey Decimal005.75/85Dewey Edition21IllustratedYes

Price: 10.9 USD

Location: Multiple Locations

End Time: 2024-10-05T20:54:56.000Z

Shipping Cost: 3.97 USD