SQL pocket guide / Jonathan Gennick.

Format:

Book

Author/Creator:

Gennick, Jonathan.

Language:

English

Subjects (All):

Database management.

Relational databases.

SQL (Computer program language).

Physical Description:

1 online resource (206 p.)

Edition:

3rd ed.

Place of Publication:

Sebastopol, California : O'Reilly, 2011.

Language Note:

English

System Details:

text file

Summary:

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression

Contents:

Table of Contents; Chapter 1. SQL Pocket Guide; Introduction; Organization of This Book; Platform notes; Conventions; Example Data; Using Code Examples; How to Contact Us; Safari® Books Online; Acknowledgments; Analytic Functions; CASE Expressions: Simple; CASE Expressions: Searched; CAST Function; CONNECT BY Queries; Core CONNECT BY Syntax; Creative CONNECT BY; WHERE Clauses with CONNECT BY; Joins with CONNECT BY; Sorting CONNECT BY Results; Loops in Hierarchical Data; Supporting Functions and Operators; Data Type Conversion; Data Types: Binary Integer; Data Types: Character String

Data Types: DatetimeDB2; MySQL; Oracle; PostgreSQL; SQL Server; Data Types: Decimal; DB2's DECFLOAT Type; DECIMAL/NUMBER Type; Datetime Conversions: DB2; Datetime Conversions: MySQL; Date and Time Elements; TO_DAYS and FROM_DAYS; Unix Timestamp Support; Seconds in the Day; DATE_FORMAT and TIME_FORMAT; Datetime Conversions: Oracle; Datetime Conversions: PostgreSQL; Datetime Conversions: SQL Server; CAST and SET DATEFORMAT; CONVERT; DATENAME and DATEPART; DAY, MONTH, and YEAR; Datetime Functions: DB2; Datetime Functions: MySQL; Datetime Functions: Oracle; Getting Current Date and Time

Rounding and TruncatingOther Oracle Datetime Functions; Datetime Functions: PostgreSQL; Getting Current Date and Time; Rounding and Truncating; Other PostgreSQL Datetime Functions; Datetime Functions: SQL Server; Deleting Data; Deleting in Order; Deleting All Rows; Deleting from Views and Subqueries; Returning Deleted Data: DB2; Returning Deleted Data: Oracle; Returning Deleted Data: SQL Server; Double-FROM; EXTRACT Function; GREATEST; Grouping and Summarizing; Aggregate Functions; GROUP BY; Listing the Detail Values; Reducing the GROUP BY List; Grouping Before the Join; HAVING; ROLLUP; CUBE

GROUPING SETSRelated Functions; Hierarchical Queries; Recursive WITH; Tracking Your Depth; Breadth-First Versus Depth-First Sorting; Detecting Recursive Loops; Indexes, Creating; Indexes, Removing; Inserting Data; Single-Row Inserts; Multirow Inserts; Insert Targets; Subquery Inserts; Returning Inserted Values: DB2; Returning Inserted Values: Oracle; Returning Inserted Data: SQL Server; Multitable Inserts; Unconditional multitable insert; Conditional multitable insert; ALL versus FIRST; Joining Tables; The Concept of a Join; Cross Joins; Inner Joins; The USING Clause; Natural Joins

Non-Equi-JoinsOuter Joins; Left outer joins; Interpreting nulls in an outer join; Right outer joins; Full outer joins; Vendor-specific outer join syntax; LEAST; Literals; Text Literals; Numeric Literals; Datetime Literals; Datetime Interval Literals; Merging Data; Nulls; Predicates for Nulls; Using CASE with Nulls; Using the COALESCE Function; Functions for Nulls: DB2; Functions for Nulls: MySQL; Functions for Nulls: Oracle; Functions for Nulls: PostgreSQL; Functions for Nulls: SQL Server; Numeric Conversions: DB2; Numeric Conversions: MySQL; Numeric Conversions: Oracle

Numeric Conversions: PostgreSQL

Notes:

Includes index.

Description based on print version record.

ISBN:

9781449396664

1449396666

9781449301866

144930186X

OCLC:

780425360