All Shops

Go to British Wildlife

6 issues per year 84 pages per issue Subscription only

British Wildlife is the leading natural history magazine in the UK, providing essential reading for both enthusiast and professional naturalists and wildlife conservationists. Published six times a year, British Wildlife bridges the gap between popular writing and scientific literature through a combination of long-form articles, regular columns and reports, book reviews and letters.

Subscriptions from £25 per year

Conservation Land Management

4 issues per year 44 pages per issue Subscription only

Conservation Land Management (CLM) is a quarterly magazine that is widely regarded as essential reading for all who are involved in land management for nature conservation, across the British Isles. CLM includes long-form articles, events listings, publication reviews, new product information and updates, reports of conferences and letters.

Subscriptions from £18 per year
Academic & Professional Books  Reference  Data Analysis & Modelling  Computing for the Natural Sciences

SQL Pocket Guide

By: Jonathan Gennick(Author)
208 pages, black & white tables
SQL Pocket Guide
Click to have a closer look
Select version
  • SQL Pocket Guide ISBN: 9781449394097 Edition: 3 Paperback Dec 2010 Usually dispatched within 4 days
    £9.50
    #220892
Selected version: £9.50
About this book Customer reviews Biography Related titles

About this book

For programmers and database administrators who use SQL in their day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL. That includes the syntax for querying, managing transactions, and making changes to data, as well as SQL functions, type conversion functions and formats, and regular expression syntax.

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 for compatibility with Oracle
* MySQL features such as the TIMESTAMP type and the TO_SECONDS function

Customer Reviews

Biography

Jonathan Gennick is an O'Reilly Media, Inc. editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. 

By: Jonathan Gennick(Author)
208 pages, black & white tables
Current promotions
Best of Winter 2018Harper CollinsOrder your free copy of our 2018 equipment catalogueBritish Wildlife