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:
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:
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 firstname.lastname@example.org.
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;
Descrizione libro Paperback. Condizione libro: BRAND NEW. BRAND NEW. Fast Shipping. Prompt Customer Service. Satisfaction guaranteed. Codice libro della libreria 0735626367BNA
Descrizione libro Condizione libro: Brand New. PAPERBACK,Book Condition New, Brand New, Softcover, International Edition. We Do not Ship APO FPO AND PO BOX. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Codice libro della libreria ABESTTND1348
Descrizione libro Microsoft Press, 2009. Paperback. Condizione libro: New. book. Codice libro della libreria 0735626367
Descrizione libro 2009. Soft cover. Condizione libro: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Codice libro della libreria UN-PH-IN-1528
Descrizione libro Microsoft Press, 2009. Paperback. Condizione libro: New. Codice libro della libreria P110735626367
Descrizione libro Microsoft Press, 2009. Paperback. Condizione libro: New. 1 Pap/Cdr. Codice libro della libreria DADAX0735626367
Descrizione libro Microsoft Pr, 2009. Paperback. Condizione libro: Brand New. paperback/cd-rom edition. 650 pages. 9.00x7.25x2.25 inches. In Stock. Codice libro della libreria __0735626367