any recommendations for 70-450?

Question

any recommendations for 70-450?

SQLSandwiches

SSCrazy

Points: 2143
More actions
June 30, 2009 at 12:50 pm

#132360

Hi,
I just passed the 70-432 test and am going to start to studying for the 70-450 test to complete my sql 08 MCITP. I checked out http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-450&locale=en-us#tab3 and noticed that there aren't any books or e-books for this.
Does anyone have any recommendations on how to study for this?
My current plan is to just take the skills list and study the sql server 08 admin pocket consultant.
Any suggestions would be greatly appreciated.

Viewing 15 posts - 1 through 15 (of 26 total)

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

sindhigrl Default port Points: 1448 More actions · Answer 1

We are also trying to find training materials for the 70-450 exam. Apparently MS Press does not have any training kits yet...any idea if there is one in the making?

Thanks!

SQLSandwiches SSCrazy Points: 2143 More actions · Answer 2

From what I have read, MS is NOT going to make a book for this test. I have heard that they recommend reading the admin pocket consultant.

I am looking into these - http://www.cbtnuggets.com/webapp/product?id=464

Paul Swinfield SSC-Addicted Points: 498 More actions · Answer 3

I have just done my 70-450 today (841/1000). My advice it to buy the pocket admin guide and buy the 70-432 MS study book. It gets a slating, but I thought it was good if coupled with the relevant msdn sections. If you can though, try and create some VM's and create your own set of servers and practice mirroring, clustering etc. It really helps in the exam if you cover all bases as the questions are spread very wide. Paul.

sql-lover SSCoach Points: 18530 More actions · Answer 4

Bringing this post to live ... any book recommendation for the 70-450 ...

thanks,

dumin.net Old Hand Points: 377 More actions · Answer 5

Im also going to do MCITP 70-450 .microsoft havnt mentioned or published what are the recommended books

jack-64275 SSCrazy Points: 2017 More actions · Answer 6

Just passed 70-450 on 7/2/2010.

I used the pocket admin, lots of SSMS, BOL, and practice. Transcender has pretty good practice tests. Take the tests, review the answers and explinations, and try recreating some of the test scenarios.

I plan to begin the BI track now.

josantia Ten Centuries Points: 1255 More actions · Answer 7

Hi,

I'm in the same situation as you, I think I'm going to use this book to study:

http://www.amazon.com/SQL-Server-2008-Administration-Certification/dp/0470554207/ref=sr_1_1?ie=UTF8&s=books&qid=1278508895&sr=8-1

Regards,

Jose S. Oyervides.

SQLSandwiches SSCrazy Points: 2143 More actions · Answer 8

Just barely failed the 70-450 test today.

Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass this test.

Those security questions are hard.

RichardDouglas SSCarpal Tunnel Points: 4029 More actions · Answer 9

Yin Halen (7/8/2010)
Just barely failed the 70-450 test today.
Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass this test.
Those security questions are hard.

Sorry to hear that. There's a book on amazon by Tom Carpenter SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) has anybody used it? There are no ratings for it on the UK or US sites.

Rich

Hope this helps,
Rich

[p]
[/p]

Chris Houghton SSCrazy Points: 2557 More actions · Answer 10

rdouglas66 (7/15/2010)
Yin Halen (7/8/2010)
Just barely failed the 70-450 test today.
Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass this test.
Those security questions are hard.
Sorry to hear that. There's a book on amazon by Tom Carpenter SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) has anybody used it? There are no ratings for it on the UK or US sites.
Rich

There's also this -

70-443 and 70-450: Microsoft SQL Server Database Design and Optimization, Package

Thinking of giving it a go now I've got the 70-432 out of the way, looks like its the instructors resource but it's official MS (if that's a good thing!)

Chris Houghton SSCrazy Points: 2557 More actions · Answer 11

Chris Houghton

SSCrazy

Points: 2557

July 16, 2010 at 9:01 am

#1194166

Will let you know if it's any good.

Vineet Khanna SSC Journeyman Points: 91 More actions · Answer 12

Guys any suggestions for mcitp 70-450?

Thanks in advance

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 13

RichardDouglas (7/15/2010)
There's a book on amazon by Tom Carpenter SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) has anybody used it? There are no ratings for it on the UK or US sites.
Rich

I have the book and it is pretty good read. I have not read it all the way through yet. I did not buy it was given to me at a PASS user group meeting. The good thing about is it is current, it was just written and published in 2010. It does have a test engine and flashcards (like all other Sybex books), with some video walkthroughs.

You might also go by the Skills Measured page and check Books Online for the information.

I have used MeasureUp.com that came with a few Exam Cram books I have. It is very good as practice. I think the 70-450 is about $80 for 30-day access. They have very good explanations in the answers, tell you why the wrong answer is wrong.

I might also suggest these 2 books:

Microsoft SQL Server 2008 Internals (Pro - Developer) by Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, and Conor Cunningham (Paperback - Mar 11, 2009)

Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, and James Rowland-Jones (Paperback - Jan 7, 2010)

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 14

Chris Houghton (7/16/2010)
There's also this -
70-443 and 70-450: Microsoft SQL Server Database Design and Optimization, Package
Thinking of giving it a go now I've got the 70-432 out of the way, looks like its the instructors resource but it's official MS (if that's a good thing!)

If you can setup some virtual machines the lab manual would be a great thing to go through if you have not worked with SQL Server 2008 before.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton