Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Head First SQL - Queries

 
Raghavan Muthu
Ranch Hand
Posts: 3381
Mac MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 3381
Mac MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
wow.. that's great. Thank you Jothi.
 
Lynn Beighley
author
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 3381
Mac MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic