cdc-coteauxdegaronne
» » SQL Pocket Guide (Pocket Reference (O'Reilly))
eBook SQL Pocket Guide (Pocket Reference (O'Reilly)) ePub

eBook SQL Pocket Guide (Pocket Reference (O'Reilly)) ePub

by Jonathan Gennick

  • ISBN: 0596526881
  • Category: Databases and Big Data
  • Subcategory: Computers
  • Author: Jonathan Gennick
  • Language: English
  • Publisher: O'Reilly Media; Second edition (April 27, 2006)
  • Pages: 192
  • ePub book: 1930 kb
  • Fb2 book: 1265 kb
  • Other: mobi azw rtf mbr
  • Rating: 4.6
  • Votes: 473

Description

He writes extensively on database topics, and is the author of such successful books as: Oracle SQLPlus: The Definitive Guide, Oracle SQLPlus Pocket Reference, and Oracle SQLLoader: The Definitive Guide. As the title indicates, this book is a "Pocket Guide" for the 4 major database platforms (Oracle, MS SQL Server, MySQL, and DB2).

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 syntax, and type conversion functions and formats

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 syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download.

Start by marking SQL Pocket Guide (Pocket Reference (O'Reilly)) as. .

Start by marking SQL Pocket Guide (Pocket Reference (O'Reilly)) as Want to Read: Want to Read savin. ant to Read. He is the author of several books, and also a number of articles in Oracle Magazine.

This pocket guide presents the most crucial information about SQL in a compact .

Topics include: Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK). Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience.

The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions.

series Pocket Reference (O'Reilly). Books related to SQL Pocket Guide. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions.

Printed in the United States of America. Published by O’Reilly Media, In. 1005 Gravenstein Highway North, Sebastopol, CA 95472. With a subscription, you can read any page and watch any video from our library online. Read books on your cell phone and mobile devices.

DOWNLOAD SQL Pocket Guide (Pocket Reference (O'Reilly)) By Jonathan Gennick DOWNLOAD The Esquire Guide to Bodyweight Training By Adam Schersten with Chris Klimek.

DOWNLOAD SQL Pocket Guide (Pocket Reference (O'Reilly)) By Jonathan Gennick. DOWNLOAD Latin American Adjustment: How Much Has Happened? By. 1 сообщение. DOWNLOAD The Esquire Guide to Bodyweight Training By Adam Schersten with Chris Klimek. DOWNLOAD Questions of Perception: Phenomenology of Architecture By Steven Holl.

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 (includingthe free Oracle Database 10g Express Edition (XE))Microsoft SQL Server 2005MySQL 5IBM DB2 8.2PostreSQL 8.1 database

Comments

Bys Bys
"SQL Pocket Guide - 2nd Edition" is a short reference book for SQL DML (Data Manipulation Language), transaction control statements, datatypes, datatype conversion, table creation, and table modification. As the title indicates, this book is a "Pocket Guide" for the 4 major database platforms (Oracle, MS SQL Server, MySQL, and DB2). DO NOT EXPECT this book to be a complete reference or learning guide. Like most pocket guides, only people that already know the topic will find this text most useful. I own BOTH the 1st & 2nd editions. Due to my extensive use of the 1st edition, I purchased the 2nd edition released in 2006. This is the single most used book in my library! In fact, it is never on the book shelf! It's on my desk, in my bag, and travels with me on location. I work on a variety of database platforms with the 2 biggies being MS SQL Server & Oracle. I know the language, but at times can forget the exact syntax needed for the platform I'm working with. This book provides me with an extremely efficient way to "refresh" my memory and because it covers the 4 major platforms, I'm usually covered with this ONE small book.

The layout of the 2nd edition has been reorganized alphabetically by keyword and now covers: Oracle 10g including Oracle Express Ed, Microsoft SQL Server 2005, IBM DB2 release 8.2, MySQL 5.0, and PostgreSQL 8.1. As the layout of the 2nd edition has dramatically changed since the 1st edition and is now organized alphabetically by keyword (the keyword represented on each page is listed at the bottom of the page), you can quickly find the page you're looking for by flipping through the book and looking at the bottom right corner of the page. This is MUCH MUCH easier and faster! The new edition still has a very good Index, if you can't find what you're looking for on a flip-through pass.

Also new in the 2nd ed. is an extensive listing of datatypes, datatype conversions, and syntax variation for table creation and modification. This was a complaint in other reviews specific to the 1st ed., as missing. NOT SO in the new 2nd edition! PLEASE CHECK THE DATE OF THE REVIEW YOU'RE READING to ensure it pertains to the 2nd edition.

I was so impressed with this book... I actually bought TWO copies of the 2nd edition -- one for me and one for a co-worker -- AND passed my 1st edition on to another co-worker. For those "Now, how do I write that..." moments, this book can save you HOURS! I also like seeing the different examples and sample result sets for the different platforms. If the book doesn't cover what I'm looking for, I can always go to a more extensive reference book.
Ynonno Ynonno
Handy guide for someone who is not a programmer but knows just enough to administer a database.
Larosa Larosa
This is a good reference book. Because SQL has so many flavors, there are nuances that exist which force writers to reference them in a almost any book on the subject. Narrowing in on your paticular version is very helpful. Perhaps these would be better written for a specific audience if they were Manufacturer and Version specific and without the crosswalks.

Wouldn't you sell more books if it were version specific?
Āłł_Ÿøūrš Āłł_Ÿøūrš
Quick and concise, this book never left my side for years while maintaining multiple SQL servers and their databases containing millions of records. I came in completely ignorant of what SQL was and how to use it and O'Reilly's books put me on the path to success in a new (to me) industry for YEARS. Highly recommend the O'Reilly series; They are the best.
Vivaral Vivaral
I was looking for a small SQL command resource and this fit the bill perfectly. The O'Reily series has never failed to hit the mark as a first class reference source. This book is small and pocketable and has provided me with the support I was looking for. I highly recommend this small powerful reference book!
Daigrel Daigrel
I work with SQL on various platforms everyday an this book is a life saver. I can easily flip to the what is not working in mysql oracle or sql server and see my syntax mistakes
Uylo Uylo
This is a must have for anybody who writes SQL scripts. It is extremely helpful for quickly finding those statements you don't use everyday. It has great examples, references for multiple databases, and is just an all-around great reference!
Great little pocket guide, i am a Computer Tech and this thing is so darned handy, i have to create SQL's on the fly and this has allowed me to NOT have to remember every little thing.