Database Wisdom: SQL
© 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
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
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
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,
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
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).