There's a good book called "SQL for Smarties" also. tks, Brian
-----Original Message----- From: John L. Waddell [mailto:[EMAIL PROTECTED]] Sent: April 19, 2002 2:20 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Updating counter values Its OUT OF PRINT at Chapters, and $10.49 at Amazon for the 2nd edition now 272 pages! apperently it street dates on Apr 26th - can't get newer than that! I've got the 200 page version - its a great resource. John. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of charles arehart Sent: Friday, April 19, 2002 2:01 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Updating counter values Indeed, I was going to recommend something that IS from Sams, but better still it's by good ol' Ben Forta himself: Teach Yourself SQL in 10 Minutes. Now, don't dismiss it because of the "10 minutes" moniker. It really is an excellent little book (and I mean little, perhaps 200 pages, available for about $11 US brand-spanking new). I can't imagine a better book for a CFer wanting to learn more SQL. And the best thing is that it's written to discuss SQL from the standpoint of a CF (or ASP/PHP/JSP) developer. Web apps are different than client/server and mainframe apps, and the slightly different flavor shows and is much appreciated. Indeed, I STRONGLY RECOMMEND that every CF developer get it and read it. Too many people rely solely on SELECT, INSERT, UPDATE, and DELETE. There's a whole world of things out there: aggregate functions, inner and outer joins (SO many thorny problems can be solved with an outer join), unions, nested queries, correlated sub queries. Now, don't let those last couple scare you. The great thing about Ben's book (a testament to both his and Sam's widely regarded approaches) is that he makes it all very easy to digest. You WILL learn these things and it won't take wading through some of the more tedious tomes out there. There are other classics, like Judith Helms' Practical SQL Handbook, which has indeed seen a new release last year, and the author of the classic "Database Design for Mere Mortals" came out with "SQL Queries for Mere Mortals". Heck, even the classic "ColdFusion Web Application Construction Kit" by Ben and others also has some substantial coverage not only of SQL but also DB design. That's another thing that CFers often pay scant attention to. We could all stand to learn more SQL. Indeed, I plan to put together a one-day seminar on the topic, again focusing on the things that would add measurably to a CFer's arsenal of weapons. If I ever offer it up in the Great White North, I'll let you guys know. Indeed, if any of you want to drop me a line **off-list** expressing your interest, feel free. This last offer was an afterthought to the previous part of the message--not a bait and switch! :-) /charlie > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of [EMAIL PROTECTED] > Sent: Friday, April 19, 2002 9:53 AM > To: [EMAIL PROTECTED] > Subject: RE: [CFTALKTor] Updating counter values > > > Not sure what they have in the way of an sql book, but, I like the SAMS > books. They normally have titles like, Teach Yourself Something in 21 > Days. > > I bought the ones for Access 97 and Javascript. > > *************************************** > Good advice. I'll be hitting the book store. Anyone have any > recommendations for an SQL book for newbies? > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: [EMAIL PROTECTED] > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charles arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "John L. Waddell" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Brian Grant <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
