出版社:Microsoft Press
出版日期:2007-9
ISBN:9780735623415
作者:Erik Veerman,Teo Lachev,Dejan Sarka,Javier Loria,Solid Quality Learning
页数:568页
作者简介
在线阅读本书
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.
书籍目录
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
内容概要
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.