Please Recommend a SQL Book

[thefish8]

I have to learn SQL for my job and would like a book recommendation for a begginer like me. It has to talk about SQL Server 2000. Thanks for anyone who helps.

 

[Mitzi]

The only SQL book I use is O'Reilly SQL in a nutshell - it covers Oracle, mySQL, PostgreSQL and SQL Server. Its not really a n00bie book but makes an excellent reference.

 

[MrMilney]

Take a look at SQL Visual Quickstart Guide.

Because author Chris Fehily assumes no prior programming experience on your part (just a familiarity with your OS's file system), he spends the first few chapters laying out the basics, including clear explanations of the relational database model and SQL syntax. Then he jumps into step-by-step tasks designed to get you comfortable using SQL right away. You'll learn how to use SQL's most popular statements and commands to maintain, retrieve, and analyze database information, and to create and edit database objects. Each visually oriented task features the actual code and plenty of screen shots to keep you on track. Fehily takes a software-independent approach to teaching SQL, but includes tips for specific database software. You may not be a programming expert, but with SQL: VQS, who will be able to tell?

 

[M0NEYSH0T]

Just an FYI....

Oreilly books are REALLY good for people that know the language and that are just looking for quick assistance.

SQL Visual looks like a good book for learners such as yourself. Keep that in mind if you're looking for books for other languages - Oreilly is sweet, but most of their books assume you already know what's goin on...

 

[jonmullen]

Honestly SQL is such a stait forward language I think you will ba able to find all you need easily on the web. I mean heck there are only four man commands. Now when you start getting in to more database specific stuff, a book may help. Like for stored procedures and what not. The most important thing in my mind about database development is haveing a good understanding of database theory and setting it up correctly.

 

[Mitzi]

Originally posted by: jonmullen
Honestly SQL is such a stait forward language I think you will ba able to find all you need easily on the web. I mean heck there are only four man commands. Now when you start getting in to more database specific stuff, a book may help. Like for stored procedures and what not. The most important thing in my mind about database development is haveing a good understanding of database theory and setting it up correctly.

Err....those four main commands have A LOT of options, hence why I recommended a reference guide only

 

[tkdkid]

Do you need to learn SQL (structured query language -- like to pull data from a database), or do you need to learn about administering SQL Server (a database engine -- to create and update tables)?

 

[jonmullen]

Originally posted by: Mitzi

Originally posted by: jonmullen
Honestly SQL is such a stait forward language I think you will ba able to find all you need easily on the web. I mean heck there are only four man commands. Now when you start getting in to more database specific stuff, a book may help. Like for stored procedures and what not. The most important thing in my mind about database development is haveing a good understanding of database theory and setting it up correctly.

Err....those four main commands have A LOT of options, hence why I recommended a reference guide only

Yah...I know I guess I just find it a pretty intuitive...and whenever I cant do something its easy to find the option with a quick google search.