Jonathan Gennick

Writer * Book Editor * Oracle DBA * SQL & PL/SQL Developer

Father * Husband * Son * Mountain Biker * EMT

Books Written

I've been blessed over the years with the opportunity to write and contribute to a number of books. Following is a list:

SQL Pocket Guide

SQL Pocket Guide. Jonathan Gennick. O'Reilly Media. 2004.

Oracle Regular Expressions Pocket Reference

Oracle Regular Expressions Pocket Reference. Jonathan Gennick & Peter Linsley. O'Reilly Media. 2003.

Oracle In A Nutshell

Oracle In A Nutshell. Rick Greenwald & David C. Kreines. O'Reilly Media. 2002. (Chapter 12 + some networking content)

Oracle PL/SQL Programming, Third Editon

Oracle PL/SQL Programming, Third Edition. Steven Feuerstein with Bill Pribyl. O'Reilly Media. 2002. (Chapters 4, 8, 9, 10, and 12)

Oracle SQL*Plus Pocket Reference, Second Edition

Oracle SQL*Plus Pocket Reference, Second Edition. Jonathan Gennick. O'Reilly Media. 2002.

Read of my struggles with Tourettes

Getting Personal: Stories of Life with Tourette Syndrome. edited by Michael DeFilippo. Second Chance Publishing. 2002. (Contributed my story)

It's a Tree Swift

Transact-SQL Cookbook. Ales Spetic & Jonathan Gennick. O'Reilly Media. 2002. Corrections

Oracle DBA Checklists Pocket Reference

Oracle DBA Checklists Pocket Reference. RevealNet (now part of Quest Software). O'Reilly Media. 2001. (Contributed Net8 content)

Oracle SQL*Loader: The Definitive Guide

Oracle SQL*Loader: The Definitive Guide. Jonathan Gennick & Sanjay Mishra. O'Reilly Media. 2001. Corrections

Oracle Net8 Configuration and Troubleshooting

Oracle Net8 Configuration and Troubleshooting. Hugo Toledo and Jonathan Gennick. O'Reilly Media. 2000. Corrections

Oracle SQL*Plus Pocket Reference

Oracle SQL*Plus Pocket Reference. Jonathan Gennick. O'Reilly Media. 2000. Corrections

Oracle8i DBA Bible

Oracle8i DBA Bible. Jonathan Gennick, Carol McCullough-Dieter, and Gerrit-Jan Linker. IDG Books Worldwide. 2000. Corrections FAQ

Teach Yourself PL/SQL in 21 Days, 2nd Edition

Teach Yourself PL/SQL in 21 Days, 2nd Edition. Jonathan Gennick and Tom Luers. SAMS Publishing. 1999. Corrections FAQ

SQL*Plus the Definitive Guide

Oracle SQL*Plus: The Definitive Guide. Jonathan Gennick. O'Reilly Media. 1999. Corrections FAQ

Teach Yourself PL/SQL in 21 Days

Teach Yourself PL/SQL in 21 Days. Tom Luers, Timothy Atwood, and Jonathan Gennick. SAMS Publishing. October 1997. Corrections FAQ

Translations

Some of my books have been translated into other languages. Publishers don't always let me know about such translations. Below are the ones that I do know about:

Japanese translation of Oracle SQL*Plus Pocket Reference

Oracle SQL*Plus Pocket Reference. Jonathan Gennick. Translated by QUIPU LLC.

Chinese cover of Teach Yourself PL/SQL , Second Edition

Teach Yourself PL/SQL in 21 Days. Second Edition. Chinese Translation. People's Posts and Telecommunications Publishing House. 2000.

Oracle SQL*Plus kurz & gut

Oracle SQL*Plus kurz & gut. Jonathan Gennick. Translated by Wolfgang Gabriel. O'Reilly Verlag GmbH & Co. KG. 2000.

Training Courses

If you've read this far, you might as well know that I once wrote three online courses about Oracle8 database administration for a now-defunct company called DigitalThink:

Books Edited

Following are books that I've edited over the years. I've likely missed a few books, but in the main the list is complete.
Expert Oracle Practices

Expert Oracle Practices. Members of The OakTable Network. 2010.

Beginning Oracle SQL

Beginning Oracle SQL. Lex de Haan, Daniel Fink, Tim Gorman, Inger Jørgensen, Karen Morton. 2009.

LEGO MINDSTORMS NXT 2.0

LEGO MINDSTORMS NXT 2.0: The King's Treasure. James Floyd Kelly. 2009.

Oracle SQL Recipes

Oracle SQL Recipes. Grant Allen, Bob Bryla, Darl Kuhn. 2009.

Beginning SQL Server 2008 Administration

Beginning SQL Server 2008 Administration. Robert E. Walters, Grant Fritchey, Carmen Taglienti. 2009.

Build Your Own CNC Machine

Build Your Own CNC Machine. Patrick Hood-Daniel, James Floyd Kelly. 2009.

Beginning T-SQL 2008

Beginning T-SQL 2008. Kathi Kellenberger. 2009.

Pro SQL Server 2008

Pro SQL Server 2008 Mirroring. Robert Davis, Ken Simmons. 2009.

Expert SQL Server 2008 Encryption

Expert SQL Server 2008 Encryption. Michael Coles, Rodney Landrum. 2009.

Pro SQL Server 2008 Administration

Pro SQL Server 2008 Administration. Ken Simmons, Sylvester Carstarphen. 2009.

Pro BizTalk 2009

Pro BizTalk 2009. George Dunphy, Sergei Moukhnitski, Harold Campos, Stephen Kaufman, Peter Kelcey, David Peterson. 2009.

Pro SQL Server 2008 Failover Clustering

Pro SQL Server 2008 Failover Clustering. Allan Hirt. 2009.

Secrets of the Oracle Database

Secrets of the Oracle Database. Norbert Debes. 2009.

Pro SQL Server 2008 Replication

Pro SQL Server 2008 Replication. Sujoy Paul. 2009.

Pro SQL Server 2008 Analytics

Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards. Brian Paulen, Jeff Finken. 2009.

SQL Server 2008 Query Performance Tuning Distilled

SQL Server 2008 Query Performance Tuning Distilled. Grant Fritchey, Sajal Dam. 2009.

Don't Spend a Dime

Don't Spend a Dime: The Path to Low-Cost Computing. James Floyd Kelly. 2009.

Beginning Oracle Database 11g Administration

Beginning Oracle Database 11g Administration. Iggy Fernandez. 2009.

Beginning Spatial with SQL Server 2008

Beginning Spatial with SQL Server 2008. Alastair Aitchison. 2009.

Cisco Routers for the Small Business

Cisco Routers for the Small Business. Jason C. Neumann. 2009.

Pro Full-Text Search in SQL Server 2008

Pro Full-Text Search in SQL Server 2008. Michael Coles with Hilary Cotter. 2008.

Expert Oracle Database 11g Administration

Expert Oracle Database 11g Administration. Sam Alapati. 2008.

Linux Recipes for Oracle DBAs

Linux Recipes for Oracle DBAs. Darl Kuhn, Charles Kim, Bernard Lopuz. 2008.

Beginning SQL Server 2008 Express for Developers

Beginning SQL Server 2008 Express for Developers. Robin Dewson. 2008.

Pro Oracle Application Express

Pro Oracle Application Express. John Edward Scott, Scott Spendolini. 2008.

Pro SQL Server 2008 Relational Database Design and Implementation

Pro SQL Server 2008 Relational Database Design and Implementation. Louis Davidson, with Kevin Kline, Scott Klein, Kurt Windisch. 2008.

Pro T-SQL 2008 Programmer's Guide

Pro T-SQL 2008 Programmer's Guide. Michael Coles. 2008.

Pro SQL Server 2008 Reporting Services

Pro SQL Server 2008 Reporting Services. Rodney Landrum, Shawn McGehee, Walter J. Voytek III. 2008.

Beginning DB2

Beginning DB2. Grant Allen. 2008.

Pro SQL Server 2008 Service Broker

Pro SQL Server 2008 Service Broker. Klaus Aschenbrenner. 2008.

SQL Server 2008 Transact-SQL Recipes

SQL Server 2008 Transact-SQL Recipes. Joseph Sack. 2008.

Beginning SQL Server 2008 for Developers

Beginning SQL Server 2008 for Developers. Robin Dewson. 2008.

Troubleshooting Oracle Performance

Troubleshooting Oracle Performance. Christian Antognini. 2008.

Pro SQL Server 2008 XML

Pro SQL Server 2008 XML. Michael Coles. 2008.

Accelerated SQL Server 2008

Accelerated SQL Server 2008. Robert E. Walters, Michael Coles, Fabio Ferracchiati, Robert Rae, Donald Farmer. 2008.

Visual Basic 2008 Recipes

Visual Basic 2008 Recipes. Todd Herman, Allen Jones, Matthew MacDonald, Rakesh Rajan. 2008.

Beginning SQL Queries

Beginning SQL Queries. Clare Churcher. 2008.

Pro SQL Server Disaster Recovery

Pro SQL Server Disaster Recovery. James Luetkehoelter. 2008.

Beginning PHP and MySQL, 3rd Edition

Beginning PHP and MySQL, 3rd Edition. Jason Gilmore. 2008.

Oracle Database 11g New Features for DBAs and Developers

Oracle Database 11g New Features for DBAs and Developers. Sam Alapati, Charles Kim. 2007.

Pro Oracle Spatial for Oracle Database 11g

Pro Oracle Spatial for Oracle Database 11g. Ravi Kothuri, Albert Godfrind, Euro Beinat. 2007.

The Berkeley DB Book

The Berkeley DB Book. Himanshu Yadava. 2007.

Pro ASP.NET for SQL Server

Pro ASP.NET for SQL Server. Brennan Stehling. 2007.

Pro Active Record: Databases with Ruby and Rails

Pro Active Record: Databases with Ruby and Rails. Kevin Marshall, Chad Pytel, Jon Yurek. 2007.

Beginning PHP and Oracle

Beginning PHP and Oracle. Jason Gilmore, Bob Bryla. 2007.

Beginning PL/SQL

Beginning PL/SQL. Donald J. Bales. 2007.

RMAN Recipes for Oracle Database 11g

RMAN Recipes for Oracle Database 11g. Darl Kuhn, Sam Alapati, Arup Nanda. 2007.

Applied Mathematics for Database Professionals

Applied Mathematics for Database Professionals. Lex de Haan, Toon Koppelaars. 2007.

Forecasting Oracle Performance

Forecasting Oracle Performance. Craig Shallahamer. 2007.

Foundations of Security: What Every Programmer Needs to Know

Foundations of Security: What Every Programmer Needs to Know. Neil Daswani, Christoph Kern, Anita Kesavan. 2007.

Use Case Driven Object Modeling with UML

Use Case Driven Object Modeling with UML. Doug Rosenberg, Matt Stephens. 2007.

Beginning Database Design

Beginning Database Design. Clare Churcher. 2007.

Date on Database: Writings 2000-2006

Date on Database: Writings 2000-2006. C. J. Date. 2006.

Pro BizTalk 2006

Pro BizTalk 2006. George Dunphy, Ahmed Metwally. 2006.

SMS 2003 Recipes

SMS 2003 Recipes. Greg Ramsey, Warren Byle. 2006.

BizTalk 2006 Recipes

BizTalk 2006 Recipes. Mark Beckner, Benjamin Goeltz, Brandon Gross, Brannan O'Reilly, Stephen Roger, Mark Smith, Alexander West. 2006.

Windows Server 2003 Networking Recipes

Windows Server 2003 Networking Recipes. Robbie Allan, Laura E. Hunter. 2006.

The Definitive Guide to SQLite

The Definitive Guide to SQLite. Michael Owen. 2006. (Edited at O'Reilly before the book went to Apress).

The Art of SQL

The Art of SQL. Stéphane Faroult. 2006.

UML 2.0 Pocket Reference

UML 2.0 Pocket Reference. Dan Pilone. 2006.

C In A Nutshell

C In A Nutshell. Peter Prinz, Tony Crawford. 2005.

C In A Nutshell

C In A Nutshell. Peter Prinz, Tony Crawford. 2005.

SQL Cookbook

SQL Cookbook. Anthony Molinaro. 2005.

Practical Perforce

Practical Perforce. Laura Wingerd. 2005.

C++ Cookbook

C++ Cookbook. D. Ryan Stephens, Christopher Diggens, Jonathan Turkanis, Jeff Cogswell. 2005.

Twisted: Network Programming Essentials

Twisted: Network Programming Essentials. Abe Fettig. 2005.

Prefactoring

Prefactoring. Ken Pugh. 2005.

Learning SQL

Learning SQL. Alan Beaulieu. 2005.

UML 2.0 In A Nutshell

UML 2.0 In A Nutshell. Dan Pilone, with Neil Pitman. 2005.

Database In Depth

Database In Depth: Relational Theory for Practioners. C. J. Date. 2005.

Python Cookbook, 2nd Edition

Python Cookbook, 2nd Edition. Alex Martelli, Anna Martelli Ravenscroft, David Ascher. 2005.

Python Pocket Reference, 3rd

Python Pocket Reference, 3rd Edition. Peter Prinz, Tony Crawford. 2005.

Oracle Utilities Pocket Reference

Oracle Utilities Pocket Reference. Sanjay Mishra. 2004.

SQL In A Nutshell, 2nd Edition

SQL In A Nutshell, 2nd Edition. Kevin Kline, Daniel Kline, Brand Hunt. 2004.

Mastering Oracle SQL, 2nd Edition

Mastering Oracle SQL, 2nd Edition. Sanjay Mishra, Alan Beaulieu. 2004.

SpamAssassin

SpamAssassin. Alan Schwartz. 2004.

Mastering Oracle SQL, 2nd Edition

Mastering Oracle SQL, 2nd Edition. Sanjay Mishra & Alan Beaulieu. 2004.

SQL Tuning

SQL Tuning. Dan Tow. 2003.

STL Pocket Reference

STL Pocket Reference. Ray Lischner. 2003.

Optimizing Oracle Performance

Optimizing Oracle Performance. Cary Millsap. 2003.

Learning UML

Learning UML. Sinan Si Alhir. 2003.

Essential CVS

Essential CVS. Jennifer Vesperman. 2003.

UML Pocket Reference

UML Pocket Reference. Dan Pilone. 2003.

C++ In A Nutshell

C++ In A Nutshell. Ray Lischner. 2003.

C++ Pocket Reference

C++ Pocket Reference. Kyle Louden. 2003.

JDBC Pocket Reference

JDBC Pocket Reference. Donald Bales. 2003.

Objective-C Pocket Reference

Objective-C Pocket Reference. Andrew M. Duncan. 2002.

C Pocket Reference

C Pocket Reference. Peter Prinz, Ulla Kirch-Prinz. Translated by Tony Crawford. O'Reilly & Associates. 2002.

Ant: The Definitive Guide

Ant: The Definitive Guide. Jesse E. Tilly, Eric M. Burke. O'Reilly & Associates. 2002.

Mastering Oracle SQL

Mastering Oracle SQL. Sanjay Mishra, Alan Beaulieu. O'Reilly & Associates. 2002.

Practical PostgreSQL

Practical PostgreSQL. John C. Worsley, Joshua D. Drake. O'Reilly & Associates. 2002.

Java Programming With Oracle JDBC

Java Programming With Oracle JDBC. Donald Bales. O'Reilly & Associates. 2001.

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference. Mark Gurry. O'Reilly & Associates. 2002.

Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference. Darl Kuhn and Scott Schulze. O'Reilly & Associates. 2001.

Java Programming With Oracle SQLJ

Java Programming With Oracle SQL. Jason Price. O'Reilly & Associates. 2001.

Oracle DBA Checklists

Oracle DBA Checklists. Quest Software. O'Reilly & Associates. 2001.

Unix for Oracle DBAs Pocket Reference

Unix for Oracle DBAs Pocket Reference. Donald K. Burleson. O'Reilly & Associates. 2001.

Oracle SQL: The Essential Reference

Oracle SQL: The Essential Reference. David C. Kreines. Forward by Ken Jacobs. O'Reilly & Associates. 2000. (Tech reviewed some, contributed two chapters, helped edit the others).

Cover image of Oracle Parallel Processing

Oracle Parallel Processing. Tushar Mahapatra and Sanjay Mishra. O'Reilly & Associates. 2000.

Cover image of Teach Yourself Access 2000 in 24 Hours

Teach Yourself Access 2000 in 24 Hours. Craig Eddy and Timothy Buchanan. SAMS Publishing. 1999. (My first project as a development editor).

Technical Review Credits

The books in the list below are those for which I've done specific technical review work, and only technical review work, at the request of the publisher. Sometimes I review an entire book; other times only specific parts of a book that fall into my areas of domain expertise.

Oracle PL/SQL Pocket Reference, 3rd Edition

Oracle PL/SQL Language Pocket Reference. Steven Feuerstein, Bill Pribyl & Chip Dawes. O'Reilly Media. 2004.

Oracle Essentials: Oracle Database 10g

Oracle Essentials: Oracle Database 10g. Rick Greenwald, Robert Stackowiak & Jonathan Stern. O'Reilly Media. 2004.

Oracle Data Dictionary Pocket Reference

Oracle Data Dictionary Pocket Reference. David C. Kreines. O'Reilly Media. 2003.

SQL in a Nutshell

SQL in a Nutshell. Kevin Kline with Daniel Kline. O'Reilly Media. 2000.

Oracle Essentials

Oracle Essentials: Oracle8 & Oracle8i. Rick Greenwald, Robert Stackowiak, and Jonathan Stern. O'Reilly Media. 1999.

Oracle8i Internal Services for Waits, Latches, Locks, and Memor

Oracle8i Internal Services for Waits, Latches, Locks, and Memory. Steve Adams. O'Reilly Media. 1999.

Oracle Database Administration: The Essential Reference

Oracle Database Administration: The Essential Reference. Dave Kreines and Brian Laskey. O'Reilly Media. 1999.

Oracle8 Server Unleashed

Oracle8 Server Unleashed. Joe Greene, Advanced Information Systems, Inc., et al. SAMS Publishing. 1998.