Teach yourself SQL in 24 Hours

Author: Ryan Stephens, Ron Plew & Arie D. Jones
Publisher: Sams
Pages: 460
ISBN: 978-0672335419
Aimed at: Novices in SQL
Rating: 4
Pros:Good coverage of the ANSI standard with examples in real world SQL dialects
Cons: You might prefer a book aimed at the particular dialect you’ll be working with
Reviewed by: Kay Ewbank

A vendor-neutral approach to SQL. Does it work in practice?

 

Teach Yourself SQL in 24 hours follows the familiar pattern of 24 one hour long lessons, in this case to cover the whole of SQL. It’s worth pointing out that the book covers ANSI SQL with nods towards Oracle, Microsoft SQL Server and MySQL, so you’re going to learn the core of the language rather than the particular dialect of whatever database you’re working with. The writers get around this limitation by including short discussions on how the different implementations deal with particular problems. For example, when discussing auto-incrementing columns, you’re shown how MySQL deals with it, then how SQL Server does it, then how Oracle doesn’t let you do it directly. This vendor neutrality can actually be quite helpful, especially if you have to take code written for one dialect and work out how to do it in another.


Banner

 

The initial couple of chapters covering the generalities seemed to me to be the weakest in the book, and I wouldn’t want to try to understand data structures and database objects just from what’s covered here. If you don’t understand what a database is, this isn’t the book to use to learn. Instead, get the general concepts into place and skim read the opening chapters.

Once into the nitty gritty of SQL, the chapters are much stronger and generally clear and understandable. All the chapters include quizzes and exercises to check you’ve understood the concepts, along with points to watch out for, and interesting ‘by the way’ asides. In some ways the most useful information in the whole book is to be found in the Watch Out and By the Way boxouts, particularly in the more advanced chapters on complex queries and performance tuning.

The chapters on SQL start with simple queries and work up through subqueries, performance tuning, using SQL to manage users and security, and using views and the system catalog. The final part of the book looks at advanced SQL topics such as cursors, stored procedures and triggers, XML, and using SQL on the Internet and Intranet. The chapter on SQL and the Intranet seemed a bit theoretical but would be a useful pointer to the sort of things you might want to do; it wouldn’t be enough to let you build an app without finding out more.

To developers the basic commands of SQL will appear pretty trivial, and I think this book would be a good companion to get you up to speed on some of the more advanced topics. You won’t come out as a SQL expert, but you will know enough to make the SQL in your applications work, and work pretty well.

 

Banner


JavaScript: The Definitive Guide (6e)

Author: David Flanagan
Publisher: O'Reilly, 2011
Pages: 1100
ISBN: 978-0596805524
Aimed at: Experienced JavaScript programmers
Rating: 4.5
Pros: Comprehensive and authoritative
Cons: Unwieldy and not helpful to beginners
Reviewed by: Mike James

This is the classic work on JavaScript - indeed many readers c [ ... ]



3D Printing: Build Your Own 3D Printer and Print Your Own 3D Objects

Author:James Floyd Kelly
Publisher: Que
Pages: 192
ISBN: 978-0789752352
Audience: Newcomers to 3D printing
Rating: 3
Reviewer: Harry Fairhead

3D printing is still all the rage and there are lots of people who could be enticed to get involved. Is this a good place to start?


More Reviews

Last Updated ( Thursday, 08 September 2011 )
 
 

   
RSS feed of book reviews only
I Programmer Book Reviews
RSS feed of all content
I Programmer Book Reviews
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.