YOUR FEEDBACK
James Nelson wrote: Thanks for the posting, which we are hoping will solve our software issue with t...
AJAXWorld RIA Conference
$300 Savings Expire August 29
Register Today and SAVE!


2008 East
DIAMOND SPONSOR:
Data Direct
Frontiers in Data Access: The Coming Wave in Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
Intel
Virtualization – Path to Predictive Enterprise
Green Hills
IT Security in a Hostile World
JBoss / freedom oss
Practical SOA Approach
GOLD SPONSORS:
Software AG
The Art & Science of SOA: How Governance Enables Adoption
PlateSpin
Effective Planning for Virtual Infrastructure Growth
Fujitsu
Automated Business Process Discovery & Virtualization Service
Ceedo
Workspace Virtualization
Click For 2007 West
Event Webcasts

2008 East
PLATINUM SPONSORS:
Appcelerator
Think Fast: Accelerate AJAX Development with Appcelerator
GOLD SPONSORS:
DreamFace Interactive
The Ultimate Framework for Creating Personalized Web 2.0 Mashups
ICEsoft
AJAX and Social Computing for the Enterprise
Kaazing
Enterprise Comet: Real–Time, Real–Time, or Real–Time Web 2.0?
Nexaweb
Now Playing: Desktop Apps in the Browser!
Sun
jMaki as an AJAX Mashup Framework
POWER PANELS:
The Business Value
of RIAs
What Lies Beyond AJAX?
KEYNOTES:
Douglas Crockford
Can We Fix the Web?
Anthony Franco
2008: The Year of the RIA
Click For 2007 Event Webcasts
SYS-CON.TV
TOP COLDFUSION LINKS


Sams Teach Yourself SQL in 10 Minutes
Sams Teach Yourself SQL in 10 Minutes

Who else is sick and tired of hearing Allaire's product evangelist, Ben Forta, touted as the CF god? Ben Forta this, Ben Forta that. All right already! So he and some other CF gurus wrote a couple books about CF and now we can't go anywhere in CF hyperspace without hearing about it.

Well, bad news for us. He's done it again. But this time in the related but separate arena of Structured Query Language (SQL). His Teach Yourself SQL in 10 Minutes is an excellent introductory book that also serves quite nicely as a pocket reference.

Before I go any further with this review and sing his praises, I have to disclose that I've worked with Ben on other projects. But don't think this makes me go goo-goo and starry-eyed in his presence. Quite the contrary - I'm actually one of his harshest critics. When I first picked up this book, it was with red pen in hand, ready as always to mark it up with corrections and comments. Unfortunately for my happy pen, this book is technically sound with only a few minor errors and the content is very well written. (In the near future you'll be able to find information about errors at www.forta.com/books/0672316641.)

Bad news first: this book is not designed as an advanced discussion of SQL. I was really looking forward to a book that could take my SQL knowledge to the next level. However, while Ben certainly touches on some advanced topics, such as stored procedures and triggers, people who already know SQL well or who've worked with it on a daily basis will probably find that it's more useful as a pocket reference rather than a learning tool.

Nevertheless, I still recommend that nonbeginners who don't have formal training with SQL read the book because, while the majority of it will probably be review, you may be able to fill in some gaps in your SQL knowledge. There are plenty of statements littered throughout the book that clarify SQL syntax and a fair number of gold nugget hints about best practices and SQL optimization.

This book also abounds with Notes, Tips and Cautions that help clarify points and try to keep you out of trouble. In one tip dealing with transaction processing, Ben states: "You cannot roll back CREATE or DROP operations. These statements may be used in a transaction block, but if you perform a rollback they will not be undone." While this may seem intuitive to some, it wasn't obvious to me and I was glad to see it emphasized.

The book begins with a great overview of SQL but doesn't become too lecture-driven. There's at least one example SQL statement on almost every page of the book, and associated scripts and database files that can be downloaded from the Web site (the URL listed earlier in this review). This allows those overachievers to try out each line of code for themselves. And for those of you who have to work with different RDBMSs, Ben also tries to point out syntax differences between SQL Server and Oracle when either differs from standard SQL.

Last but not least, the appendices (unlike many other books) also have some useful material. Besides the review of SQL data types, there's a list of frequently used statements and - my favorite - a list of SQL reserved words.

Try as I might, I found it difficult to be discontented with Teach Yourself SQL in 10 Minutes. It packs an extraordinary amount of information into a tiny package. Weighing in at 208 pages and about the size of half a piece of paper, it's amazing how much good, useful information it actually holds. While I'm still itching for more advanced, in-depth examples, I'm glad to have the book sitting on my reference shelf.

About Emily Kim
Emily Kim is one of the cofounders of Trilemetry, LLC and a certified Allaire trainer. She is also a contributing author of Mastering ColdFusion, and a technical and developmental editor on many computer books including the ColdFusion Web Application Construction Kit.

CFDJ LATEST STORIES . . .
Two of the biggest launches in Rich Internet Application history took place in 2007/2008 when Adobe launched AIR 1.0 in February '08 and Microsoft launched Silverlight (September '07). At the 6th International AJAXWorld RIA Conference & Expo in October SYS-CON Events is delighted to be...
Red Hat CTO Brian Stevens, Citrix CTO Simon Crosby, Egenera CTO Pete Manca, Allen Stewart, Group Manager, Windows Virtualization at Microsoft, and Brian Duckering, Sr. Director of Products and Alliances at Symantec were the top industry executives who joined Jeremy Geelan in the 4th Fl...
Mike Neil is general manager for virtualization strategy in the Windows Server Division at Microsoft. Mike is focused on the delivery of the Windows virtualization technology, including Windows Server 2008 Hyper-V, Microsoft Hyper-V Server and Virtual PC 2007. Mike also directs the tec...
SQL Injection attacks are one of the easiest ways to hack into a website. One recent hack, using a script from verynx.cn, involves injecting sql into a web form that then appends some JavaScript code into fields in a database that then gets executed on the client side when a user views...
Recursion Software released a private beta version of their Voyager mobile platform, with powerful interoperability for Android, Microsoft .NET and Compact Framework (CF), all Java editions (JME CDC, JSE and JEE), and more than 15 embedded operating systems. The Voyager platform is a p...
2008 is going to be an important year for Rich Internet Applications. Most organizations are delivering or planning to deliver Rich Internet Applications; however, at the same time, most IT managers are facing a dilemma: which Rich Internet Application technology and platform to use? T...
SUBSCRIBE TO THE WORLD'S MOST POWERFUL NEWSLETTERS
SUBSCRIBE TO OUR RSS FEEDS & GET YOUR SYS-CON NEWS LIVE!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON FEATURED WHITEPAPERS

ADS BY GOOGLE