COURSES

MCTS: SQL Server 2008 Business Intelligence Development and Maintenance


Course Description and Overview

Overview

SecureNinja’s MCTS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance training and certification boot camp in Washington, DC will teach you experience in working with implementing and maintaining solutions by using the Microsoft SQL Server 2005 Business Intelligence tool suite. . This course  will prepare you for Exam 70-448: TS: Microsoft SQL Server 2005 Business Intelligence - Development and Maintenance

Special Offer:      

Microsoft Certification Exam Packs with free Second Shot offers – Save up to 20%

Take your IT career to its next destination. Improve your knowledge in one specific technology, earn multiple Microsoft Certified Technology Specialist (MCTS) certifications to show breadth across different products, or build on the MCTS to earn a Microsoft Certified IT Professional (MCITP) certification with Microsoft Certification Exam Packs with Second Shots. Microsoft Certification Exam Packs provide large discounts plus a Second Shot for every exam in the pack. The Second Shot offer allows you to retake an exam if you do not pass it the first time. 

Topics Covered
 

Implementing an SSIS Solution  Day 1

  • Implement control flow.
    This objective may include but is not limited to: checkpoints; debug control flow; transactions; implement the appropriate control flow task to solve a problem; data profiling and quality
  • Implement data flow.
    This objective may include but is not limited to: debug data flow; implement the appropriate data flow components
  • Implement dynamic package behavior by using property expressions.
  • Implement package logic by using variables.
    This objective may include but is not limited to: system variables; user variables; variable scope
  • Implement package configurations.
  • Implement auditing, logging, and event handling.
    This objective may include but is not limited to: use system variables for auditing; use event handlers; propagate events; use log providers; data profiling
  • Extend SSIS packages by using .NET code.
    This objective may include but is not limited to: use the script task; use the script component; use custom assemblies

Configuring, Deploying, and Maintaining SSIS Day 2

  • Install and maintain SSIS components.
    This objective may include but is not limited to: implement disaster recovery for SSIS
  • Deploy an SSIS solution.
    This objective may include but is not limited to: deploy SSIS packages by using DTUTIL; deploy SSIS packages by using the deployment utility; deploy SSIS packages to SQL or file system locations
  • Manage SSIS package execution.
    This objective may include but is not limited to: schedule package execution by using SQL Server Agent; execute packages by using DTEXEC; execute packages by using SQL Server Management Studio; execute packages by using the SSIS .NET API
  • Configure SSIS security settings.
    This objective may include but is not limited to: MSDB database roles; package protection levels
  • Identify and resolve issues related to SSIS solution deployment.
    This objective may include but is not limited to: validate deployed packages; deploy packages and dependencies between servers

Implementing an SSAS Solution  - Day 3

  • Implement dimensions in a cube.
    This objective may include but is not limited to: translations; attribute relations; hierarchies
  • Implement measures in a cube.
    This objective may include but is not limited to: measure groups
  • Implement a data source view.
    This objective may include but is not limited to: named calculations; named queries
  • Configure dimension usage in a cube.
    This objective may include but is not limited to: implement reference dimensions; implement many to many relationships; implement fact relationships; implement role-playing relationships; define granularity
  • Implement custom logic in a cube by using MDX.
    This objective may include but is not limited to: actions; key performance indicators (KPI); calculated members; calculations
  • Implement data mining.
    This objective may include but is not limited to: implement data mining structures and models; query data mining structures by using DMX; data mining views
  • Implement storage design in a cube.
    This objective may include but is not limited to: aggregations; partitions; storage modes; proactive caching

Configuring, Deploying, and Maintaining SSAS  Day 4

  • Configure permissions and roles in SSAS.
    This objective may include but is not limited to: server roles; SSAS database roles; cube roles; enable client application access; implement custom access to data
  • Deploy SSAS databases and objects.
    This objective may include but is not limited to: Deployment Wizard; BIDS; SSMS; SSIS Analysis Services Execute DDL task
  • Install and maintain an SSAS instance.
    This objective may include but is not limited to: disaster recovery
  • Diagnose and resolve performance issues.
    This objective may include but is not limited to: use SQL Profiler; performance monitor counters; DMVs; Usage Based Optimization Wizard
  • Implement processing options.

Implementing an SSRS Solution  Day 5

  • Implement report data sources and datasets.
    This objective may include but is not limited to: query types; dynamic data sources; filter location (dataset vs. query)
  • Implement a report layout.
    This objective may include but is not limited to: apply conditional formatting; page configuration; headers and footers
  • Extend an SSRS solution by using code.
    This objective may include but is not limited to: custom .NET assembly; private code
  • Create an SSRS report by using an SSAS data source.
    This objective may include but is not limited to: MDX in an SSRS report; DMX in an SSRS report
  • Implement report parameters.
    This objective may include but is not limited to: databound parameters; multi-value parameters
  • Implement interactivity in a report.
    This objective may include but is not limited to: drilldown; drillthrough; interactive sorting
  • Implement report items.
    This objective may include but is not limited to: matrix; table; chart; image; list; grouping
  • Embed SSRS reports in custom applications.
    This objective may include but is not limited to: use the Windows Forms Report Viewer; use the Web Forms Report Viewer; use the SSRS Web service

Configuring, Deploying, and Maintaining  Day 5

  • Configure report execution and delivery.
    This objective may include but is not limited to: subscriptions; report caching; schedules; snapshot history
  • Install and configure SSRS instances.
    This objective may include but is not limited to: deploy an SSRS Web farm
  • Configure authentication and authorization for a reporting solution.
    This objective may include but is not limited to: configure server-level and item-level role-based security; configure Windows authentication and custom authentication
  • Deploy an SSRS solution.
    This objective may include but is not limited to: RS.exe scripts; Report Builder; BIDS
  • Configure SSRS availability.
    This objective may include but is not limited to: key management; migrate SSRS databases

Who Should Attend

This exam is intended for experts in implementing and maintaining solutions by using the Microsoft SQL Server 2005 Business Intelligence tool suite.

Prerequisites

The qualified candidate for this exam typically has the following experience or knowledge.
  • Knowledge of database schemas, both relational and multidimensional
  • Experience with and/or knowledge of implementing a cube in SQL Server Analysis Services (SSAS)
  • Experience with and/or knowledge of SSAS data mining algorithms
  • Experience creating and deploying SQL Server Reporting Services (SSRS) reports
  • Experience authoring and deploying SQL Server Integration Services (SSIS) packages
  • Experience working with the Microsoft .NET Framework 

Required Exams

  • Exam 70-448: TS: Microsoft SQL Server 2005 Business Intelligence Development and Maintenance

 

Course Length

40 Hours

Follow On Courses

  • MCTS: SQL Server 2008 Implementation and Maintenance
  • MCTS: SQL Server 2008 Database Developer
  • MCITP: Database Developer

About SecureNinja  

SecureNinja Training is the DC’s Area’s #1 Expert IT Training Center . We are conveniently located in beautiful Historic Old Town Alexandria, VA enhancing your training experience and featuring:

  • Metro Accessibility - Short walk from Metro Blue/Yellow Line (leave the car behind)
  • 4 minute Drive to Ronald Reagan Washington National Airport
  • Available Parking
  • World class restaurants and shops at your footsteps
  • Closest Expert IT & IT Security Training Center to Fort Belvoir, Boiling AFB, Fort Myer, Department of Homeland Security, US Department of Navy, US Coast Guard, Fort McNair, Washington Navy Yard and the Pentagon

 Why Choose SecureNinja for your Washington DC Expert IT Training?  

  • Expert Instructors
  • Highest Pass Rates
  • Choose from Day, Evening & Weekend Classes to meet your busy schedule
  • Accelerated Boot Camps Save You Time And Money
  • Personal 1-1 Mentoring
  • Paid Internships & Job Referrals!
  • Meet Your DoD 8570-1 Certification Needs. Get Compliant!
  • SecureNinja is the ONLY Testing Center that offers ALL 5 industry standard test vendors in the DC / Baltimore Metropolitan Area. ( VUE, Kryterion-Online, Certiport and Impact-Testing)
  • Lowest Prices! We are locally based keeping our overhead low so we can pass the savings along to you
  • Washington, DC is our Home.  Most training centers set up shop in hotels or rented centers.  When you have a need, request or encounter a problem they are not there to answer. Our physical location in Alexandria is open 7 days a week and our staff always there to help.

These training courses are only delivered as an onsite format for groups of 5 or more. Our world-class instructors will bring our on-demand turn-key solution directly to you. Contact us now for more details and pricing