Head First SQL

Cheio de erros técnicos. Uma pena pois a ideia do livro é boa, mas faltou revisão técnica.

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.

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😁😁😁

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.