MCTS自步培训教程

内容概要

Erik Veerman, Teo Lachev, Dejan Sarka, and Javier Loria each hold multiple Microsoft certifications and together represent 45 years of SQL Server experience. They work at Solid Quality Mentors where they combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the SQL Server database platform.

书籍目录

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 Summary3 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 Summary4 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 Packages6 Developing SSAS Cubes7 Extending SSAS Cubes8 Defining SSAS Storage, Partitions, and Aggregations9 Developing SSAS Data Mining Models10 Developing SSRS Reports11 Formatting and Extending SSRS Reports12 Deploying and Configuring SSlS Packages13 Deploying and Processing SSAS Objects14 Deploying and Scheduling SSRS Reports15 Securing and Executing SSlS Packages16 Administering and Securing SSAS Cubes17 Securing and Querying SSAS Data Mining Models18 Managing and Securing SSRS Reports

作者简介

在线阅读本书



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.

 MCTS自步培训教程下载