MCTS自步培训教程(Exam 70-445)：Microsoft SQL Server 2005 Business Intelligence 实现与维护（1-CD;1-DVD-Eval） 115盘 下载 pdf txt 电子版 mobi snb docx

This 2-in-1 training kit delivers in-depth preparation plus practice for 70-445, an exam for the MCTS: SQL Server 2005 Business Intelligence certification. Ace exam prepand build real-world job skillswith lessons, labs, practice tests, and more. Work at your own pace through the lessons and lab exercises.

Introduction

1 Installing SQL Server 2005 Business Intelligence Tools

Before You Begin

Lesson 1: Installing SQL Server 2005 Components

Selecting Installation Components

Choosing Installation Details

Practice: Installing SQL Server 2005 Components

Lesson 2: Performing Updates and Advanced Installations

Keeping Current with Service Packs

Clustering Analysis Services and Managing Instances

Installing Multiple Instances of Reporting Services

Practice: Installing a Service Pack

Case Scenario: Installing SQL Server 2005 Components for a BI Project

Chapter Summary

2 Configuring SQL Server 2005 Business Intelligence Components

Before You Begin

Lesson 1: Configuring the SSRS Architecture and Instances

Using the Report Server Configuration Manager Tool for

Server Setup and Management ;

Using the Reporting Services Command-Line Tools to Manage SSRS

Configuring the Report Server for SSL Communication and Internet Deployment

Practice: Managing SSRS Encryption Keys

Lesson 2: Setting SSAS Server Security and Server Properties

Setting SSAS Administrative Roles and Permissions

Editing SSAS Server Properties

Practice: Setting Up SSAS Query Logging

Case Scenario: Setting up your SSAS and SSRS Servers

Chapter Summary

3 Migrating to SQL Server 2005 Business Intelligence Components..

Before You Begin

Lesson 1: Upgrading SSAS

Architecture Changes

Migration Overview

Using the Analysis Services Migration Wizard

Post-Migration Considerations

Practice: Using the Analysis Services Migration Wizard

Lesson 2: Migrating to SSIS Packages

DTS and SSIS Differences

Executing and Managing DTS in SQL Server 2005

Running the Package Migration Wizard

Post-Migration Steps

Taking Advantage of SSIS Features

Practice: Migrating a DTS Package to SSIS

Case Scenario: Migrating to SQL Server 2005 Business

Intelligence Components

Chapter Summary

4 Developing SSlS Packages

Before You Begin

Lesson 1: Creating SSIS Packages

Using the Import and Export Wizard

Creating an SSIS Project in BIDS

Practice: Creating a New Project

Lesson 2: Defining Project Data Sources and Package Connections.Creating a Data Source

……

5 Debugging and Error Handling with SSlS Packages

6 Developing SSAS Cubes

7 Extending SSAS Cubes

8 Defining SSAS Storage, Partitions, and Aggregations

9 Developing SSAS Data Mining Models

10 Developing SSRS Reports

11 Formatting and Extending SSRS Reports

12 Deploying and Configuring SSlS Packages

13 Deploying and Processing SSAS Objects

14 Deploying and Scheduling SSRS Reports

15 Securing and Executing SSlS Packages

16 Administering and Securing SSAS Cubes

17 Securing and Querying SSAS Data Mining Models

18 Managing and Securing SSRS Reports

暂无相关内容，正在全力查找中

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：MCTS自步培训教程(Exam 70-445)：Microsoft SQL Server 2005 Business Intelligence 实现与维护（1-CD;1-DVD-Eval）在线阅读

在线听书地址：MCTS自步培训教程(Exam 70-445)：Microsoft SQL Server 2005 Business Intelligence 实现与维护（1-CD;1-DVD-Eval）在线收听

在线购买地址：MCTS自步培训教程(Exam 70-445)：Microsoft SQL Server 2005 Business Intelligence 实现与维护（1-CD;1-DVD-Eval）在线购买

暂无原文赏析，正在全力查找中！

编辑推荐

作者简介：Erik VeermanErik Veerman is a SQL Server MVP, MCT, and mentor for SolidQuality Mentors, focusing on the SQL Server BI platform. Erik ledthe ETL architecture and design for the first production imple- mentation of Integration Services (SSIS) and assisted with the ETL

standards and best practices for Microsoft's SQL Server 2005

Project REAL initiative. Erik is co-author of the books Professional 5QL 5erver 2005 Integration Services and Expert SQL 5erver 2005 Integration Services, and he assists in the leadership of the Atlanta SQL Server User's Group.

书籍介绍

在线阅读本书

EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-445and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what youve learned by applying your knowledge to 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: Install, configure, and manage SQL Server business intelligence components and tools Implement SQL Server Analysis Services cubes, create KPIs, work with MDX Build data mining models and configure algorithms Administer SQL Server Reporting Services and deploy information-rich solutions Develop and troubleshoot SQL Server Integration Services packages Implement package roles, protection levels, and passwords PRACTICE TESTS Assess your skills with 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 answersincluding a customized learning path that describes how and where to focus your studies. Your training kit includes: 15% exam discount from Microsoft. Offer expires 12/31/12. 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. Case scenarios, practice exercises, and best practices. 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition. Fully searchable eBook of this guide.