Several of the big expert books mentioned are well worth reading, but after all those massive reading efforts the only generic SQL book I keep at the ready is:
"Teach Yourself SQL in 10 Minutes" Publisher: SAMS. This tiny book moves real fast from simple to complex selects (including joins, subqueries and views) showing with crsip examples how to integrate things like wildcards, IN, NOT, OR, HAVING, and GROUP BY into a query and always stressing the logical order in which they should correctly appear. It is an excellent uncomplicated fast-read primer for the real beginner and like I said acts as instant refresher for a more advanced user too. Warmest regards, Peter Sawczynec Technology Dir. Sun-code Interactive Sun-code.com 646.316.3678 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael B Allen Sent: Saturday, November 03, 2007 11:18 PM To: NYPHP Talk Subject: Re: [nyphp-talk] Learning SQL - Resources & Recommendations On 11/1/07, Nelly Yusupova <[EMAIL PROTECTED]> wrote: > A friend of mine is trying to learn SQL and asked me for some resources to > point her in the right direction as far as understanding SQL, table-driven > designs, logic, etc. > > Does anyone have any recommendations? Hi Nelly, There is a book called "Oracle The Complete Reference" which is considered by many to be the best all-around database book. There are some Oracle specific bits in it but it's mostly applicable to just about any database. Mike -- Michael B Allen PHP Active Directory SPNEGO SSO http://www.ioplex.com/ _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php