Book suggestion for SQL 2005 n00b

jibbajabbajibbajabba Member Posts: 4,317 ■■■■■■■■□□
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 ....
My own knowledge base made public: http://open902.com :p

Comments

  • dynamikdynamik Banned Posts: 12,312 ■■■■■■■■■□
    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.
  • Daniel333Daniel333 Member Posts: 2,077 ■■■■■■□□□□
    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.
    -Daniel
  • jibbajabbajibbajabba Member Posts: 4,317 ■■■■■■■■□□
    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 :)
    My own knowledge base made public: http://open902.com :p
  • brad-brad- Member Posts: 1,218
    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.
  • jryantechjryantech Member Posts: 623
    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.
    "It's Microsoft versus mankind with Microsoft having only a slight lead."
    -Larry Ellison, CEO, Oracle

    Studying: SCJA
    Occupation: Information Systems Technician
  • brad-brad- Member Posts: 1,218
    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.
Sign In or Register to comment.