Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance / Edition 2by Erik Veerman
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… See more details below
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:
- Includes a 15% exam discount from Microsoft. (Limited time offer)
- 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.
- Microsoft Press
- Publication date:
- Edition description:
- New Edition
Table of Contents
Dedication; Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance; Acknowledgments; Introduction; Hardware Requirements; Software Requirements; Using the SQL Server Evaluation DVD and the Companion CD; System Requirements for the Companion CD; Microsoft Certified Professional Program; Technical Support; Evaluation Edition Software Support; Chapter 1: Developing SSIS Packages; 1.1 Before You Begin; 1.2 Lesson 1: Creating SSIS Packages and Data Sources; 1.3 Lesson 2: Creating and Editing Control Flow Objects; 1.4 Lesson 3: Using Data Flow Adapters and Transformations; 1.5 Case Scenario: Creating an ETL Solution; 1.6 Chapter Summary; Chapter 2: Debugging and Error Handling in SSIS; 2.1 Before You Begin; 2.2 Lesson 1: Configuring Package Transactions and Checkpoints; 2.3 Lesson 2: Identifying Package Status, Enabling Logging, and Handling Task Errors; 2.4 Lesson 3: Handling Data Flow Errors and Debugging; 2.5 Case Scenario: Troubleshooting and Handling Errors in SSIS Packages; 2.6 Chapter Summary; Chapter 3: Deploying and Configuring SSIS Packages; 3.1 Before You Begin; 3.2 Lesson 1: Using Package Configurations and Expressions; 3.3 Lesson 2: Deploying SSIS Packages; 3.4 Case Scenario: Deploying SSIS Packages; 3.5 Chapter Summary; Chapter 4: Administering, Securing, and Executing SSIS Packages; 4.1 Before You Begin; 4.2 Lesson 1: Managing the SSIS Service and Configuring Package Security; 4.3 Lesson 2: Executing and Scheduling Packages; 4.4 Case Scenario: Securing and Scheduling SSIS Packages; 4.5 Chapter Summary; Chapter 5: Developing SSAS Cubes; 5.1 Before You Begin; 5.2 Lesson 1: Creating Data Sources and Data Source Views; 5.3 Lesson 2: Creating and Modifying SSAS Cubes; 5.4 Lesson 3: Creating and Modifying Dimensions; 5.5 Lesson 4: Creating Measure Groups and Measures; 5.6 Case Scenario: Building an SSAS Solution as a Prototype; 5.7 Chapter Summary; Chapter 6: Extending SSAS Cubes; 6.1 Before You Begin; 6.2 Lesson 1: Defining User Hierarchies and Dimension Relationships; 6.3 Lesson 2: Creating KPIs, Actions, Translations, and Perspectives; 6.4 Lesson 3: Creating Calculations and Queries by Using MDX; 6.5 Case Scenario: Extending SSAS Cubes; 6.6 Chapter Summary; Chapter 7: Managing SSAS Storage, Processing, and Deployment; 7.1 Before You Begin; 7.2 Lesson 1: Defining Measure Group Partitions and Aggregations; 7.3 Lesson 2: Deploying SSAS Objects; 7.4 Lesson 3: Processing SSAS Objects; 7.5 Case Scenario: Implementing Low-Latency OLAP and Deployment Strategies; 7.6 Chapter Summary; Chapter 8: Securing and Administering SSAS; 8.1 Before You Begin; 8.2 Lesson 1: Setting Up SSAS Server Security; 8.3 Lesson 2: Managing SSAS High Availability, Backups, and Object Scripting; 8.4 Lesson 3: Managing SSAS Tuning and Logging; 8.5 Lesson 4: Tracing and Monitoring SSAS Instances; 8.6 Case Scenario: Administering and Securing SSAS Cubes; 8.7 Chapter Summary; Chapter 9: Working with SSAS Data Mining; 9.1 Before You Begin; 9.2 Lesson 1: Preparing and Creating Data Mining Structures; 9.3 Lesson 2: Creating Models and Applying Algorithms; 9.4 Lesson 3: Validating Models, Using DMX Queries, and Using Prediction Queries in Reports; 9.5 Lesson 4: Securing and Processing Data Mining Models; 9.6 Case Scenario: Working with SSAS Data Mining; 9.7 Chapter Summary; Chapter 10: Developing SSRS Reports; 10.1 Before You Begin; 10.2 Lesson 1: Creating SSRS Projects and Reports in BIDS; 10.3 Lesson 2: Creating a Dataset from a Data Source; 10.4 Lesson 3: Working with Advanced Report Object Properties; 10.5 Lesson 4: Applying Dataset Filters and Groups; 10.6 Case Scenario: Building Reports for the AdventureWorks Intranet; 10.7 Chapter Summary; Chapter 11: Extending and Deploying SSRS Reports; 11.1 Before You Begin; 11.2 Lesson 1: Assigning Parameters Within Reports; 11.3 Lesson 2: Using Expressions to Perform Advanced Report Item Formatting; 11.4 Lesson 3: Deploying New Reports and Changes; 11.5 Lesson 4: Using Reports in Your Code; 11.6 Case Scenario: Creating a Reporting Services Infrastructure; 11.7 Chapter Summary; Chapter 12: Scheduling and Securing Deployed Reports and Data Sources; 12.1 Before You Begin; 12.2 Lesson 1: Administering SSRS Item-Level Permissions and Site Security Roles; 12.3 Lesson 2: Creating Report Schedules and Subscriptions; 12.4 Lesson 3: Managing Report Caching and Execution Properties in Report Manager; 12.5 Case Scenario: Managing the Report Environment for Adventure Works; 12.6 Chapter Summary; Chapter 13: Configuring and Administering the SSRS Server; 13.1 Before You Begin; 13.2 Lesson 1: Installing and Configuring Initial Instances of SSRS; 13.3 Lesson 2: Configuring Advanced SSRS Settings and Scale-Out Deployment; 13.4 Case Scenario: Scaling Out Your SSRS Servers; 13.5 Chapter Summary; Answers; Chapter 1: Case Scenario Answers; Chapter 2: Case Scenario Answers; Chapter 3: Case Scenario Answers; Chapter 4: Case Scenario Answers; Chapter 5: Case Scenario Answers; Chapter 6: Case Scenario Answers; Chapter 7: Case Scenario Answers; Chapter 8: Case Scenario Answers; Chapter 9: Case Scenario Answers; Chapter 10: Case Scenario Answers; Chapter 11: Case Scenario Answers; Chapter 12: Case Scenario Answers; Chapter 13: Case Scenario Answers; References; Implementing an SSIS Solution; Configuring, Deploying, and Maintaining SSIS; Implementing an SSAS Solution; Configuring, Deploying, and Maintaining SSAS; Implementing an SSRS Solution; Configuring, Deploying, and Maintaining SSRS; About the Authors;
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >