+ Reply to Thread
Results 1 to 17 of 17
  1. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #1

    Default MCITP: DBA 2008 Resources

    I’m breaking this post up into three parts. The first is books that I have used to study for the DBA Upgrade exam and that I believe are perfect for preparing for any of the DBA exams for SQL Server 2008. The second section is for training material I have found on the web, including a shameless plug for my own blog to which I am posting many of my notes about exam prep. The third section is for books that I believe are good to read for a career as a DBA. If you already work with SQL Server these books will help you get to the next level.

    Section One – MCITP: DBA 2008 Books
    SQL Server 2008 Administration in Action
    SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills - While this book is for SQL Server 2005, all of it is applicable to SQL Server 2008. Learn how to do all of the exercises in this book and know them cold and you will be at a very strong junior level. A similar book for SQL Server 2008 is due to be released in May, 2010.
    SQL Server 2008 Administration: Real World Skills for MCITP Certification and Beyond (Exams 70-432 and 40-450)

    If you study these two books and know how to do all of the labs in them in the GUI and via T-SQL you will be a very competent SQL Server professional.

    Microsoft SQL Server 2008 Fundamentals – This will set you up to have a strong fundamental understanding of T-SQL and how it works.

    These three books lay the foundation for becoming a very strong SQL Server IT Pro. But I cannot stress that you cannot just read them for this to be true. You need to make these as hands on and practical as possible. Do every single exercise you can. Retype every single line of code and run it.

    Section Two – Online Resources

    BoL 2008
    SQLServerPedia
    SQL Server 2008 Virtual Labs
    SQL Server 2008 How To Videos and other Resources
    Microsoft Press : Free ebook: Introducing Microsoft SQL Server 2008 R2
    SQL Server 2008 R2 and Self-Service BI Solution Downloads
    Download details: Microsoft SQL Server 2008 R2 - Express

    Section Three – Beyond the Certification

    DBA Survivor: Become a Rock Star DBA – Advice and information to help you get and keep your first job a s a full-time DBA.
    SQL Server 2008 Troubleshooting and Internals
    SQL and Relational Theory – Learn the fundamental concepts of Relational Database theory and how to apply it to your T-SQL.
    Beginning Database Design: from Novice to Professional
    SQL Server MVP Deep Dives – Advice and knowledge from the best professionals in the field.
    Last edited by RobertKaucher; 07-07-2010 at 01:55 PM.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member aaronchristenson's Avatar
    Join Date
    Nov 2003
    Posts
    253

    Certifications
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+
    #2
    This is a very comprehensive list. I think that if anyone used these matterials they should have no problem passing the exams. All I used for the upgrade exam was the MS TK for 70-432 and Transcender for the 70-453 exam. I would nominate this for a sticky.
    Aaron
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+, Virtualization with Windows Server Hyper-V and System Center Specialist
    Reply With Quote Quote  

  4. wibble! bertieb's Avatar
    Join Date
    Jun 2007
    Location
    Up and down the UK
    Posts
    1,029

    Certifications
    MCSE:CP&I, SI, MCITPx2, MCSAx2, MCTSx7, VCP6/5/4/3(DCV), EMCISA, Sec+, ITILv3F, legacy MS
    #3
    Quote Originally Posted by aaronchristenson View Post
    I would nominate this for a sticky.
    Me too. Another excellent post Robert, thank you.
    The trouble with quotes on the internet is that you can never tell if they are genuine - Abraham Lincoln
    Reply With Quote Quote  

  5. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #4
    Thanks, guys. Let me tell you I discovered the SQL Server 2008 Administration in Action about a week ago and that book DOES NOT mess around. I have read a few "introductiory" books that just walk you through wizards and you don't ever really learn anything from them. I wish I had this book when I first started with SQL Server back in 2007. I just skipps over the easy stuff that any server admin would easily understand and then gits into the details about what an admin needs to understand. The first few chapters on SQL Server design have been wonderful and I find myself reading that book as if it were a novel I was reading for pleasure.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Sep 2008
    Posts
    108

    Certifications
    Ma, MSc, MCSE, MCITP:EMA+EA+DBA, CCNA, Commvault, MCTS Sharepoint Admin
    #5
    Thanks very much for posting these link Robert. I've got the 2005 DBA street smarts book which is realy good and I'll get onto the 2008 admin book once I've finished. I'm really enjoying my study on DBA workings at the momment, it's making for a nice change of pace.
    Reply With Quote Quote  

  7. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #6
    Quote Originally Posted by tenrou View Post
    Thanks very much for posting these link Robert. I've got the 2005 DBA street smarts book which is realy good and I'll get onto the 2008 admin book once I've finished. I'm really enjoying my study on DBA workings at the momment, it's making for a nice change of pace.
    You should also check out the DBA Survivor book by Thomas LaRock. A nice, easy read with good information in it. Do not pay regular price, though. It's just not worth the $35.00 or whatever it is at regular price.
    Reply With Quote Quote  

  8. Member
    Join Date
    Feb 2010
    Posts
    48
    #7
    Thank you for such a thorough and well thought out post. I'm starting my MS in CIS program here shortly and will be doing a sub-concentration in Database Administration so I think those materials will be very helpful for me. I am defiantly getting the DB Survivor book the next time I make an Amazon order!
    Reply With Quote Quote  

  9. Junior Member
    Join Date
    Feb 2007
    Location
    Painesville, OH
    Posts
    6

    Certifications
    A+, Network+, CCNA, MCITP:EA,MCTS(70-432),70-680
    #8
    Thanks for the post. I am studying for the 70-432 and have been using the Microsoft training guide. I have started looking at the books online and the administrator in action. They fill in the gaps very nicely.
    Reply With Quote Quote  

  10. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #9
    Thanks! I have just added a few links to the online resources.
    Reply With Quote Quote  

  11. Member GagHalfrunt's Avatar
    Join Date
    Nov 2006
    Location
    Nr. Stratford-Upon-Avon, UK
    Posts
    81

    Certifications
    Win2008 EA & SA, SQL2008 MCITP, Win7 MCTS, CCA
    #10
    Very useful post, needs to be a sticky methinks!

    But then officially this forum doesn't cover 2008!
    Reply With Quote Quote  

  12. Member Norrlands Turk's Avatar
    Join Date
    May 2009
    Location
    WI
    Posts
    34

    Certifications
    MCSA, ITIL v3
    #11
    Excellent post sir.

    Thank you.
    Reply With Quote Quote  

  13. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #12
    I've been working on the labs for Amazon.com: SQL Server 2008 Administration: Real-World Skills for… and I just wanted to say that I think it is an excellent book. It covers a lot of theory and does it very well. It is an excellent prep source for the 2008 MCITP DBA.

    If you really master the material in it and in Amazon.com: SQL Server 2008 Administration in Action (9781933988726): Rod Colledge: Books you will have a very strong foundation in SQL Sserver administration. I wish I had read these two books first. I wasted a lot of time on some really boring stuff because these two did not yet exist.
    Reply With Quote Quote  

  14. Member
    Join Date
    Feb 2010
    Location
    Lithuania-Vilnius
    Posts
    74

    Certifications
    MCTS: 70-680, 70-685, 70-432
    #13
    I'm preparing or 70-432 exam and I started to read MS Press book. Couldn't finish the 2nd chapter simply because of frustration of dealing with incorrect information. Now I got two by this post recommended books - "SQL Server 2008 Administration in Action" and "SQL server administration Real world skills for MCITP...".
    My question would be which book should I start to read first? I have no background in MS SQL server (little bit of PostgreSQL) or SQL language.
    Goal is to prepare for exam and lay down strong background.
    p.s. I started to read "... administration in action" but in the beggining of the book it was stated, that it based on "best practice" examples. I would like first to get basic knowledge and next move to advanced study. So the roud should be "SQL server administration Real world skills for MCITP..." => "SQL Server 2008 Administration in Action"?
    Reply With Quote Quote  

  15. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #14
    Yes, I would start with the Real World Skills book and then move on to admin in action. But don't get the wrong idea about admin in action. It is not an advanced book, it just covers things in detail. As for the test: lab, lab, lab, lab and when you think you understand something lab it again. I would read the T-SQL in 10 Minutes in conjunction with the the Real World Skills book.
    Reply With Quote Quote  

  16. LCA
    LCA is offline
    Technet Junkie LCA's Avatar
    Join Date
    Sep 2009
    Location
    New Zealand
    Posts
    215

    Certifications
    MCITP:EA, MCTS (SQL Server 70-432) MCP, Network+, Dip. Computer Systems Network Engineering
    #15
    Found these resources on Buck Woody's blog over at MSDN yesterday which has an extensive list of resources to 70-432 topics on MSDN. The topics are also on Books Online but these are much more usable when read from MSDN.


    Buck Woody's 70-432 exam resources




    HAT TIP to Buck Woody
    Last edited by LCA; 02-20-2011 at 05:38 PM. Reason: readibility
    Reply With Quote Quote  

  17. Junior Member Registered Member
    Join Date
    Mar 2011
    Posts
    1
    #16
    Thank you for this. I am just starting my studying and I needed this info!
    Reply With Quote Quote  

  18. Senior Member amcnow's Avatar
    Join Date
    Apr 2012
    Location
    Circle City
    Posts
    214

    Certifications
    CISSP, C|EH, C|HFI, SAFe Practitioner, ITILF, OCP Java SE 6, MCTS SQL Server 2008, A+
    #17
    Microsoft has delayed the discontinuation of exam 70-450 (PRO: Microsoft SQL Server 2008, Designing, Optimizing, and Maintaining a Database Administrative Solution) yet again. It will now retire on July 31st, 2014 (a full year past the original retirement date).

    Exam 70-450: Pro: Designing, optimizing, and maintaining a database administrative solution using Microsoft SQL Server 2008

    Retired exams
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks