Jonathan Gennick eBooks

Download free Jonathan Gennick eBooks

SQL Pocket Guide

3rd Edition

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...

Oracle SQL*Plus

The Definitive Guide

2nd Edition

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly:write and execute script files generate ad hoc reports extract d...

Oracle SQL*Loader

The Definitive Guide

SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQLLoader: The Definitive Guide has everything you need to know to put SQLLoader to...