This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Rust Web Development and have Bastian Gruber on-line!
See this thread for details.
Win a copy of Rust Web Development this week in the Other Languages forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

Head First SQL - Level and scope of the book ?

 
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 10198
3
Mac PPC Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
author
Posts: 82
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 82
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
YES!
reply
    Bookmark Topic Watch Topic
  • New Topic