Head First SQL: Your Brain on SQL -- A Learner's Guide

I like this book on just about every level. First of all, I'm not a Head First fan boy: they've laid a few eggs in some of their language/computing titles, and while I generally like the approach to learning they take, the content varies. That said, I am a big fan of this book. It provides a solid introduction to SQL from beginning to advanced concepts. I happen to use it with PHP, but it would fit equally well with SQL in other languages like ASP.NET/C# and PERL. SQL is not very big as languages go, but there's more than meets the eye to this language. Most importantly, Lynn Beighley takes the time to go through some key table-building concepts such as 'atomic data' and 'normal tables.' Further, she goes into great detail about creating and using relational data bases from setting up FOREIGN keys to using JOINs in data queries. She spends plenty of time with the CREATE statement in different contexts. Most SQL books, act as though you use tools like Visual Studio or MyPHPAdmin for creating tables, and so they do not 'waste time' with the CREATE statement for different types of tables. There's a problem in not visiting and revisiting CREATE when dealing with relational database management systems (RDBMS)--you don't understand the data and data types and hooks quite as well. Also, using CREATE, you can go from one tool to another without having to learn the protocol for each tool in the same or different language context. Her material on queries and sub-queries is in depth and the examples are sensible for the materials. While it's important to have some fun with the database examples in the HF series, it's also important to have examples that make sense, and hers do both. Likewise, her materials on ALTER are complete and helpful. Through all of these, she provides several SELECT examples and the many clauses (statements) that can be used with SELECT. Her chapter on security is quite good as well for an introduction to SQL capabilities in that area. I found only a couple of things I'd like to see changed. First, after some introductory INSERT examples, she seems to drop them as relevant further on in the book. Further INSERT examples would be quite helpful in the chapters on ALTER and with multiple tables. The multiple CREATE examples are golden, and if she'd do that with INSERT, it'd be most helpful. Second, at the very end of the book, she includes a 2-minute example of using PHP with MySQL. Yikes; she uses mysql instead of mysqli. Since at least 2004 when PHP 4.1.3 came out, the recommended PHP statement for MySQL work has been mysqli; not mysql -- the 'i' makes a big difference. Among other things, you can use a single statement to handle the connect information--url, username, password AND database name. Further, new terms like SERIAL are available in mysqli. Those two items would knock it down from a 5-star to a 4.5 star review, but I'd round up on this book any day.

In typical Head First style, this book is a hip trip down SQL lane, gently imparting concepts and techniques that stick to your brain. The book elegantly mixes the core concepts of writing SQL with solid principles of database design (with more than a dash of good humor). There are tons of exercises and examples, which help you to not only understand the language concepts being taught, but you get a good sense of good (and bad) database design at the same time. The author reasons that we often times are called upon to work with or fix bad a database design, so the book teaches you just that. And of course, you learn how to create a good design at the same time. What it is not: A comprehensive SQL reference. It is based mostly on MySQL as a database (the recommended tool to use for completing exercises for this book), and the book teaches techniques that might not work in other databases. I used Microsoft SQL Server 2005 for my exercises, and I spent a lot of time looking up how to get some functions to work; in some cases MS has a slightly different structure, but in some cases there is no comparable function in MS SQL (of course, the opposite can be said about MySQL as well - MySQL can't do everything some other databases can). However, in the end, this aided in my learning about SQL, as well as learning about the strengths and weaknesses of the various databases. If you are a seasoned DBA or a SQL guru, stay away...you are there already. But if you just starting out, you can't go wrong with this book.

If there is one book in head first that deserves attention (apart from Servlets book) it is this. All the programming books are great anyways (Exception is Head First Design patterns, PLEASE DONT BUY that one!). SQL Head first helps in visually knowing what is going to happen, especially when running mutltiple OUTER JOINs and writing subqueries etc. Thanks to this book (and a combination of SQL Cookbook and SQL Tuning (for more advanced people)). Here are some of positives of this book : 1.) Starts out at very basic level (this can be annoying for some folks, who already know much of the stuff, but then this book is not for you then, try SQL Cookbook or SQL Tuning). I would still say this book can be kept as a good reference, as even seasoned people can be helped from visually organized "notes" in there. 2.) Advanced Select section is awesome, JOINS and subqueries and Associations are explained very well. (In this case diagrams help in better visualizing things and helped me understand and recall the concepts really well, After a long time i am not trying to "remember" what the syntax of a clause is in SQL, instead i just visualize things (an example of this would be a sum(xxx) and a group by ... and how the diagram illustrates it very neatly, if i want to use a complex JOIN query or a multiple group by, i don't have to google anymore). Cons : 1.) Some of topics could have been covered in a better way, example tuning etc. 2.) is @ medium level, for advanced topics i still refer to SQL cookbook or tuning book (by Dan). All in all it was a great buy for me. Regards Vyas, Anirudh

I know SQL now

I came from a finance/Accounting background and found myself working as a Data Analyst. So, I had an urgent need to learn all about relational databases and manipulation of data using SQL. I initially attended a two day course on SQL and came back with an information overload and some nice looking PowerPoint sheets....learned nothing. I discovered this book on Amazon and I also bought a kindle version, Which is fantastic, as it suits my extremely busy days. I have it on my tablet and iPhone and I am able to read/learn every chance I get ...on the trains and even at lunch time at work. I am finding this book so easy to read and I just keep learning ... The animations are so good as it helps me remember the main point. I particularly love the "there are no dumb questions" bits, because it always nearly gets my thoughts exactly and clarifies issues the learner may be quizzed about! The bit about NULLs is so good that I have never understood why a null is not just a blank or a space...until now.its solo funny bcos the NULL says "I have got values to be". How can u ever forget what youbhave learned when it is taught to you in Jokes???. I am only on chapter 5 out of 12... but I am already writing T-SQL queries on Microsoft SQL server,even though the language of the book is MySQL ( ...yes it is that good, that I am able to adapt whet I have learned to another RDBMS...) Yes people have said it is good for beginners... But yes even as a pro... It will be a good refresher/ reference book!!! I am definitely going to keep mine! Thank you Lynn... Great job!!!👍👍👍 PS:: Do u know any VBA? I could do with a headfirst book on VBA too... all the ones I have seen so far are too tetchy and boring😁😁😁

Good for understanding SQL. They could have achived the same result with half of the paper they used to write the book.

The book is amazing for people who want to get into database management or data science. The visuals and the examples help a lot. I've been a fan of the head first series of books because of different exercises inside. I got a used version of this book from webuybooks here on Amazon and it's as good as new. It also arrived a week and a half before it was supposed to.

Nunca compréis este libro. Es imposible leerlo en Kindle. Voy a ver si consigo que me devuelvan el dinero.... Deberia darles vergüenza vender esto