SQL Pocket Guide

SQL Pocket Guide
Author :
Publisher : "O'Reilly Media, Inc."
Total Pages : 164
Release :
ISBN-10 : 0596005121
ISBN-13 : 9780596005122
Rating : 4/5 (21 Downloads)

Book Synopsis SQL Pocket Guide by : Jonathan Gennick

Download or read book SQL Pocket Guide written by Jonathan Gennick and published by "O'Reilly Media, Inc.". This book was released on 2004 with total page 164 pages. Available in PDF, EPUB and Kindle. Book excerpt: This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include: Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK). Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate) Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries. Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site. "If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book."--Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com


SQL Pocket Guide Related Books

SQL Pocket Guide
Language: en
Pages: 164
Authors: Jonathan Gennick
Categories: Database management
Type: BOOK - Published: 2004 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracl
SQL Pocket Guide
Language: en
Pages: 247
Authors: Alice Zhao
Categories: Computers
Type: BOOK - Published: 2021-08-26 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll
SQL Pocket Guide
Language: en
Pages: 206
Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2010-11-10 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

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
Oracle SQL Tuning Pocket Reference
Language: en
Pages: 113
Authors: Mark Gurry
Categories: Computers
Type: BOOK - Published: 2002-01-01 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute effic
MySQL Pocket Reference
Language: en
Pages: 95
Authors: George Reese
Categories: Computers
Type: BOOK - Published: 2003 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP ope