aspose file tools*
The moose likes JDBC and the fly likes Head First SQL - Level and scope of the book ? 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 - Level and scope of the book ?" Watch "Head First SQL - Level and scope of the book ?" New topic
Author

Head First SQL - Level and scope of the book ?

Rohan Dhruva
Ranch Hand

Joined: May 08, 2007
Posts: 183
Hi authors,

I'm completely new to SQL. I've not had any experience before, with any DB.
Hence I was wondering - this book is for people who already know SQL, or begins from ground up ?

Also, what database does it use to teach SQL ? I heard that different databases (e.g. Oracle, MySQL, PostgreSQL) implement SQL a bit differently.

Finally, does this book teach using SQL database backed websites ?

Thanks,
Rohan.


Rohan B. Dhruva
SCJP 1.5
Chai Chamsai
Ranch Hand

Joined: Sep 04, 2006
Posts: 37
Hi I'm not author
but i see sample of HF SQL from O'reilly site.
The book have 12 topics cover basic SQL such as select,update,delete statement,
(smart)database design , advance SQL such as joins , subquery and the last topic security.
I see MySQL used to example in book.

I hope all my post in this reply is correct.
[ October 15, 2007: Message edited by: Chai Chamsai ]

SCJP 1.4<br />SCWCD 1.4<br /> <br />My native language isn't English ,I'm sorry if my post is incorrect grammar(or more)
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9383
    
    2

This book for sure will strengthen your SQL skills. Later you can pick up any advanced SQL book to hone your skills further if you are a DB guy.


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!
Lynn Beighley
author
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
Chai is basically correct. Most of the code is not MySQL, however, but SQL. And with few exceptions it will work on most SQL flavors.

This book is for someone who wants to learn the SQL side of things to design better tables and understand important and difficult database topics. You would want to get an additional book to help you connect your database to a web site, but if you do read this book, you'll design a GREAT database, which will make all your complex queries much easier.


Lynn Beighley<br />Author, Head First SQL
Rohan Dhruva
Ranch Hand

Joined: May 08, 2007
Posts: 183
Ah, thank you Lynn. That still leaves one more question -

Would this book be good for me if I have no prior experience at all, with databases and SQL ?

Thanks
Lynn Beighley
author
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
YES!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Head First SQL - Level and scope of the book ?