SQL Pocket Guide

ISBN-10: 0596526881
ISBN-13: 9780596526887
Edition: 2nd 2006 (Revised)
Authors: Jonathan Gennick
List price: $14.99
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most  More...

eBooks Starting from $11.99
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
History of Western Art Online content $4.95 $1.99
Add to cart
Study Briefs
History of World Philosophies Online content $4.95 $1.99
Add to cart
Study Briefs
American History Volume 1 Online content $4.95 $1.99
Add to cart
Study Briefs
History of Western Music Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $14.99
Edition: 2nd
Copyright year: 2006
Publisher: O'Reilly Media, Incorporated
Publication date: 4/27/2006
Binding: Paperback
Pages: 192
Size: 4.25" wide x 6.75" long x 0.50" tall
Weight: 0.330
Language: English

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular "SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The "SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQL Loader (O'Reilly & Associates, 2001); Oracle SQL Plus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com .

Introduction
Organization of This Book
Feedback Needed!
Conventions
Acknowledgments
Example Data
Analytic Functions
CASE Expressions
Simple CASE Expressions
Searched CASE Expressions
Datatypes
Character String Types
Decimal Types
Binary Integer Types
Datetime Types
Dataype Conversion
Standard CAST Function
Standard EXTRACT Function
Datetime Conversions (Oracle)
Numeric Conversions (Oracle)
Datetime Conversions (DB2)
Numeric Conversions (DB2)
Datetime Conversions (SQL Server)
Numeric Conversions (SQL Server)
Datetime Conversions (MySQL)
Numeric Conversions (MySQL)
Datetime Conversions (PostgreSQL)
Numeric Conversions (PostgreSQL)
Deleting Data
Deleting in Order (MySQL)
Deleting All Rows
Deleting from Views and Subqueries
Returning Deleted Data (Oracle, DB2)
Double-FROM (SQL Server)
Functions
Datetime Functions (Oracle)
Datetime Functions (DB2)
Datetime Functions (SQL Server)
Datetime Functions (MySQL)
Datetime Functions (PostgreSQL)
Numeric and Math Functions (All Platforms)
Trigonometric Functions (All Platforms)
String Functions
Greatest and Least (Oracle, PostgreSQL)
Grouping and Summarizing
Aggregate Functions
Group by
Useful Group by Techniques
Having
Group by Extensions (Oracle, DB2)
Group by Extensions (SQL Server)
Hierarchical Queries
Recursive With (SQL Server, DB2)
Connect by (Oracle)
Indexes, Creating
Indexes, Removing
Inserting Data
Single-Row Inserts
Multi-Row Inserts (DB2, MySQL)
Insert Targets
Subquery Inserts
Returning Inserted Values (Oracle, DB2)
Multi-Table Inserts (Oracle)
Joining Tables
The Concept of a Join
Cross Joins
Inner Joins
The Using Clause (Oracle, MySQL, PostgreSQL)
Natural Joins (Oracle, MySQL, PostgreSQL)
Non-Equi-Joins
Outer Joins
Literals
Text Literals
Numeric Literals
Datetime Literals (Oracle, MySQL, PostgreSQL)
Datetime Interval Literals
Merging Data (Oracle, DB2)
Nulls
Predicates for Nulls
Using CASE with Nulls
Using the Coalesce Function
Functions for Nulls (Oracle)
Functions for Nulls (DB2)
Functions for Nulls (SQL Server)
Functions for Nulls (MySQL)
Functions for Nulls (PostgreSQL)
OLAP Functions
Predicates
Exists Predicates
In Predicates
Between Predicates
Like Predicates
Recursive Queries
Regular Expressions
Regular Expressions (Oracle)
Regular Expressions (SQL Server)
Regular Expressions (MySQL)
Regular Expressions (PostgreSQL)
Selecting Data
The Select Clause
All and Distinct
The From Clause
The Where Clause
The Group by Clause
The Having Clause
The Order by Clause
Subqueries
The With Clause (Oracle, SQL Server, DB2)
Tables, Creating
Creating a Table (Oracle)
Creating a Table (DB2)
Creating a Table (SQL Server)
Creating a Table (MySQL)
Creating a Table (PostgreSQL)
Tables, Modifying
Modifying a Table (Oracle)
Modifying a Table (DB2)
Modifying a Table (SQL Server)
Modifying a Table (MySQL)
Modifying a Table (PostgreSQL)
Tables, Removing
Transaction Management
Autocommit Mode (SQL Server, MySQL, PostgreSQL)
Starting a Transaction
Ending a Transaction
Aborting a Transaction
Aborting to a Transaction Savepoint
Union Queries
Union and Union All
Order by in Union Queries
Names and Datatypes in a Union
Order of Evaluation
Except (or Minus)
Intersect
Updating Data
Simple Updates
New Values from a Subquery
Updating Views and Subqueries
Update From Clause (SQL Server, PostgreSQL)
Returning Updated Data (Oracle, DB2)
Window Functions
Defining a Summary Window (Oracle, DB2, SQL Server)
Ordering and Ranking Within a Window (Oracle, DB2, SQL Server)
Comparing Values Across Rows (Oracle)
Summarizing over a Moving Window (Oracle, DB2)
Window Function Syntax (Oracle)
Window Function Syntax (DB2)
Window Function Evaluation and Placement
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×