Book suggestion for SQL 2005 n00b

jibbajabba

I was always interested in SQL (T-SQL in particular).

However, my knowledge is really limited to

1. Installing SQL 2005
2. Installing SQL 2005 in a mirror (witness, primary, secondary in domain setup)
3. Installing SQL 2005 MS Cluster
4. Basic Administrating : Such as network config, database creation / maintenance plans using GUI)

BUT: Thats pretty much it ..

Can someone suggest a good book which starts EASY on the topic ? The MCTS books are obviously way out of my league ...

I have pre-ordered this one :

http://www.amazon.co.uk/Beginning-T-SQL-Microsoft-Server-2005/dp/0470257032/ref=sr_1_6?ie=UTF8&s=books&qid=1218235944&sr=8-6

But not even sure if this one is the right one to start with ....

dynamik

If you just want to start with the basics, give this one a shot:
http://www.amazon.co.uk/Sams-Teach-Yourself-SQL-Days/dp/0672324512/ref=sr_1_10?ie=UTF8&s=books&qid=1218236752&sr=1-10

T-SQL is the variation of SQL that Microsoft uses, so you can start with any beginners SQL book and move on to that.

Daniel333

Honestly, I did the SQL in 10 minutes one, SQL Server 2005 for dummies and then the videos from www.vtc.com and never ran into anything I could not handle. (*knock on wood*) Then snag the Microsoft press and you would probably be just fine.

jibbajabba

dynamik wrote:

If you just want to start with the basics, give this one a shot:
http://www.amazon.co.uk/Sams-Teach-Yourself-SQL-Days/dp/0672324512/ref=sr_1_10?ie=UTF8&s=books&qid=1218236752&sr=1-10

T-SQL is the variation of SQL that Microsoft uses, so you can start with any beginners SQL book and move on to that.

ta

Daniel333 wrote:

Honestly, I did the SQL in 10 minutes one, SQL Server 2005 for dummies and then the videos from www.vtc.com and never ran into anything I could not handle. (*knock on wood*) Then snag the Microsoft press and you would probably be just fine.

He - didn't know that site .. thanks

brad-

I started off with the Beginning SQL Programmign linked in this thread:
http://www.techexams.net/forums/viewtopic.php?t=25657

It was a much better read than MS Press regarding SQL, but not SSMS/management. There are other suggestions there as well.

I wish I had had the money for a CBT Nugget.

jryantech

Head First has a series on SQL "Head First SQL" I'm not sure what it touches base on though. The Java and C# ones are awesome.

brad-

Also, if you're going to do the 431 exam, SSMS is really what you need to be familiar with.

As far as basic SQL commands and whatnot, the query designer will help you with most statements you need to do.

http://msdn.microsoft.com/en-us/asp.net/bb498194.aspx
That link has some beginnger type coding it. Hope that helps.