SQL Pocket Guide: A Guide to SQL Usage
Super Savings Item! Save 35% on the SQL Pocket Guide: A Guide to SQL Usage by O'Reilly Media at Translate This Website. MPN: 978-1-4493-9409-7. Hurry! Limited time offer. Offer valid only while supplies last. 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.
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
|Item Weight:||0.4 pounds|
|Item Size:||0.48 x 7 x 7 inches|
|Package Weight:||0.4 pounds|
|Package Size:||4.25 x 0.47 x 0.47 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product by O'Reilly Media, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
Related Best Sellers
By Mike Murach & Associates
ean: 9781943872381, isbn: 1943872384,
I can t count how many PHP books I have purchased over the years trying to learn the language. Murach s was the first book that helped me grasp the concepts and got me onto actually scripting in PHP. That s what one developer posted on the first edit...
By Mike Murach Associates
mpn: 43171-600701, ean: 9781890774820, isbn: 1890774820,
"If you ever wanted to learn to use MySQL, write SQL queries, create database elements, then this is the book to pick up." (JavaRanch.com)"I was amazed at how much information was packed into this book.""As a developer with almost 10 years of MySQL e...
By O'Reilly Media
ean: 9781491978917, isbn: 1491978910,
Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you’ll tackle dynamic web programming with...
By Brand: MySQL Press
ean: 9780672326332, isbn: 0672326337,
With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database ...
By CreateSpace Independent Publishing Platform
ean: 9781985254985, isbn: 1985254980,
MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swed...
By O'Reilly Media
ean: 9781491933572, isbn: 9781491933572,
If you want to get started with PHP, this book is essential. Author David Sklar (PHP Cookbook) guides you through aspects of the language you need to build dynamic server-side websites. By exploring features of PHP 5.x and the exciting enhancements i...
By O'Reilly Media
mpn: 9780596518844, ean: 9780596518844, isbn: 9780596518844,
For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANS...
By Brand: O'Reilly Media
mpn: 978-0-596-52083-0, ean: 9780596520830, isbn: 9780596520830,
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform a...
By Cengage Learning
ean: 9781111527273, isbn: 111152727X,
A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longsta...
By Brand: Chapman and Hall/CRC
ean: 9781439806869, isbn: 1439806861,
Encouraging hands-on practice, Mastering Linux provides a comprehensive, up-to-date guide to Linux concepts, usage, and programming. Through a set of carefully selected topics and practical examples, the book imparts a sound understanding of operatin...