- Series: Microsoft Press Training Kit
- Paperback: 600 pages
- Publisher: Microsoft Press; 1 edition (December 25, 2012)
- Language: English
- ISBN-10: 0735666091
- ISBN-13: 978-0735666092
- Product Dimensions: 7.4 x 1.9 x 8.9 inches
- Shipping Weight: 2.7 pounds (View shipping rates and policies)
- Average Customer Review: 3.4 out of 5 stars See all reviews (56 customer reviews)
- Amazon Best Sellers Rank: #312,432 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
About the Author
Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.
Browse award-winning titles. See more
If you are a seller for this product, would you like to suggest updates through seller support?
Top customer reviews
Now having said that, you will need to factor in the horrible state of the practice content. About 1/2 of the practice exercises don't work as presented. I have a good bit of experience in this field and managed to get through almost every exercise. But it was a struggle. I'd estimate that I spent at least 10 additional hours troubleshooting and cleaning up code. Much of the code is SSIS and quite a few packages (including the "Solution" packages)are blank! Some packages build on others as you progress through the lessons, so you might try jumping ahead to find some working code.
Now let's discuss the sample questions and included practice tests. I made sure that I understood every Chapter Lesson Question and all 186 Practice Test Questions thoroughly. Took the test and scored 628. Bummer. The Cert Exam is nothing like the practice material provided in the book. I went through the entire book a second time and purchased another practice exam (Thanks MS for the 2nd Shot) and passed ok.
If you are comfortable with this topic, can troubleshoot/debug code and/or want a great reference book--This does the job. I keep the pdf version handy for on-the-job reference. If you are new to this topic and/or looking to get your MCSA (this was the final exam for me) you might want to look elsewhere. I struggled with a rating. Clearly the authors put a lot into this book, but it was a disastrous training kit. Good Luck.
It was also frustrating that some of the lessons required the 64-bit version of SQL Server.
As with all the SQL tests/books, the books will tell you over and over again about the "new way" of doing something and explain again and again why the "old way" should not be used -- but then you get to the test and 20% of the questions test how to do things the old way. Very frustrating.
The information may be reasonably accurate, but it gets very frustrating trying to troubleshoot an issue only to realize you did everything as specified, but the steps were wrong.
In case you are considering buying this book for the content and not to prepare for an exam, only the first two chapters of this book are actually about the design and implementation of data warehouses. The rest is basically a software users guide about SQL Server Integration Services (SSIS) ETL development using SQL Server Data Tools (SSDT). If you're looking for an actual user's guide for using SSIS, there are probably better books out there. This one seems pretty sloppily put together.
I had the same issue with the Training Kit for 70-448.
The exercises still have errors, I expected them to be fixed by now and all fixes to be included in the download. Those were easy to fix and a good exercise on its own, but still doesn't feel right.
The ultimate test for the quality of the book will be the actual exam. Then I'll know if it was worth the time and effort as well. I haven't taken it yet, earning my daily bread takes most of my time and energy.