[0]

Microsoft SQL Server 2005 BI - MCTS

Overview CurriculumWhat's IncludedTestimonialsPricing

Getting MCTS certified shows you have arrived.
The knowledge that comes with it shows how you got there.

During our 7-day Microsoft Certified Technology Specialist in SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI) Training Camp, students will live, learn, and take the exams at one of our state-of-the-art education centers. This blended-learning course employs outcome-based (Lecture | Lab | Review)™ delivery that focuses on preparing you with the real-world skills required to pass the simulator-based exams (and to hit the ground running in your career). During our MCTS: Microsoft SQL Server 2005 Business Intelligence course, you will learn to implement and maintain business intelligence solutions. and have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite.

HOW WE ARE BETTER

You will get certified.

We save you time. And money.

Our experts make learning easier.

We guarantee it.

Contact Us

A few reasons to get certified.

75% of managers believe that certification is important to team performance.

71% of employees believed Microsoft certification helped them receive a promotion or raise from their current employer.

66% of managers believe that certification improves the level of service and support offered to IT end users/customers.

55% of hiring managers consider employee certification as criterion for hiring.

65% of certified professionals surveyed had been in their jobs 24 months or longer.

(Sources: Fairfield Research survey, Zoomerang, “Prometric IT Candidate Study”, IDC whitepaper, “Value of Certification, Nov 2006”)

Is this course right for you?

This course is intended for students with a working knowledge of schemas and of debugging, monitoring, and troubleshooting in SQL Server. Relevant job titles include:

Database Administrator
Database Technician
Database Specialist

Each training day is segmented into Lecture, Lab, and Review components that cater to a student's multiple learning styles (auditory, visual, and kinesthetic-tactual).

*Note that significant changes may be made to the schedule on a daily basis to ensure that the goals of the course are met.

Days 1-2	Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services – Course 2791
Topics	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; Adding .NET Assemblies. 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.
Days 3-4	Implementing and Maintaining Microsoft SQL Server 2005 Integration Services – Course 2792
Topics	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 Packages; 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; Working with Windows Event Log.
Days 5-6	Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services – Course 2793
Topics	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 Builder.
Day 7	Final Review
Exam	Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance

Training Camp offers the highest quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on learning and certification objectives.

	Intensive Hands-on Training by Certified Trainers Utilizing Our (Lecture \| Lab \| Review)™ Delivery		Examination Vouchers & On-site Certification Testing
	Optional Package of Hotel Accommodations, Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee Available		Blended-learning Instruction Comprised of Comprehensive Study Materials, Lab Manuals, and Practice Exams
	Extended Lab and Instructor Access		Examination Passing Policy Guarantee More Details
			Should a student complete a Training Camp Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year. Students will only be responsible for accommodation and vendor exam fees.

Training Camp is proud to share in our students' success. Here is what they are saying about us:

The staff and the accommodations are great. They'll do whatever you need, or whatever you want while you're there. Being able to be "isolated" for two weeks to concentrate on nothing but the course is critical. I'm looking forward to sending our other system engineers to the Camp.

Patrick Fisher, Intrinsic

The Training Camp is a fantastic training facility, and I will recommend it to my peers. The staff is friendly, knowledgeable, and very concerned that you both understand the information as well as complete your desired certification. This program is not to be taken lightly, will tax the most committed person, and the pre-qualifications should be met to the letter. If you come here for a vacation you are in the wrong place, if you are serious and have a sincere desire to win in your field; this program is for you. I finished today, both fully satisfied and very fatigued.

Randy Browning, Varian Medical Systems

I highly recommend the CCENT/CCNA/CCDA class. The material is very good and prepares you well for the tests. Our instructor also gave us a lot of good insights into networking and switching from his extensive background.

Richard F Boule, ADI, Inc