The Database Knowledgebase on the Web






General topics 


Database Wisdom: SQL


Copyright Notice


© Copyright 2009 Lewis R Cunningham All Rights Reserved.

All trademarks and service marks contained within this publication are the properties of their respective owners.

The material in this publication (print and electronic) is protected under International and Federal Copyright Laws and Treaties, and as such, any unauthorized reprint or use of this material is strictly prohibited.

The material in this online publication can be stored only on one computer at one time. You may not copy, forward, or transfer this publication or any part of it, whether in electronic or printed form, to another person or entity.

Reproduction or translation of any part of this work without the permission of the copyright holder is against the law.

You Do Not Have Resale Or Giveaway Rights To The Electronic Version Of This Book

Print Edition Published by CreateSpace, Scotts Valley, CA - USA
Print Edition ISBN:   1440464111
Print Edition EAN-13: 9781440464119


Chapter 1: Preface

About this Book

The idea of doing this book came about from the confluence of several things.  I already had one traditionally published book and did not really enjoy the experience.  I am frequently asked to recommend a book for those new to databases looking to learn the basics.  Finally, I think traditional books contain too much fluff and are too expensive.  

My goal with this book is to get a no nonsense reference for new SQL users out to market quickly and for a reasonable price.  With electronic delivery and Print On Demand (POD) publishing, the technology is there to accomplish the speed and price I am looking for.

I sat down and wrote an outline of what I would want to see in a SQL starter book.  That outline gave me my title and the contents you will find below.


There aren't too many conventions in the following book.  I tried to keep keywords in upper case when writing code.

Code looks like this.

Notes and other pertinent information looks like this.

If you are reading this book electronically, the links are live.  You can click through and get to the web site referenced.

About the Author

With over 20 years of multi-vendor and open source database experience as a database developer, data modeler and architect, over 15 years of that using the Oracledatabase, Lewis Cunningham is one of a small group of people chosen to be an OracleAceDirector.  

As an ACEDirector, Lewis is expected to provide feedback to Oracleand to promote Oraclevia user groups and conferences.  Lewis has published numerous papers and maintains a very popular blog, An Expert's Guide to OracleTechnologyand a database tutorial site, Database Wisdom.

Lewis is a published author, having written the ultimate guide to the open source Postgresbased EnterpriseDB Advanced Server(since renamed PostgresPlus Advanced Server).  The book, EnterpriseDB: The Definitive Reference, was the first reference guide available for this open source database.

Lewis's specialties revolve around anything having to do with databases: data architecture, data modeling, data warehousing, business intelligence, open source databases, XML databases, replication and cloud computing.

Lewis is a Certified PL/SQLDeveloper and is a member of the OracleDeveloper Tools User Group(ODTUG), Independent OracleUser Group(IOUG), the Suncoast Oracleuser Group (SOUG) and the Association for Computing Machinery(ACM).

Contact: Lewis Cunningham

About us

Contact us

Support us

Authors, Share Your Book with Millions of Readers

Search Database Wisdom