Review: SQL in a Nutshell, 3rd Edition

Authors: Kevin E. Kline, Daniel Kline, and Brand Hunt Format: Paperback, 591 pages Publisher: O'Reilly Media, Inc.; 3rd edition (December 2, 2008) ISBN-10: 0596518846 ISBN-13: 978-0596518844 The original edition of this book was published the better part of a decade ago and both the 1st and 2nd editions did fairly well in the reviews and on the market. What does this 3rd edition have to offer and who is it offering it to? The blurb on the back states that the "...new edition clearly documents every SQL command according to the latest ANSI standard and details how those commands are implemented in Microsoft SQL Server 2008, Oracle, 11g, MySQL 5.1, and PostgreSQL 8.3". Of course that was written by either one of the authors or the O'Reilly editorial staff, so you'd expect them to say such a thing. Assuming all this is true and you need to know the SQL commands relative to those products, then I guess you'll really want this book. As far as who this book is for, the front matter of the text targets a number of different groups including programmers looking for a quick SQL reference, developers needing to migrate from one SQL to another, and DBAs (who else?) who need to keep up with the latest and greatest. Keep in mind (and if you're familiar with the In a Nutshell series, you won't need this reminder) that this series is strictly a reference guide, not a tutorial. If you need to learn how to work with the SQL language, this isn't the first place to start. The Kline, Kline, and Hunt book is, in essence, the "wiki" for the SQL language as interpreted by O'Reilly. Chapter 1: Long, long ago, in a Galaxy far, far away...but I digress. Anyway, like so many other books on so many other technical subjects, the book starts out with a brief history lesson, but fortunately, it's mercifully brief at a mere 15 pages. Depending on your needs, you can blow past this part and go directly to your destination, whatever it may be in the world of SQL. That's the beauty of a reference; you need read only what you are looking for...but thereby hangs a small tale...finding things. Maybe it's just that you can't search a hardcopy version of a book the way you can the web, but the indexing seems to continue to struggle, or rather, cause readers to struggle. If I'm looking for something specific in a reference text, the book is more valuable to me if I can find what I'm searching for quickly. The longer I have to look, the more "value added" becomes "value subtracted". If you don't intend on reading the book cover-to-cover (and it's not written to be used that way), then you'll likely have to use a combination of scanning the index, the TOC, and the relevant chapter or chapters to find whatever bit of data you need, depending on how obscure it is. That's really the only ding I can give the book though, and the authors did update the content with the present state of the techology in mind. There's actually two reasons to update such a book. The first I've already mentioned; to keep up with changes in the SQL language. The second is, since this reference is probably used often by those who need it most, to provide a fresh book to replace the dog eared copy you now likely have sitting by your keyboard. Who shouldn't buy this book, at least not yet? I previously mentioned this too, at least in part. The book isn't for someone who doesn't have a good handle on SQL. It's not a tutorial or an all-in-one learning book. If you need something like that, and you want to see what O'Reilly provides in that arena, try Learning SQL by Alan Beaulieu. It also seems to have done quite well, and once you've become at least adequate with the SQL language, revisit this book. You'll be ready for it then.

Review: The Manga Guide to Databases

Authors: Mana Takahashi (Author) and Shoko Azuma (Illustrator) Format: Paperback, 224 pages Publisher: No Starch Press; Ill edition (January 28, 2009) ISBN-10: 1593271905 ISBN-13: 978-1593271909 Even though I specifically requested this book from No Starch for review, I never really expected it to be a...comic book. OK, that's not quite right, as purists will no doubt remind me. Manga isn't quite the same thing as an American comic book, but it's close enough from my point of view. I rather had expected the book to work along the lines of O'Reilly's Head First series, where technical topics are presented in text but with lots of "hyperactive" photos, graphics, arrows, and the like. The Databases book is presented as a straight manga publication and was originally published as part of a Manga Guide series in Japan in 2004. To clarify my perceptions, I actually emailed Bill Pollock at No Starch to get a clearer understanding of how this book and book series is supposed to work. Once Bill straightened me out, I was ready to proceed. Like any other manga, this one tells a story, and the story has an underlying theme. Historically, "children's" entertainment in Japan has carried a moral or ethical message, with the main characters sometimes appearing to give small lessons in cooperation, listening to parents, and so on. This manga's message isn't a moral one so much as an educational one. The underlying message is what databases are, how they're designed and how they work. The book addresses the reader who has never been exposed to any information about databases before. In fact, the first chapter is "What is a Database?" Poor Princess Ruruna has quite a problem, you see. Her parents, the King and Queen, are away and have left her in charge of the kingdom's massive fruit selling business. Unfortunately, the system she's using to keep track of her data is woefully inadequate to the task. Enter Tico the Database Fairy. I know it sounds silly, at least the way I'm describing it, but that's how the story opens. Pretty much up until page 10, the tale is presented in a typical manga fashion. The "problem" in terms of why Princess Ruruna and the Kingdom of Kod (I don't make these names up) need a database, starts to become apparent on page 11. The actual lesson in Chapter 1 starts on page 16, and that's where the book becomes more like I had originally expected. The main characters are used as "props" or "actors" to present the lesson of the chapter, in this case, what the basic problem is and how a database can be applied to create a solution. There's a short summary at the end of the chapter, then it's on to "What is a Relational Database". Subsequent chapters present a series of exercises after the main content with the answer key at the end, so this is very much a teaching book. But who does it teach and what can the students expect to learn? The intended audience (I checked, because it doesn't explicitly state this in the book's front matter) is likely high school and early university students (not exactly a shock, given the book's format). The book isn't a detailed text but rather a ground level introductory guide into the care and feeding of databases. You won't learn the SQL language, though there is a chapter in the book devoted to SQL. The idea of the book is to teach someone who knows nothing about what a database is and to give them a clue; a relatively detailed clue. The manga presentation will make it more appealing to a younger reader, or someone older who enjoys the novelty, to learn topics that can otherwise be pretty dry. If you are a "serious" student, you'll either think the book is frivolous or cute (or both), but will balk at being seen reading it in public. If you're the target audience, you won't give a rip and will probably brag about it. In fact, you're friends will probably think it's incredibly cool. Don't laugh (OK, laugh...there are funny bits in the book). This series is hugely popular in Japan, and No Starch is planning on marketing this as a series. While the books have already been authored in Japanese and been translated, No Starch is doing some re-translation and a technical review to verify that the content will really teach what it's supposed to. I mentioned the young and young-at-heart as far as the book's audience before, but it is suitable for the straight up adult who secretly likes manga and anime, and needs to get a primer on a topic that they may never have really understood before. Even people that manage databases for a living sometimes have a hard time explaining to the uninitiated exactly what a "relational database" is. Oh, this isn't just a textbook disguised as manga. Just for giggles, a bit of drama has been offered in the form of a romantic triangle. Not to worry. There's not too much "mushy stuff" there to get in the way of the book's main focus, but there is enough to keep it lightly entertaining. There is also a happy ending, which is to be expected. The book has a small appendix, which is unexpected, presenting "Frequently Used SQL Statements" as well as an index, so you can actually use it somewhat as a reference. Speaking of which, there is also a references page citing no less than nine sources, so the authors didn't whip this book up out of their heads. The primary author Mana Takahashi, is a university graduate and a technical writer on the subjects of Java, C, and XML (non-manga books), so she has the background to be authoritative. Back in the day, I used to collect comic books, though more in the vein of Spider-Man and Green Lantern, and when my kids were young, we watched the more popular anime series on Cartoon Network. I've even seen the occasional manga in my time, so I'm not completely unfamiliar with the art form. I've seen comic books, both mainstream and speciality publications, that have educated as well as entertained, but I must admit, I was taken a bit by surprise by this one. I don't know if it's really right for me, but I think it's right for the aforementioned young/young-at-heart audience, who has a need to understand the very basics of databases as concept and design. It won't do more than that, but it doesn't have to. There are plenty of books available that can carry on after this book's last page has been read. The book is written as a fantasy (Princesses, Kingdoms, Fairies), which isn't exactly what I'd go for, but it does the job it's supposed to do. Personally though, I would have preferred a few space ships, a couple of aliens, and some super-powered fight scenes. Even a couple of explosions would have been welcome. But that's just me, of course.