MCTS Microsoft SQL Server Business Intelligence 7-Day Certification Training Boot Camp Class
 Microsoft Certified Technology Specialists MCTS Boot Camp training class for Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI)
teaches you how to implement and maintain business intelligence solutions. You will have thorough knowledge of the Microsoft SQL Server 2005 Business
Intelligence Development tool suite. You will gain knowledge of database schemas and of debugging, monitoring, and troubleshooting Business Intelligence solutions, and they know how to work with Microsoft .NET
Framework. Learn to write database queries, use SQL Server Analysis Services (SSAS) data mining algorithms, and create and deploy SQL Server Reporting
Services (SSRS) reports. Additionally, you will author and deploy SQL Server Integration Services (SSIS) packages.
Typically, Technology Specialists pursue careers as database administrators, database developers, or business intelligence developers. They may also be
developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.
Certification Exam Track
Microsoft Certified Technology Specialist (MCTS) enables professionals to
target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized
technologies. It allows them to pursue careers as web developers, windows developers, or enterprise application developers. At
Training Camp we offer an efficient approach to achieve your MCTS: SQL Server 2005 Business Intelligence certification in 7
days. The exams provide a valid and reliable measure of technical proficiency and expertise. During the MCTS: SQL Server 2005 Business Intelligence Training Camp, students will take the following exams.
Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance, 10-12 AM
Boot Camp Includes
- Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
- Comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software.
- Deluxe Package of Seven (7) Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee
- 24-Hour Lab and Instructor Access.
- Examination Vouchers & On-site Certification Testing.
- Examination Passing Policy.
Training Camp Curriculum
|
Days
|
Course
|
Details
|
|
1-2
|
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
|
- What is MS Business Intelligence
- Understanding UDM.
- OLAP Modeling.
- Using SSAS in BIDS.
- Creating KPIs; Creating Perspectives
- Creating Translations.
- Working with Multiple Fact Tables
- Using Advanced Dimension Types.
- Cube Storage and Aggregation: Basic Storage, MOLAP; Customizing Aggregations
- Advanced Storage, MOLAP, HOLAP or ROLAP; Implementing Proactive Caching
- Using Partitions, Relational or SSAS
- Understanding MDX; Members, Tuples, and Sets
- Creating MDX Functions.
- Understanding the Calculations Subtab
- Adding Calculated Members
- Adding MDX Scripts
- Adding Named Sets
- SSAS Administration: SSAS Security
- XMLA Scripts; SSAS Backup and Restore; Clustering
- Performance Optimization.
- Data Mining: Concepts; Algorithms
- Clients; Structure Processing.
- SSAS Clients: Excel 2003 Pivot Tables
- Reporting Services.
- Integration with SSAS: Implementing SQL Server SP2
- Excel 2007 Pivot Tables; Excel 2007 as a Data Mining Client
- MOSS BI Features.
|
|
2-4
|
Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
|
- Understanding SSIS; Exploring and Executing an SSIS Package in BIDS.
Control Flow in SSIS
- Control Flow Tasks
- Workflow Tasks
- Other SQL Server Tasks
- Precedence Constraints
- Data Processing Tasks.
- Data Flow
- Overview, Pipeline, Sources, Destinations
- Data Viewers; Transformations.
- Understanding Variables, Variables in Control Flow
- Variables in Data Flow
- Property Expressions
- Using Configurations
- Using Variables and Configurations between Packages.
- Using Containers; Support in SSIS
- Additional Control Flow Tasks.
- Error Logging and Handling
- Checkpoints; Package Logging
- Event Handling.
- Synchronous Transformations
- Asynchronous Transformations
- Working with Error Outputs
- Advanced Transformations.
Package Deployment
- Deployment Challenges
- Creating a Package Deployment Utility
- The Package Installation Wizard
- Deploy a Package to the File System
- Deploy a Package to SQL Server
- Redeploying Updated Packages.
- Package Management
- Managing Packages with DTUtil, with SSMS; Executing Packages
- Scheduling ackages
- SSIS Security.
- Extending SISS Capabilities Through Code
- SSIS Scripting; Scripting in Control Flows; Scripting in Data Flows
- Script Compilation; Custom SSIS Components.
- Best Practices: for Using SSIS, For Package Design; for Data Flow.
- Using SSIS beyond ETL
- Migrating SQL Server with SSIS
- SQL Server Maintenance Plans
- Working with Analysis Services
- Folder and File Management
|
|
5-6
|
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
|
- Tour of Features; Architecture
- Services Terminology
- Editions. Demonstrating SSRS
- Shared Data Sources
- Creating Reports from Scratch.
- Creating Expressions
- Using the Global Collections
- Formatting Items
- Conditional Formatting.
- Creating Groups
- Calculating Totals and Percentages
- Interactive Sorting; Creating Drill-Down Reports.
- Creating Report Parameters
- Creating Drop-Down List Parameters
- Multivalued Parameters; Debugging Parameter Issues.
- Creating a Matrix Report
- Accessorizing Your Matrix Report; Creating a Chart.
- Deploying SSRS Projects
- Exporting Reports and Printing
- Managing Reports with the Browser-Based Report Manager; Using SSMS-Based Reporting Services Manager.
- SSRS Security
- Security Access to Reports
- SSRS Virtual Directory Security
- Data Sources Security.
- The Reporting Services API
- URL Access
- Report Viewer Controls
- Using the Web Report Viewer Control with Client Reports
- Using the Windows Report Viewer Control with Client Reports.
- Using the Report Services Web Service
- Working with Custom Assemblies.
- Report Creating and Snapshots
- Creating Subscriptions
- Creating Data-Driven Subscriptions.
- Report Builder Architecture; Creating Report Model Projects
- Using Report Builde
|
|
7
|
Test
|
- Final Review, 8-10 AM
- Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and
|
|
Training Course Schedule
9/20/2010 9/26/2010 Washington, D.C. Metro
11/8/2010 11/14/2010 San Francisco, CA
12/13/2010 12/19/2010 Chicago, IL
****Refund Policy- For full refund, class or boot camp must be cancelled via email or fax at least 14 days prior to start of class.
CISSP cancellation period is 21 days do to arrangement of tests via ISC2.
|
