| ||||||||||||||||||
 Trade In this Item for up to £0.80
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in SQL Pocket Guide (Pocket Guides) for an Amazon.co.uk gift card of up to £0.80, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Book Description
Product Description
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 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. The third edition covers important database changes, including:
- Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
- Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
- PostgreSQL’s support of recursive WITH and some window functions
- DB2 syntax and datatypes, some compatible with Oracle
- MySQL features such as the TIMESTAMP type and the TO_SECONDS function
Browse and search another edition of this book.
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
One of the nice things about the book is that it includes MySQL in this edition. Apparently, previous editions did not. It does seem to do a good job of addressing the different versions of SQL that people might be using. For instance, in an example where they were discussing the use of double quotes on field names, they mention that this doesn't work in MySQl. Some sections of the book are further broken down in subsections like "Oracle", "MySQL", and so on. The other two platforms that are dealt with are microsoft SQL Server and IBM DB2.
Clearly, this book is better than nothing. And in my case, since I didn't want to spend the money or have to lug around another heavy book, it is also better than some of the bigger, genuinely better books. It certainly is relatively inexpensive, so there's a good chance you still might find it useful. Just don't expect it to answer all your SQL needs, however basic they seem.
The title might not make it clear to you (guess why I'm mentioning this) but this little gem isn't so much about the SQL syntax and mind teasing queries you may encounter in your daily work. It's not even around to share you a couple of neat tricks.
No, this guide is there for you when:
* you still don't know the different joins
* you are not using your databases built in functionality
* you just don't know the quirks of multiple databases in order to implement properly your rolled out ORM
* or when, God forbid, upper management decides that you are in charge of migrating your database with stored procedures, triggers, 10 years old queries and data dumper/loaders running all day to another RDBMS.
And let's not forget, this guide is there when you unhesitatingly state as being a expert, defying you; because, you know, while reading this small guide you actually found out new things about .
While for other books I appreciate I always state things for which you should definitely buy them, for this one I can't find one reason why you shouldn't.
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Databases > SQL
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
