Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit [Paperback]

Microsoft Corporation (Author), Microsoft Corporation Staff (Author)

Book Description

ISBN-10: 0735606706 | ISBN-13: 978-0735606708 | Publication Date: January 1, 1999

The MICROSOFT(r) SQL SERVER(r) 7 DATA WAREHOUSING TRAINING KIT prepares students for MCP Exam 70-019-Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0 and Microsoft(r) Decision Support Services 1.0. The Kit covers the installation, configuration, and support of the Microsoft SQL Server client/server database management system, version 7.0. THE MICROSOFT SQL SERVER 7 DATA WAREHOUSING TRAINING KIT is designed to train professionals (SQL Server administrators, Corporate IS/MIS staff, Database administrators, and system engineers) in the skills they need to do their job and assist them in passing the exam.

Product Details

• Paperback: 800 pages
• Publisher: Microsoft Press (January 1, 1999)
• Language: English
• ISBN-10: 0735606706
• ISBN-13: 978-0735606708
• Product Dimensions: 7.8 x 5.1 x 1 inches
• Shipping Weight: 1 pounds
• Average Customer Review: 4.2 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #4,017,761 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Passed 70-019 with this book, November 17, 2000

By 

Michael Lawson (Snohomish, WA USA) - See all my reviews

This review is from: Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit (Paperback)

I took this exam after taking the SQL Admin and Design exams (70-028 and 70-029). I have many years of experience as a DBA, but none with Data Warehousing. Multidemensional schemas and cubes were completely new concepts for me which this book did a fine job of introducing me to. There is a good mix of instruction and hands on exercises. For review, I used the "About this book" section at the front which maps the exam objectives to the individual chapters and lessons. I also read thru the OLAP Services Books Online "Administrators Guide" section that comes with the product. There is a huge amount of material to cover and this book seemed to give about the right breadth and depth that I needed to pass the exam - topics like DSO, DTO and ADO MD objects models, MDX, DTS, replication, English Query, Logical and Physical data warehouse design, and of course OLAP Services. My weakest area, based on the exam results, was in the "Analyzing Business Requirements" and "Developing the Logical Design", predictable, since I had so little experience. More case studies along the lines of "Here's the customer senario - go design the data warehouse" followed by "Here's a good design and why" would help.

6 of 6 people found the following review helpful:

5.0 out of 5 stars A great step-by-step to use at work, an asset to pass exam., August 16, 2001

By 

D. Gresty "Hammerit" (Littleton, CO United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit (Paperback)

I originally bought this book for two reasons. One, to pass an elective exam on my MCSD and second, to utilize on my current consulting job. This book did not let me down at all.

Combining this book with material from Transcenders, I passed the Microsoft exam with room to spare. More importantly though- it allowed me to start developing a data warehousing project on my current assignment.

The book is well written and goes step by step from the fundamentals to advanced DTS. In addition, there is additional exercises in the book that allow you to sharpen your skills with SQL and MDX.

BEWARE- THE CD'S IN THE BOOK ONLY WORK WITH NT 4.0. IF YOU HAVE WINDOWS PROFESSIONAL 2000, YOU MAY KISS OFF TO THE ADDITIONAL DATA AND TRIAL VERSIONS OF SQL SERVER ON THE CD'S THAT ARE PROVIDED. I HAVE MSDE LOADED- SO I COULD USE THE SAMPLES THAT THEY PROVIDED IN THE BOOK AT HOME.

In addition, I feel that Microsoft Press did an excellent job in providing the reader with in depth detail that is mandatory in building a successful data warehouse. Unlike the Oracle Press books that I have used- In my opinion- Microsoft Press goes beyond the surface of memorization of facts and provides the reasoning behind the content of the book that leads to a better level of understanding.

One other complaint-- the spine of the book couldn't keep the pages together under heavy use.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Good Book For Learning And Passing the Exam, April 27, 2001

By 

"angithi" (San Jose, CA United States) - See all my reviews

This review is from: Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit (Paperback)

This book was a great book. I have had 3 years of experience in data-warehousing, but after reading this book I was able to learn lot of new things. The exam is a tough one. I would recommend reading the entire book and then going through the transcender. By the way I passed the test.