- 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: 58 customer reviews
- Amazon Best Sellers Rank: #269,298 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.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
This item, sold by Amazon.com, is currently reserved exclusively for Prime members.
- Unlimited Free Two-Day Shipping
- Instant streaming of over 40,000 movies and TV episodes
- A Kindle book to borrow for free each month - with no due dates
- Over a million songs and hundreds of playlists
Also available to Amazon Students. Check for eligibility
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
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
There was a problem filtering reviews right now. Please try again later.
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.
If you're a DBA or a Database Developer, you may want to brace yourself for many of the fuzzy topics the book will cover (pun intended). I think this is more a testament to the immature nature of many of the BI concepts and not so much a criticism of the book. In other words, you may find yourself cringing and wondering which consultant/marketer attempted to assign new industry terms that will stick and become universal in the BI world. I was also very skeptical of some of the "you should always..." proclamations in a couple early chapters.
I will say that it's cool that the companion CD will install a practice exam (built by MeasureUP). My next step is to run through that a few times.
I'll try to remember to update my review after I take the exam.
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.
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.