SQL in a Nutshell A Desktop Quick Reference Guide 3rd Edition by Kline ISBN 0596518846 978-0596518844

SQL in a Nutshell A Desktop Quick Reference Guide 3rd Edition by Kline – Ebook PDF Instant Download/Delivery:0596518846 ,978-0596518844
Full download SQL in a Nutshell A Desktop Quick Reference Guide 3rd Edition after payment

Product details: 

ISBN 10:0596518846

ISBN 13:978-0596518844

Author:Kline

For 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.

Table of contents: 

1. SQL History and Implementations
   The Relational Model and ANSI SQL
   Codd’s Rules for Relational Database Systems
   Data structures 
   NULLs 
   Metadata
   The language 
   Views 
   Set operations 
   Codd’s Rules in Action: Simple SELECT Examples
   History of the SQL Standard
   What’s New in SQL
   What’s New in SQL
   Levels of Conformance
   Supplemental Features Packages in the SQL Standard
   SQL Statement Classes
   SQL Dialects
2. Foundational Concepts
   Database Platforms Described in This Book
   Categories of Syntax
   Identifiers
   Naming conventions
   Identifier rules
   Literals
   Operators
   Arithmetic operators
   Assignment operators
   Bitwise operators
   Comparison operators
   Logical operators
   Unary operators
   Operator precedence
   System delimiters and operators
   Keywords and Reserved Words
   SQL2003 and Platform-Specific Datatypes
   MySQL Datatypes
   Oracle Datatypes
   PostgreSQL Datatypes
   SQL Server Datatypes
   Constraints
   Scope
   Syntax
   PRIMARY KEY Constraints
   FOREIGN KEY Constraints
   UNIQUE Constraints
   CHECK Constraints
3. SQL Statement Command Reference
   How to Use This Chapter
   SQL Platform Support
   SQL Command Reference
4. SQL Functions
   Types of Functions
   Deterministic and Nondeterministic Functions
   Aggregate and Scalar Functions
   Window Functions
   ANSI SQL Aggregate Functions
   ANSI SQL Window Functions
   ANSI SQL2003’s Window Syntax
   Oracle’s Window Syntax
   SQL Server’s Window Syntax
   Partitioning
   Ordering
   Grouping or Windowing
   List of Window Functions
   ANSI SQL Scalar Functions
   Built-in Scalar Functions
   CASE and CAST Functions
   Numeric Scalar Functions
   String Functions and Operators
   Platform-Specific Extensions
   MySQL-Supported Functions
   Oracle-Supported Functions
   PostgreSQL-Supported Functions
   SQL Server-Supported Functions

People also search for:

sql in a nutshell

sql in a nutshell a desktop quick reference

pluralsight sql server fundamentals

r in a nutshell a desktop quick reference

v$sql in sql server

Tags: Kline, SQL, Nutshell