Head First SQL

Before I talk about Head First SQL, let me tell you about other database books I have used in the classroom. I teach an enterprise databases sequence (DBs I and II) at a tribal college in Montana. On the course evaluations for this sequence, students have a common complaint: "Liked the class. Hated the book.", "The book was painful to read.", "Please get a different book!" Each year my colleagues and I are on the watch for a better, more engaging database book. We have tried three books over the past five years, but the difference between those books is like the difference between shades of grey. In the classroom, most of my time is spent mediating the daunting abstractness of those books or breaking down huge lumps of difficult technical material written in plodding and pedantic prose. This year a spot of color showed up: Head First SQL! I discovered Head First SQL too late to use it as the primary text for my Fall quarter DBs class, but I liked it so much, I added it as an optional textbook for the quarter and told my students it would be the main textbook for the Winter quarter. I did so because the energy of the class was waning rapidly, and the book I had originally chosen was not helping. I needed to add some excitement to homework and lectures. Within two days of using Head First SQL, the classroom became a far more engaging environment. I compiled this list for anyone interested in learning databases and SQL, especially anyone who teaches it. Eleven Things I like about Head First SQL: 1. The book starts where my students start. The first questions my students have are questions of relevance: Why do I want to know this? What have I done before that's like this? What will this material add to my career and my life? Head First SQL starts by ushering the student through those questions: What is a database? Who cares about databases? What will a database do for me? 2. My students are able to read SQL, think SQL, and write SQL after the first chapter. Head First SQL starts students on the command-line, the same command-line professional database administrators use during 80-95% of their workday. My students start out with good command-line habits like using a DESCRIBE statement to view database structure and columns before writing a SELECT statement that references those columns. 3. The book invites my students to make mistakes and anticipates the most common mistakes I see students make. On quizzes, students who've dug into the book don't make those mistakes again. 4. The book's sequence of topics fits the way I teach and the way my students learn: queries come before design and theory. Head First SQL does not set out to be a comprehensive database design book, but it does an excellent job of immersing the learner in the critical thinking that goes into database design and table design strategy. I applaud Lynn Beighley and the Head First Team. They have laid an excellent foundation for the learner to smoothly transition in

I haven't met a Head First/Head Rush title I didn't like, and this one is no exception... Head First SQL: Your Brain on SQL -- A Learner's Guide by Lynn Beighley. It's perfect for someone diving into the world of relational databases for the first time, as well as those who don't do it often enough to feel comfortable with things like normalized forms and outer joins. And along the way, you'll have plenty of fun picking up the skills you lack/need to reinforce. Contents: Intro; Data and Tables - A Place for Everything; The SELECT Statement - Gifted Data Retrieval; DELETE and UPDATE - A Change Will Do You Good; Smart Table Design - Why Be Normal?; ALTER - Rewriting the Past; Advanced SELECT - Seeing Your Data With New Eyes; Multi-table Database Design - Outgrowing Your Table; Joins and Multi-table Operations - Can't We All Just Get Along?; Subqueries - Queries Within Queries; Outer Joins, Self Joins, and Unions - New Maneuvers; Constraints, Views, and Transactions - Too Many Cooks Spoil The Database; Security - Protecting Your Assets; The Top Ten Topics (We Didn't Cover); Try It Out For Yourself; All Your New SQL Tools As with all Head First titles, Head First SQL sets out to engage all your senses during the learning process. Unusual diagrams, questions, exercises, and off-beat pictures are just some of the ways that the author works to grab your attention and force you down the path of learning (whether it feels like you're going down that path or not). The mixture of these techniques means that your mind doesn't really have a chance to drift off and start thinking about what you're going to have for dinner. It's this style that makes the Head First series the first one I'll recommend to people setting out to learn a new skill. For those who are wondering, Head First SQL uses the free MySQL package for all the examples and exercises. It's not necessary to have some expensive relational database system already installed on your PC. So even if your SQL learning efforts are self-funded, the total outlay will pretty much be the cost of the book, and that's it. And given that SQL is a standard query language, much of what you learn will also transfer over to any other relational database system you end up using down the road, like Oracle or DB2. Since I've done some SQL in the past, I found most of the value for myself located in the later chapters. Working with subqueries and more complex joins aren't things I do on a regular basis, so it's easy for me to forget the concepts. But a quick flip here, and it all starts coming back, much clearer than before. There's a reason I rarely loan out my Head First titles... they often don't come back. This will be added to that lock-and-key section of my bookshelf that requires DNA samples before they leave the premises. :)

This book takes a not-too-difficult but oh-so-dry subject and actually makes it interesting. The Head First series has tackled subjects in a similar fashion - Java, HTML, and design patterns, for example. However, being the geek that I am I actually find these subjects interesting, but just needed some books where I could brush up quickly and easily. The subject of databases and SQL, however, is a subject where the reading material can easily made into a cure for insomnia. Not so in this case. The author gets this problem. In fact chapter one actually has as a goal "How do you trick your brain into thinking that your life actually depends on SQL?". The book is not just about writing new databases, but about maintaining and changing old ones. It also talks about working with multiple tables and how to connect those tables with diagrams that will stick with you. It shows you how to do this in a manner that is interesting with the series' usual crossword puzzles, fake interviews and conversations, and Q & A sessions. Even if you think you know SQL, I can't think of a better book for brushing up if you've been away from the subject for awhile. This is true not only because the book covers all of the basics and even some more advanced topics, but because if you need to get up to speed in a short period of time this is one of the few books on the subject that will not put you to sleep.

This book, like the others in the series, is an impressive piece of work. SQL can be pretty dry, so spicing it up in using the Head First motif definitely pays off. Even though I gave it 5 stars, I sometimes thought too many pages were spent (wasted?) injecting humor into the learning process. Simply stating facts is not necessarily a bad way to teach soemthing. O'Reilly's "Learning SQL" by Alan Beaulieu goes that route and does a wonderful job explaining SQL - and in far fewer pages. (Granted, Head First pages are anything but dense, so total page count can be misleading.) My only other gripe is that indexing - which I consider to be pretty darn important - was relegated to 1/2 page of text in the "Leftovers" section.

As a beginning/intermediate Ruby/Rails programmer I have been waiting for this book to fill in that big SQL hole in my knowledge base. Even though Rails abstracts much of the underlying SQL code through its ORM, Head First SQL answers many questions I had about SQL in an entertaining way. Before this book my SQL knowledge could be summed up in two lines. mysqladmin -uroot create abc_development and localhost/phpmyadmin During a 24 hour marathon session with lots of Red Bull and Coffee the book has switched on the big SQL light in my head now. For this Ruby/Rails programmer chapter 7 on Multi-Table Database Design, and chapter 12 on Security was worth the price of admission alone. The Author's implementation of the Head First style is entertaining enough to actually make Head First SQL an enjoyable thing to study rather than sitting on my shelf with the other 3 SQL books that I was hoping to learn through osmosis as they can be a bit dry. Any book on SQL whose style and content makes it possible for me to read and reread in the last 24 hours deserves 5 Stars.