| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Looking for an intro-to-SQL book which is PostgreSQL-friendly |
| Date: | 2011-09-03 00:18:52 |
| Message-ID: | alpine.LNX.2.00.1109021712470.25002@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2 Sep 2011, Josh Berkus wrote:
> I'm looking for an intro-to-SQL book for teaching a class, one aimed at
> folks who know *nothing* about RDBMSes, which is not based on MySQL or
> MSAccess. The ones I have on my desk are all based on one or the other,
> except The Manga Guide to Databases, which I can't use in a serious class.
> Does anyone have other suggestions?
Josh,
I have two suggestions for your intended audience:
Rick F. van der Lans' "Introduction to SQL, 4th Ed." (or newer if there is
one.) This book is the best introduction to pure SQL out there. It also
deals extensively with dates, upon which most business and scientific data
depend. Very highly recommended. It was recommended to me for the date
sections by Joe Celko. I also proof-read Rick's "SQL for SQLite" so I am
partial to the way he explains the language.
Joe Celko's "SQL Programming Style". This book focuses mostly on DDL and
helps the newcomer to SQL transition from procedural languages, files, and
records. His suggestions are based on SQL92 (or 99, I forget which) and are
implementation agnostic. Also very highly recommended.
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2011-09-03 02:08:08 | Re: How can I merge two tables? |
| Previous Message | Josh Berkus | 2011-09-02 23:48:45 | Looking for an intro-to-SQL book which is PostgreSQL-friendly |