GeeCON Prague 2014*
The moose likes JDBC and the fly likes Head First SQL - Queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Head First SQL - Queries" Watch "Head First SQL - Queries" New topic
Author

Head First SQL - Queries

Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3344

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!


Everything has got its own deadline including one's EGO!
[CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines]
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9398
    
    2

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.


SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3344

wow.. that's great. Thank you Jothi.
Lynn Beighley
author
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
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.


Lynn Beighley<br />Author, Head First SQL
Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3344

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!
 
Consider Paul's rocket mass heater.
 
subject: Head First SQL - Queries