SQL Pocket Guide (Pocket Guides)

SQL Pocket Guide (Pocket Guides), 9781449394097 (1449394094), O'Reilly, 2010

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

Comments

Amazing Books

Bio-MEMS: Technologies and Applications

CRC Press, 2006

Microelectromechanical systems (MEMS) are evolving into highly integrated technologies for a variety of application areas. Add the biological dimension to the mix and a host of new problems and issues arise that require a broad understanding of aspects from basic, materials, and medical sciences in addition to engineering. Collecting the efforts of...

Organizational Data Mining: Leveraging Enterprise Data Resources for Optimal Performance

IGI Global, 2003

The adage “knowledge is power” is widely accepted in corporate circles and tremendous amounts of data have and are being accumulated towards the goal of acquiring more knowledge. But corporations are increasingly realizing that there is a wide gap between “data” and “knowledge.” Data warehousing and data...

Canon EOS Rebel T5i/700D Digital Field Guide

John Wiley & Sons, 2013

All you need to know to use the latest exciting new dslr camera from Canon

If you want to get great photos from Canon's new Rebel T5i/700D dslr camera, you've come to the right place. This practical book takes you step by step through each button, mode, function, and feature of the hot new Rebel T5i/700D, so...

Where Stuff Comes From: How Toasters, Toilets, Cars, Computers and Many Other Things Come to Be As They Are

Routledge, 2003

Where Stuff Comes From is about paper clips, post-its, bathtubs, cars and all the other stuff in our lives. It is about how these items were imagined into existence and made a part of the American material culture. From the designer to the manufacturer to the business owner to the consumer, Molotch guides us through the worlds of technology,...

Market Timing For Dummies (Business & Personal Finance)

For Dummies, 2008

Want to improve your market timing so you can send your investment returns soaring? Market Timing For Dummies takes the guesswork out of developing a trading strategy and provides all of the tools you need to forecast, prepare for, and take advantage of market trends and changes.

This authoritative guide is packed with expert...

Excel 2013: The Missing Manual

O'Reilly, 2013

The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your...