+ Reply to Thread
Results 1 to 19 of 19
  1. Senior Member BeaverC32's Avatar
    Join Date
    May 2007
    Posts
    677

    Certifications
    See Signature
    #1

    Default Resources for 70-431: SQL Server 2005

    70-431 Resources

    In preparation for the 70-431 exam (MCTS: SQL Server 2005), I have compiled a list of resources I have used or will be using. Enjoy!

    Beginning SQL Server 2005 Programming.
    This book serves as an excellent resource for learning the basics of database structure, and uses an excellent balance of introductory and practical material. The first few chapters illustrate the basic components of database design and SQL Server, and then quickly teaches you the most fundamental T-SQL commands. I really like this book because it is very well-written, and builds off of the preceding chapters. If you are a beginner to T-SQL or SQL Server 2005, this is the book you want to start with.

    MSPress Self-Paced Training Kit: 70-431
    This, like many other MSPress books, is well written and directly lines up with the exam objectives. I particularly found the practice exercises to be useful, because they greatly reinforce the material just discussed. This book also includes a 180-day trial of SQL Server Enterprise Edition, so you don't have to settle with the Express Edition.

    SQL Server 2005 Administrator's Pocket Consultant
    Serves as an excellent resource for immediate reference in administration of all things SQL-Server. Using this as a book that will be used on the job, and not as primary learning material. At only $14, you truly get a lot of bang for your buck.

    That's it for books...however, there are also a TON of free online resources. Here are a few of my favorites:

    Free SQL Server Tutorials
    This site offers 15 free powerpoints that discuss T-SQL, and are structured in a "lecture style". There are also practice questions that really put your mind to work (with provided solutions). A really nice resource that is 100% free.

    SQL Server 2005 Books Online
    Microsoft's free documentation on SQL Server. Also available as a download for a local-copy for even faster access and searching. I have already used this resource quite a bit, and have found it to be well laid-out and easy to navigate. A definite must use resource for study and real-world use.

    SQL Server Learning Resources
    A free series of videos (over 9 hours worth) from Microsoft to help get you going on SQL Server 2005. Superb resource, I highly recommend going through all the videos offered.


    Those are the resources I found most helpful. Feel free to add yours
    Reply With Quote Quote  

  2. SS -->
  3. Johan Hiemstra Forum Admin Webmaster's Avatar
    Join Date
    Jun 2002
    Location
    52n31, 6e06
    Posts
    10,383
    Blog Entries
    3

    Certifications
    MCSE NT4 MCSA 2000/2003 Security+ (expired: CWNA, CNA, CCNA)
    #2
    Thanks for sharing

    The Pocket Consultant books from Microsoft are usually both useful on the job and to prepare for the exam. Not as your primary study material but the practical approach of the content matches the exam style from Microsoft (some theory, mostly 'tasks'). Good reading material for on the beach/in the park/at starbucks or those quiet hours on the helpdesk.
    Reply With Quote Quote  

  4. Junior Member
    Join Date
    Sep 2007
    Location
    Norwich, UK
    Posts
    15
    #3
    Thanks so much for these... helping out a lot
    Reply With Quote Quote  

  5. Junior Member
    Join Date
    Sep 2005
    Location
    India
    Posts
    23

    Certifications
    MCDST (XP), MCITP, MCTS (Vista: Deployment, Configuration), MCSA Windows 2003:Messaging
    #4
    Thanks I am preparing for this exam.
    Reply With Quote Quote  

  6. Member
    Join Date
    Jun 2008
    Location
    Northern New Jersey
    Posts
    84

    Certifications
    MCP, MCSD, MCTS
    #5
    Good afternoon,
    Glad I found this website and forum. Currently training myself in sql server 2005. I have really been busting it the last few months.

    I disagree with one of the items listed: the Microsoft Press book. Yes, it is pretty good, the examples shown are very good, though the chapter review and exams contained in the CD, I thought were fluff.

    I acquired study and practice test materials from PrepLogic. When I took the first go around with the exams, I had not a clue what they were asking. Completely lost. I was forced to get my head into the SQL Books Online documentation, actually install the evaluation copy of sql server 2005 and play around with it, as well as the other tools and utilities.

    The amount of material I have learned and the information acquired has been mind boggling.

    I appreciate any comments from you guys.

    My intentions is to go with the DB Developer track for cert purposes.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Nov 2007
    Location
    Colbert Nation
    Posts
    1,220

    Certifications
    life+
    #6
    Quote Originally Posted by savior faire
    I was forced to get my head into the SQL Books Online documentation, actually install the evaluation copy of sql server 2005 and play around with it, as well as the other tools and utilities.
    You have to install it and work with it or you'll have no shot with the sims.

    I started off slow learning, because many of the concepts were new to me.
    Reply With Quote Quote  

  8. Member
    Join Date
    Jun 2008
    Location
    Northern New Jersey
    Posts
    84

    Certifications
    MCP, MCSD, MCTS
    #7
    You have to install it and work with it or you'll have no shot with the sims.
    Oh, yeah..
    Reply With Quote Quote  

  9. Senior Member BeaverC32's Avatar
    Join Date
    May 2007
    Posts
    677

    Certifications
    See Signature
    #8
    How did you follow along with the examples/exercises in the MSPress book without actually doing it yourself in SQL Server? The book even comes with a trial version...
    Reply With Quote Quote  

  10. Member
    Join Date
    Jun 2008
    Location
    Northern New Jersey
    Posts
    84

    Certifications
    MCP, MCSD, MCTS
    #9
    How did you follow along with the examples/exercises in the MSPress book without actually doing it yourself in SQL Server? The book even comes with a trial version...
    I read through the text first. Then fiddled with the installed software. I am somewhat limited in what specific exercises I can(or cannot) do since I just have a single pc with Vista on it and one hard drive.
    Reply With Quote Quote  

  11. Senior Member BeaverC32's Avatar
    Join Date
    May 2007
    Posts
    677

    Certifications
    See Signature
    #10
    Your setup should more adequate...that's really all I used. One thing with Vista + SQL Server is that you need to upgrade SQL Server (a painless process): http://technet.microsoft.com/en-us/s.../bb426877.aspx

    Again, you don't need an elaborate setup to learn a majority of the topics.
    Reply With Quote Quote  

  12. Member
    Join Date
    Jun 2008
    Location
    Northern New Jersey
    Posts
    84

    Certifications
    MCP, MCSD, MCTS
    #11
    Your setup should more adequate...that's really all I used. One thing with Vista + SQL Server is that you need to upgrade SQL Server (a painless process): http://technet.microsoft.com/en-us/s.../bb426877.aspx

    Again, you don't need an elaborate setup to learn a majority of the topics.
    Yes, I was aware that I needed SP2... installed it... no problems, painless.

    I believe to do the Log Shipping/Mirroring, these may not work with a single default instance installed, though I have to re-read the text to see how they address this.

    Appreciate your feed back...
    Reply With Quote Quote  

  13. Senior Member BeaverC32's Avatar
    Join Date
    May 2007
    Posts
    677

    Certifications
    See Signature
    #12
    Yeah, you can still play with log shipping, you just might not be able to implement it completely(same with mirroring). You need separate database instances/servers for the primary/secondary/monitor servers. I also believe Log Shipping isn't available on express edition.

    At the very least, become familiar with the different roles in database mirroring, the operating modes, and the process used to setup with and without a witness server. For log shipping, understand each component (primary database, secondary database, primary server, etc). Access rights for the agent is also a need-to-know (when and where are read and read/write rights required).
    Reply With Quote Quote  

  14. Member
    Join Date
    Jun 2008
    Location
    Northern New Jersey
    Posts
    84

    Certifications
    MCP, MCSD, MCTS
    #13
    Yeah, got all those bases covered... though correct me if I am in error, but I believe the CD contains the Enterprise Edition good for 180 days. There is nothing that I have seen as I poke around that indicates otherwise.

    I was thinking of doing another install but using a "named instance", darn it, I am really busy...LOL

    Appreciate the feedback...thanks...
    Reply With Quote Quote  

  15. Junior Member
    Join Date
    Sep 2005
    Location
    India
    Posts
    23

    Certifications
    MCDST (XP), MCITP, MCTS (Vista: Deployment, Configuration), MCSA Windows 2003:Messaging
    #14
    Also Add CBT Nuggets to your list. Thats very very helpful.
    Reply With Quote Quote  

  16. Senior Member MCPWannabe's Avatar
    Join Date
    Jun 2008
    Posts
    195

    Certifications
    A+, NET+, MCSA 03,MCAD, MCDBA, MCT, MCSD, MCPD (Ent. Applications Developer), MCITP (Ent. Tech)
    #15

    Default Pubs database

    Hello Beaver,

    Thank You for including this information.

    I have a question for anyone who has used the free website tutorial lessons to get an introduction to T-SQL.

    The author includes the lessons, powerpoints, and labs while not including the 'Pubs' database to actually do the labs. I'm emailing the author about this, but I wanted to see if anyone has a copy of the "Pubs" practice database for the labs?

    I'll let everyone know the results of the email also.
    Reply With Quote Quote  

  17. Senior Member MCPWannabe's Avatar
    Join Date
    Jun 2008
    Posts
    195

    Certifications
    A+, NET+, MCSA 03,MCAD, MCDBA, MCT, MCSD, MCPD (Ent. Applications Developer), MCITP (Ent. Tech)
    #16
    Sorry about that. I just found the PUBS database:

    http://www.microsoft.com/downloads/d...displaylang=en

    That's for anyone else who wants to practice.

    I did notice one other thing. The full course has 42 units on the syllabus. Has anyone purchased and used it for the website free lessons?
    Reply With Quote Quote  

  18. Senior Member
    Join Date
    Mar 2007
    Posts
    12,308
    #17
    Great info!

    Why isn't this a sticky?
    Reply With Quote Quote  

  19. 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
    #18
    I second the sticky. I have been getting a lot of PMs and refering them here.

    So **BUMP**
    Reply With Quote Quote  

  20. Junior Member
    Join Date
    Nov 2008
    Posts
    4

    Certifications
    A+, Network+, MCDST, 70-291
    #19
    Thank you for the bump! This is a brilliant list of resources and I shall be using all of them in my quest for SQL 2005 certification
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks