Head First SQL - Queries

[Raghavan Muthu]

Hello Lynn,

I have a couple of queries regarding the HFSQL. Happened to read the review about it in the Head First Newsletter. It was great and amazing as usual. Pretty much the same standard of HF series!!

(*) Is it just for plain SQL queries alone? or any other advanced concepts like procedures, triggers etc., are covered to a certain extent atleast?

(*) Does the book cover a bit of database design as well? in the way we can conclude that this book is for just db users or designers/admin!

(*) How about the coverage of schema and system objects?

Thanks in advance!

[Joe San]

As far as I know, the book promises to deliver the core concepts of using SQL queries. It also covers an in depth explanation on joins.

The book is mainly intended to strengthen our basic SQL skills. One example to this would be the ALTER table queries that I encountered in chapter 5. I remember using ALTER queries before but most of the time I look to some reference to get the query right. Now after reading that Dataville for Alterations from the book, I'm sure that I'll never forget what ALTERATIONS I can do with my table.

[Raghavan Muthu]

wow.. that's great. Thank you Jothi.

[Lynn Beighley]

Jothi is correct. There's so much you really need to know about just the core concept, SQL, that there isn't room to cover other topics. We take the most important concepts and really go deep with them. That way, when you look at more advanced topics, or topics that are related to SQL, you understand the SQL portion of it, leaving you free to focus on the new information.

It's not easy trying to learn two or three technologies at the same time. I prefer learning one at a time. I feel that leads me to understanding the combination of technologies that much better.

[Raghavan Muthu]

Originally posted by Lynn Beighley:

It's not easy trying to learn two or three technologies at the same time. I prefer learning one at a time. I feel that leads me to understanding the combination of technologies that much better.

Well said. So kind of you Lynn.

Thank you!