Thread: [Fwd: SQL book]
I am looking to purchase a SQL book to use with our postgresql database. Can anyone recommend a good one?<br /> Thanks<br/> Jodi<br /><div class="moz-signature">-- <br /></div><div class="Section1"><p class="MsoNormal"><i><span style="font-size:9pt; font-family: Arial; "> _______________________________<br /></span></i><i><span style="font-size: 10pt;">Jodi L Kanter<br /> BioInformatics Database Administrator<br /> University of Virginia<br /> (434) 924-2846<br /><ahref="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a> </span></i><span style="font-size: 11pt; font-family: Arial;"><br style="mso-special-character:line-break" /><br style="mso-special-character:line-break" /></span><p class="MsoNormal"><spanstyle="font-size: 11pt; font-family: Arial; "> </span><p class="MsoNormal"><i><span style="font-size:9pt; font-family: Arial; "> </span></i><p class="MsoNormal"><i><span style="font-size: 9pt; font-family:Arial; "> </span></i><br /><div class="moz-signature">-- <br /></div></div><div class="Section1"><p class="MsoNormal"><i><spanstyle="font-size: 9pt; font-family: Arial; "> _______________________________<br /></span></i><i><spanstyle="font-size: 10pt; ">Jodi L Kanter<br /> BioInformatics Database Administrator<br /> Universityof Virginia<br /> (434) 924-2846<br /><a href="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a> </span></i><spanstyle="font-size: 11pt; font-family: Arial; "><br style="mso-special-character:line-break" /><br style="mso-special-character:line-break"/></span><p class="MsoNormal"><span style="font-size: 11pt; font-family: Arial; "> </span><p class="MsoNormal"><i><span style="font-size: 9pt; font-family: Arial; "> </span></i><p class="MsoNormal"><i><spanstyle="font-size: 9pt; font-family: Arial; "> </span></i></div><p class="MsoNormal"><i><span style="font-size:9pt; font-family: Arial; "></span></i>
On Tue, 27 May 2003, Jodi Kanter wrote: > I am looking to purchase a SQL book to use with our postgresql database. > Can anyone recommend a good one? > Thanks > Jodi Hi Jodi, I use SQL In A Nutshell as I have to switch gears between Oracle, Postgres and MySQL. Also I have limited time for reading and am a very cheap guy. It goes for $30 US. RE: perl. Paul DuBois has a great book called MySQL and Perl for the Web. Just modify the queries for Pg and you have a terrific example of how to code via DBI. Besides which it goes for $20 US on Amazon (orig $45 US). If you like I can mail you the tarball of Paul's src. I have it here at work. Paul also has a downloadable archive of all the scripts in the book. Lastly, he is a member of the Perl DBI mailing list which is a valuable resource as Tim Bunce reads all the mail that goes by and occasionally jumps in. (He wrote both DBI and DBD-Oracle). Cheers ----------------------------------------------------------------------- Thomas Good e-mail: tomg@sqlclinic.net Programmer/Analyst phone: (+1) 718.818.5528 Residential Services fax: (+1) 718.818.5056 Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359 // Das ist die Kunst - wie man alles verhunzt.
Jodi, > I am looking to purchase a SQL book to use with our postgresql database. > Can anyone recommend a good one? See: http://techdocs.postgresql.org/techdocs/bookreviews.php (HEY EVERYONE ELSE: I could use some more book reviews. It's 100 words, it's not hard ... e-mail me!) -- Josh Berkus Aglio Database Solutions San Francisco
Thomas, > I use SQL In A Nutshell as I have to switch gears between Oracle, Postgres > and MySQL. Also I have limited time for reading and am a very cheap guy. > It goes for $30 US. FYI, as I mention in my review, I found that SQL in a Nutshell omits several important SQL commands. But it does give you a good general syntax comparison. Jodi, SQL in a Nutshell is a reference for people who already know SQL ... not a primer. -- Josh Berkus Aglio Database Solutions San Francisco
Jodi, get some of Joe Celco books for me they where extreemly usefull. Ries