Mcts Self-paced Training Kit Exam 70-448: Microsoft SQL Server 2008--business Intelligence Development and Maintenance - Brossura

Veerman, Erik; Lachev, Teo; Sarka, Dejan

Brossura

ISBN 10: 0735626367 ISBN 13: 9780735626362

Casa editrice: Microsoft Pr, 2009

Riassunto

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.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Su questo libro

L'autore

Erik Veerman is a Microsoft® MVP for SQL Server®, an award-winning BI solution developer, and a popular speaker, instructor, and author. He shares his expertise with OLAP design, ETL processing, and dimensional modeling as a mentor for Solid Quality Mentors.

Teo Lachev has more than a decade of experience in designing and developing Microsoft®-centered solutions. He is technical architect for a leading financial institution where he designs and implements Business Intelligence applications for the banking industry. Teo is a Microsoft Most Valuable Professional (MVP) for SQL Server®, Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Trainer (MCT). He lives with his family in Atlanta, GA.

Dejan Sarka is MCT and MCDBA certified and a Microsoft® MVP for SQL Server®. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

Contenuti

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;

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2009
• ISBN 10: 0735626367
• ISBN 13: 9780735626362
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 650