- 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: 57 customer reviews
- Amazon Best Sellers Rank: #357,751 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.
All Books, All the Time
Read author interviews, book reviews, editors picks, and more at the Amazon Book Review. 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.
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.
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.