Ships from: Fort Worth, TX
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Want a NOOK? Explore Now
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:
Praise for SQL Pocket Guide;
Chapter 1: SQL Pocket Guide;
1.1 Introduction;
1.2 Analytic Functions;
1.3 CASE Expressions;
1.4 Datatypes;
1.5 Dataype Conversion;
1.6 Deleting Data;
1.7 Functions;
1.8 Grouping and Summarizing;
1.9 Hierarchical Queries;
1.10 Indexes, Creating;
1.11 Indexes, Removing;
1.12 Inserting Data;
1.13 Joining Tables;
1.14 Literals;
1.15 Merging Data (Oracle, DB2);
1.16 Nulls;
1.17 OLAP Functions;
1.18 Predicates;
1.19 Recursive Queries;
1.20 Regular Expressions;
1.21 Selecting Data;
1.22 Subqueries;
1.23 Tables, Creating;
1.24 Tables, Modifying;
1.25 Tables, Removing;
1.26 Transaction Management;
1.27 Union Queries;
1.28 Updating Data;
1.29 Window Functions;
Jonathan Gennick's SQL Pocket Guide is a seamless guide any Database Admin or developer, expert or beginner alike, should have in their IT toolbox. I recall when I was in the university; I picked up a "learn SQL in 24 hours" book as a supplementary to our curriculum book. Had I had this pocket guide then, I would have most certainly struggled less. Most recently I been developing .Net applications to a Pervasive SQL Database, and even with years of Microsoft SQL Server experience, this reference book has been on my side.
SQL is a platform independent database language, this guide will provide guidance and examples for Oracle, DB2, SQL Server, MySQL and PostgreSQL. You can also download code sample for all the mentioned platforms. Moreover, the organization of the book will indicate platform specifics, for instance, Data types spans several pages to distinguish between the various database platforms. The book is structured in alphabetical order by commands, this makes it easier for when you know you want to write a UNION but don't remember the syntax, you're sure to find it towards the end of the book. At times it may seem there are superfluous references to databases you don't work with, nonetheless, it is a Pocket Book primarily for reference and I won't hesitate in recommending it.
3 out of 3 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Wed Jun 28 00:00:00 EDT 2006
This is a great quick reference. I like that it distinguishes which platform the various sql will work with. The book does not bog down with extreme examples. This book is not a training book. This does a nice job of covering common basic sql.
1 out of 1 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
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 ...