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 - Level and scope of the book ?

 
Rohan Dhruva
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Chai Chamsai
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Lynn Beighley
author
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Rohan Dhruva
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
YES!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic