Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
46 used & new from $0.31

Have one to sell? Sell yours here
 
   
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits)
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits) (Paperback)

by Sara Morgan (Author), Tobias Thernstrom (Author)
Key Phrases: read committed snapshot isolation level, cursor strategy, two tables that will, Server Management Studio, Visual Studio, Visual Basic (more...)
4.4 out of 5 stars See all reviews (5 customer reviews)

List Price: $59.99
Price: $37.79 & this item ships for FREE with Super Saver Shipping. Details
You Save: $22.20 (37%)
Upgrade this book for $11.99 more, and you can read, search, and annotate every page online. See details
Usually ships within 7 to 13 days.
Ships from and sold by Amazon.com. Gift-wrap available.

21 new from $10.94 25 used from $0.31
More from Microsoft Press
Make the most of your investment in Microsoft technology with books from the Microsoft Press Learning Center.

Frequently Bought Together

MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits) + MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits) + MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
Price For All Three: $113.37

Some of these items ship sooner than the others. Show details


Customers Who Bought This Item Also Bought

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

by Solid Quality Learning
3.9 out of 5 stars (45)  $37.79
MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft® SQL Server 2005 Database Administrator Core Requirements (Pro Certification)

MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft® SQL Server 2005 Database Administrator Core Requirements (Pro Certification)

by Solid Quality Learning
4.3 out of 5 stars (12)  $88.19
MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005

MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005

by Erik Veerman
3.3 out of 5 stars (9)  $37.79
MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft  SQL Server(TM) 2005 (Pro Certification)

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server(TM) 2005 (Pro Certification)

by J.C. Mackin
MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft® SQL Server(TM) 2005 (Pro-Certification)

MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft® SQL Server(TM) 2005 (Pro-Certification)

by Orin Thomas
Explore similar items

Editorial Reviews

Product Description
Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-442, one of the required exams for the Microsoft Certified IT Professional (MCITP) Database Developer certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.

Work at your own pace through the lessons and lab exercises. Focusing on designing and implementing database solutions in a professional job role, this official study guide covers topics such as designing data access technologies, writing and modifying queries, validating input data and handling errors, developing a transaction strategy, and optimizing performance.

Then assess yourself using 200+ practice questions on the CD, featuring multiple, customizable testing options designed to meet your specific needs. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters. You get detailed explanations for right and wrong answers--including pointers back to the book for further study. You also get an evaluation version of Microsoft SQL Server 2005 software and an exam discount voucher--making this kit an exceptional value and a great career investment.

From the Publisher
Key Book Benefits:

-In-depth coverage of exam objectives and sub-objectives--plus instructive case studies and troubleshooting scenarios to enhance your performance on the job

-200+ practice and review questions

-Test engine that enables customized testing, pre-assessment and post-assessment, and automated scoring and feedback

-Complete objective-by-objective review section, plus a handy exam-mapping grid

-180-day evaluation version of SQL Server 2005 Enterprise Edition

-15 percent exam-discount voucher from Microsoft (limited time offer)

-Entire study guide in searchable eBook format

See all Editorial Reviews


Product Details

  • Paperback: 544 pages
  • Publisher: Microsoft Press (April 25, 2007)
  • Language: English
  • ISBN-10: 073562383X
  • ISBN-13: 978-0735623835
  • Product Dimensions: 8.8 x 7.2 x 1.5 inches
  • Shipping Weight: 2.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars See all reviews (5 customer reviews)
  • Amazon.com Sales Rank: #37,800 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #1 in  Books > Computers & Internet > Certification Central > Office
    #10 in  Books > Computers & Internet > Certification Central > MS SQL Server
    #26 in  Books > Computers & Internet > Certification Central > Publisher > Microsoft Press

Inside This Book (learn more)


Books on Related Topics (learn more)
 
 


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
(1)

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

5 Reviews
5 star:
 (2)
4 star:
 (3)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.4 out of 5 stars (5 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
6 of 6 people found the following review helpful:
4.0 out of 5 stars Highly recommended exam preparation resource, October 9, 2007
By Matthew Bryde (Australia) - See all my reviews
Having studied similar material by both Sybex and MS Press for other Microsoft's SQL 2005 exams, I found this particular book a good preparation guide for the 70-442 exam.

As you would expect, it covers the appropriate material and presents its material in an easy to follow and relevant manner. Having just sat the 070-442 exam today, I can strongly advise that just reading this book alone is not enough preparation. Having a thorough understanding of the different locking mechanisms, Multiple Active Result Sets (MARS) and transaction isolation levels, as well as using the supplementary material frequently quoted in this book (website articles, practice lessons and the companion CD included) are an essential must for anyone planning to sit the 070-442 exam.

The companion CD included contains practice questions, a PDF version of the book (great for searching), as well as excerpts from the other four MS Press Inside/Programming SQL books.

Having prepared by also studying other SQL material (namely the Inside-SQL series), I kept forgetting this was the official Microsoft exam guide - the style and format is less like a classroom/lab and more like an informative text with hands on examples. As a negative, the end of section review question are very light on, and the one scenario question at the end of each chapter is also extremely brief and not at all indicative of the exam. But that's precisely why you need the companion CD to fill the void.

Another negative - there were some exam questions on topics that never received a mention in this study guide: "Begin Transaction WITH MARK", and using "savepoints" as examples. That alone prevents me from awarding 5 stars.

Overall, this is an excellent resource, but supplemental study on the sections that emphasize "This is on the exam" is definitely required, as well as the areas mentioned above.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
8 of 10 people found the following review helpful:
5.0 out of 5 stars Much More Than a Practice for the Test Book, May 29, 2007
This book is the training manual for taking Microsofts 70-442 certification examination on SQL Server 2005. And like other training manuals, it gives an excellent introduction to the exam and provides the information that you'll need to pass the test. It includes sample tests, a time limited version of SQL Server 2005 to help with the examples, all the usual things.

This book, however, goes beyond the normal cram for an exam book in that it provides descriptions and explanations that go well beyond what will be asked on the test. This provides a basic understanding of SQL Server that goes well beyond what will be asked on the test.

For instance Appendix B runs for 70 pages and covers the internal architecture of the SQL Server product with special notes as to its operation on the new multi core CPUs, the use of CLR programming techniques (part of the .NET environment) and a lot more.

This is a book aimed at the expert. The SQL code examples are way above the trivial level. You may find that you'll need another book on SQL programming for the 2005 product to help explain what this book is covering fairly briefly.
Comment Comments (3) | Permalink | Was this review helpful to you? Yes No (Report this)



 
5.0 out of 5 stars Real Cheap, Real Fast, Real good condition, May 11, 2009
I can't believe everyone doesn't buy these books used, they are so cheap. thank you, I hope Amazon can give us a way to filter searches by vendor who i've purchased from before. thank you.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars Good
This book helped me prep for the 70-442 exam. I managed to pass it the first time, it dose not mean its sufficient, we need to read more books and search for other materials... Read more
Published 9 months ago by F. Punjwani

4.0 out of 5 stars Covers all.
This is a good book that covers all you need to know for this exam.
Published 20 months ago by Mr. Steve Kossaris

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
   


Product Information from the Amapedia Community

Beta (What's this?)



Look for Similar Items by Category


Plumbing Products in the Value Center

Home Improvement Value Center Plumbing Products
Turn it on for less with spectacular deals on brand-name faucets, showerheads, and more in the Home Improvement Value Center.

Shop the Value Center

 

Best Books of 2008

Best of 2008
Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
 

Warm Those Winter Blues

Shop for Heaters
Warm up a cold spot efficiently and safely this winter with an extra space heater or baseboard heater.

Shop all heating products

 

Best Books

Best of the Month
See our editors' picks and more of the best new books on our Best of the Month page.
 

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Glenn Beck's Common Sense
Glenn Beck's Common Sense
Darkfever
Darkfever by Karen Marie Moning
The Adventures of Sherlock Holmes
The Adventures of Sherlock Holmes by Arthur Conan, Sir, 1859-1930 Doyle

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates