SQL SERVER Training on Advanced database administration

  • Hi,

    I am a Jr DBA and looking for a Online training website or link from where i can get Advance training on SQL SERVER Administration (Replication & Performance tunning)

    thanks

    Puneet

  • I don't know that there's any one place to get advanced training online (meaning for free). But there are several places you can go. Microsoft has a number of courses available. I'd definitely start with the source. You can also learn tons and tons just by reading the Books Online. It's a resource that few people use adequately. After that, there are a number of good videos over at SQLShare. You can also find good stuff at SQLServerPedia[/url]. Beyond that, you get into blogs & places like here at SSC or over at Simple-Talk[/url].

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • thanks for your reply, but i am not looking it for free. i have no issue paying the cost but that should be the good one.

  • Then all you've got to do is run a search through Google or Bing. Here's one. First thing listed is, again, Microsoft training. Going to the source never hurts.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • My two cents..

    You can check these books to become a master

    http://www.brentozar.com/best-sql-server-dba-books/

    Dissecting SQL Server Execution Plans by Grant Fritchey

    Pro SQL Server 2008 Replication --- Sujoy Paul

    http://www.sqlusa.com/highperformance2005/ -- Video Training

    http://www.replicationanswers.com/

    Thank You,

    BestRegards,

    SQLBuddy

  • sqlbuddy123 (10/5/2010)


    My two cents..

    You can check these books to become a master

    I'll disagree slightly...

    Books alone will not make you a master. Books + experience + experimentation may, with sufficient dedication (which very, very few have) get you to that level.

    I have a rather old blog post that touches on this

    http://sqlinthewild.co.za/index.php/2008/05/29/food-for-thought/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (10/5/2010)


    sqlbuddy123 (10/5/2010)


    My two cents..

    You can check these books to become a master

    I'll disagree slightly...

    Books alone will not make you a master. Books + experience + experimentation may, with sufficient dedication (which very, very few have) get you to that level.

    I have a rather old blog post that touches on this

    http://sqlinthewild.co.za/index.php/2008/05/29/food-for-thought/

    I was going to say something similar..

    You can read every book in the world, but the difference between a jr. dba and a sr. dba is usually that the sr. dba has had hands on experience and had to figure out how to solve issues on their own. I honestly learn more every couple days browsing these forums than I did while studying/taking all the MS SQL cert exams (I'm just shy of MCDBA..which I should get, but I don't want to pay for it myself :))

  • Derrick Smith (10/5/2010)


    (I'm just shy of MCDBA..which I should get, but I don't want to pay for it myself :))

    Not any more... All the MCDBA exams (excluding maybe 1) are retired. You can do the 2005 or 2008 MCTS/MCITP, but not the MCDBA any longer

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (10/5/2010)


    Derrick Smith (10/5/2010)


    (I'm just shy of MCDBA..which I should get, but I don't want to pay for it myself :))

    Not any more... All the MCDBA exams (excluding maybe 1) are retired. You can do the 2005 or 2008 MCTS/MCITP, but not the MCDBA any longer

    Shows how long it's been since I started these!

    I'll have to look at the cert tree again. Good to know.

  • Whoops..I meant MCITP rather than MCDBA (which I believe was the 2000 equivalent).

    Any tips on how to justify the cost of the exams to my company? I need I believe two more to be MCITP 2005, and then the upgrade to 2008..I started the chain at my last company that just blanket-agreed to pay for all certifications, but my current one isn't quite as easy going.

  • GilaMonster (10/5/2010)


    sqlbuddy123 (10/5/2010)


    My two cents..

    You can check these books to become a master

    I'll disagree slightly...

    Books alone will not make you a master. Books + experience + experimentation may, with sufficient dedication (which very, very few have) get you to that level.

    I have a rather old blog post that touches on this

    http://sqlinthewild.co.za/index.php/2008/05/29/food-for-thought/

    I couldn't agree more and I wrote one of the books that will supposedly make you a "master."

    BTW, speaking only of my book, it won't make you a master. It barely scratches the surface of everything you need to tune queries. I wanted it to be a begginer/intermediate book, but the publishers thought it should be intermediate/advanced.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply