|
|
|
1.
|
|
Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: - Create SSIS packages; troubleshoot data flow and control flow
- Configure, debug, and deploy SSIS solutions
- Develop SSAS cubes for OLAP and data mining services
- Implement custom logic with MDX
- Optimize storage design and query performance
- Create SSRS reports; enable interactivity; write custom code
- Manage the report environment
- Configure security features for SSIS, SSAS, and SSRS
Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies. Your kit includes: - 15% exam discount from Microsoft. Offer expires 12/31/13. Details inside.
- Official self-paced study guide.
- Practice tests with multiple, customizable testing options and a learning plan based on your results.
- 200 practice and review questions.
- 180-day trial of SQL Server 2008 Enterprise Edition.
- Case scenarios, exercises, and best practices.
- Fully searchable eBook of this guide, plus sample chapters from related books.
...
|
|
2.
|
|
Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-445, the required exam for the new Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 Business Intelligence 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 the technology skills required to build business intelligence applications using SQL Server 2005, this official study guide covers topics such as installing, configuring, and deploying SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services. Then assess yourself using hundreds of practice questions on the CD, featuring multiple, customizable testing options 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 SQL Server 2005 Enterprise Edition software and an exam discount voucher--making this kit an exceptional value and a great career investment....
|
|
3.
|
|
An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them. - Shows you how to design SSIS solutions for data cleansing, ETL and file management
- Demonstrates how to integrate data from a variety of data sources,
- Shows how to monitor SSIS performance,
- Demonstrates how to avoid common pitfalls involved with SSIS deployment
- Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages
- The companion Web site provides sample code and database scripts that readers can directly implement
This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day....
|
|
