Quick Registration:

Exam 70-448:

• TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Audience Profile

Candidates for this exam are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:

• One to two years of experience working with the Microsoft .NET Framework
• Two to three years of experience using SQL Server 2005 BI components
• Six months to one year of experience using SQL Server 2008
• Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
• Experience using Microsoft SQL Server Management Studio (SSMS)
• Knowledge of relational and multi-dimensional database schemas
• Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
• Experience creating and deploying a data mining model in SSAS
• Experience writing relational and multi-dimensional database queries
• Experience creating and deploying SQL Server Reporting Services (SSRS) reports
• Experience authoring and deploying SQL Server Integration Services (SSIS) packages
• Experience debugging, monitoring, and troubleshooting BI solutions

Credit Toward Certification When you pass Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, you complete the requirements for the following certification(s):

• Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Implementing an SSIS Solution (17 percent)

• Implement control flow.
• Implement data flow.
• Implement dynamic package behavior by using property expressions.
• Implement package logic by using variables.
• Implement package configurations.
• Implement auditing, logging, and event handling.
• Extend SSIS packages by using .NET code.

Configuring, Deploying, and Maintaining SSIS (15 percent)

• Install and maintain SSIS components.
• Deploy an SSIS solution.
• Manage SSIS package execution.
• Configure SSIS security settings.
• Identify and resolve issues related to SSIS solution deployment.

Implementing an SSAS Solution (21 percent)

• Implement dimensions in a cube.
• Implement measures in a cube.
• Implement a data source view.
• Configure dimension usage in a cube.
• Implement custom logic in a cube by using MDX.
• Implement data mining.
• Implement storage design in a cube.

Configuring, Deploying, and Maintaining SSAS (17 percent)

• Configure permissions and roles in SSAS.
• Deploy SSAS databases and objects.
• Install and maintain an SSAS instance.
• Diagnose and resolve performance issues.
• Implement processing options.

Implementing an SSRS Solution (17 percent)

• Implement report data sources and datasets.
• Implement a report layout.
• Extend an SSRS solution by using code.
• Create an SSRS report by using an SSAS data source.
• Implement report parameters.
• Implement interactivity in a report.
• Implement report items.
• Embed SSRS reports in custom applications.

Configuring, Deploying, and Maintaining SSRS (13 percent)

• Configure report execution and delivery.
• Install and configure SSRS instances.
• Configure authentication and authorization for a reporting solution.
• Deploy an SSRS solution.
• Configure SSRS availability.

Exam 70-433:

• TS: Microsoft SQL Server 2008, Database Development

Audience Profile

Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:

• IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
• IT professionals who manage systems that run SQL Server 2008
• Developers who build applications that use SQL Server 2008
• IT professionals who work with third-party applications that are built on SQL Server 2008

Credit Toward CertificationWhen you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development, you complete the requirements for the following certification(s):

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Implementing Tables and Views (14 percent)

• Create and alter tables.
• Create and alter views.
• Create and alter indexes.
• Create and modify constraints.
• Implement data types.
• Implement partitioning solutions.
  
  

Implementing Programming Objects (16 percent)

• Create and alter stored procedures.
• Create and alter user-defined functions (UDFs).
• Create and alter DML triggers.
• Create and alter DDL triggers.
• Create and deploy CLR-based objects.
• Implement error handling.
• Manage transactions.
  
  

Working with Query Fundamentals (21 percent)

• Query data by using SELECT statements.
• Modify data by using INSERT, UPDATE, and DELETE statements.
• Return data by using the OUTPUT clause.
• Modify data by using MERGE statements.
• Implement aggregate queries.
• Combine datasets.
• Apply built-in scalar functions.
  

Applying Additional Query Techniques (15 percent)

• Implement subqueries.
• Implement CTE (common table expression) queries.
• Apply ranking functions.
• Control execution plans.
• Manage international considerations.
  
  

Working with Additional SQL Server Components (11 percent)

• Integrate Database Mail.
• Implement full-text search.
• Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
• Implement Service Broker solutions.
• Track data changes.
  
  

Working with XML Data (12 percent)

• Retrieve relational data as XML.
• Transform XML data into relational data.
• Query XML data.
• Manage XML data.
  
  

Gathering Performance Information (11 percent)

• Capture execution plans.
• Gather trace information by using the SQL Server Profiler.
• Collect output from the Database Engine Tuning Advisor.
• Collect information from system metadata.

Exam 70-432:

• TS: Microsoft SQL Server 2008, Implementation and Maintenance

Audience Profile

Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:

• IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
• IT professionals who manage systems that run SQL Server 2008
• IT professionals who work with third-party applications that are built on SQL Server 2008
• Developers who build applications that use SQL Server 2008

Credit Toward Certification When you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance, you complete the requirements for the following certification(s):

• Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Installing and Configuring SQL Server 2008 (10 percent)

• Install SQL Server 2008 and related services.
• Configure SQL Server instances Configure SQL Server services.
• Configure additional SQL Server components.
• Implement database mail.
• Configure full-text indexing.

Maintaining SQL Server Instances (13 percent)

• Manage SQL Server Agent jobs.
• Manage SQL Server Agent alerts.
• Manage SQL Server Agent operators.
• Implement the declarative management framework (DMF).
• This objective may include but is not limited to: operating system-level concepts

Managing SQL Server Security (15 percent)

• Manage logins and server roles.
• Manage users and database roles.
• Manage SQL Server instance permissions.
• Manage database permissions.
• Manage schema permissions and object permissions.
• Audit SQL Server instances.
• Manage transparent data encryption.
• Configure surface area.

Maintaining a SQL Server Database (16 percent)

• Back up databases.
• Restore databases.
• Manage and configure databases.
• Manage database snapshots.
• Maintain database integrity.
• Maintain a database by using maintenance plans.

Performing Data Management Tasks (14 percent)

• Import and export data.
• Manage data partitions.
• Implement data compression.
• Maintain indexes.
• Manage collations.

Monitoring and Troubleshooting SQL Server (13 percent)

• Identify SQL Server service problems.
• Identify concurrency problems.
• Identify SQL Agent job execution problems.
• Locate error information.

Optimizing SQL Server Performance (10 percent)

• Implement Resource Governor.
• Use the Database Engine Tuning Advisor.
• Collect trace data by using SQL Server Profiler.
• Collect performance data by using Dynamic Management Views (DMVs).
• Collect performance data by using System Monitor.
• Use Performance Studio.

Implementing High Availability (9 percent)

• Implement database mirroring.
• Implement a SQL Server clustered instance.
• Implement log shipping.
• Implement replication.

Microsoft SQL Server Certification

Master the new features and capabilities of Microsoft SQL Server by earning a Microsoft Certified Technology Specialist (MCTS) or Microsoft Certified IT Professional (MCITP) certification. Both certifications help you gain hands-on experience, in-depth expertise, and industry-recognized validation, which inspire customer and employer confidence in your skills.

The Microsoft SQL Server 2008 certifications offer you more choice and simpler paths to achieve your certification goals. These certifications differentiate technology skills and job-role skills, and validate actual IT roles.

Microsoft Certified Technology Specialist

By earning an MCTS certification, you can display your in-depth technical knowledge and skill in using key technology areas in Microsoft SQL Server 2008. You can demonstrate your depth of knowledge in one specific area, earn multiple MCTS certifications to show breadth of knowledge across different areas, or build on one MCTS certification to earn a Professional Series credential.

Three MCTS certifications on Microsoft SQL Server 2008 are available.

Choosing the right certification path

Training cost: PKR 12,000.00 per paper inclusive of course material, exam guide & dumps.
Duration: One Month (each paper).

Exam 70-562:

• TS: Microsoft .NET Framework 3.5, ASP.NET Application Development

Audience Profile

Candidates for this exam use Microsoft Visual Studio in a team-based, medium-sized to large development environment. Candidates should have a minimum of two to three years of experience developing Web-based applications by using Microsoft ASP.NET. Candidates should also have a minimum of one year of experience with the following:

• Database access by using Microsoft ADO.NET classes in the Microsoft .NET Framework
• Web services
• State management
• ASP.NET configuration
• Monitoring Web applications
• Debugging
• Application and page life-cycle management
• Security aspects such as Forms Authentication and membership and roles
• ECMAScript (JavaScript, Microsoft JScript)
• Internet Information Server (IIS)

Candidates should be very familiar with Visual Studio 2005 or later and the .NET Framework classes that are related to ASP.NET and ADO.NET. In addition, candidates should have a good grasp of ASP.NET AJAX.

Credit Toward CertificationExam 70-562: TS: Microsoft .NET Framework 3.5, ASP.NET Application Development: counts as credit toward the following certification(s):

• Microsoft Certified Technology Specialist (MCTS): .NET Framework 3.5, ASP.NET Applications
• Microsoft Certified Professional Developer (MCPD): ASP.NET Developer 3.5
• Microsoft Certified Professional Developer (MCPD): Enterprise Applications Developer 3.5

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Configuring and Deploying Web Applications (10 percent)

• Configure providers.
• Configure authentication, authorization, and impersonation.
• Configure projects, solutions, and reference assemblies.
• Configure session state by using Microsoft SQL Server, State Server, or InProc.
• Publish Web applications.
• Configure application pools.
• Compile an application by using Visual Studio or command-line tools. May include but is not limited to: aspnet_compiler.exe, Just-In-Time (JIT) compiling, aspnet_merge.exe

Consuming and Creating Server Controls (20 percent)

• Implement data-bound controls.
• Load user controls dynamically.
• Create and consume custom controls.
• Implement client-side validation and server-side validation.
• Consume standard controls.

Working with Data and Services (17 percent)

• Read and write XML data.
• Manipulate data by using DataSet and DataReader objects.
• Call a Windows Communication Foundation (WCF) service or a Web service from an ASP.NET Web page.
• Implement a DataSource control. May include but is not limited to: LinqDataSource, ObjectDataSource, XmlDataSource, SqlDataSource
• Bind controls to data by using data binding syntax.

Troubleshooting and Debugging Web Applications (16 percent)

• Configure debugging and custom errors. May include but is not limited to: ,
• Set up an environment to perform remote debugging.
• Debug unhandled exceptions when using ASP.NET AJAX. May include but is not limited to: client-side Sys.Debug methods; attaching a debugger to Windows Internet Explorer
• Implement tracing of a Web application. May include but is not limited to: Trace.axd, Trace=True on @Page directive,
• Debug deployment issues. May include but is not limited to: aspnet_regiis.exe; creating an IIS Web application; setting the .NET Framework version
• Monitor Web applications. May include but is not limited to: health monitoring by using WebEvent, performance counters

Working with ASP.NET AJAX and Client-Side Scripting (15 percent)

• Implement Web Forms by using ASP.NET AJAX. May include but is not limited to: EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy
• Interact with the ASP.NET AJAX client-side library. May include but is not limited to: JavaScript Object Notation (JSON) objects; handling ASP.NET AJAX events
• Consume services from client scripts.
• Create and register client script. May include but is not limited to: inline, included .js file, embedded JavaScript resource, created from server code

Targeting Mobile Devices (5 percent)

• Access device capabilities. May include but is not limited to: working with emulators
• Control device-specific rendering. May include but is not limited to: DeviceSpecific control; device filters; control templates
• Add mobile Web controls to a Web page. May include but is not limited to: StyleSheet controls; List controls; Container controls
• Implement control adapters. May include but is not limited to: App_Browsers; rendering by using ChtmlTextWriter or XhtmlTextWriter

Programming Web Applications (17 percent)

• Customize the layout and appearance of a Web page.
• Work with ASP.NET intrinsic objects.
• Implement globalization and accessibility.
• Implement business objects and utility classes.
• Implement session state, view state, control state, cookies, cache, or application state.
• Handle events and control page flow.
• Implement the Generic Handler.

Exam 70-561:

• TS: Microsoft .NET Framework 3.5, ADO.NET Application Development

Audience Profile

Candidates for this exam use Microsoft Visual Studio to develop data-access portions of applications. Candidates should have a minimum of two to three years of experience developing Web, Windows, or distributed applications by using the Microsoft .NET Framework. Candidates should have a thorough understanding of relational database concepts and should have a minimum of one to two years of experience using Microsoft SQL Server and other relational database management systems, such as Oracle, DB2, and MySQL.

In addition, candidates should have a good grasp of the following:

• Structured Query Language (SQL)
• Stored procedures
• Data-bound controls

Credit Toward Certification Exam 70-561: TS: Microsoft .NET Framework 3.5, ADO.NET Application Development: counts as credit toward the following certification(s):

• Microsoft Certified Technology Specialist (MCTS): .NET Framework 3.5, ADO.NET Applications
• Microsoft Certified Professional Developer (MCPD): Enterprise Applications Developer 3.5

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Connecting to Data Sources (12 percent)

• Manage connection strings.
• Manage connection objects.
• Work with data providers.
• Connect to a data source by using a generic data access interface.
• Handle and diagnose database connection exceptions.

Selecting and Querying Data (22 percent)

• Build command objects.
• Query data from data sources.
• Retrieve data source data by using the DataReader.
• Manage data by using the DataAdapter or the TableAdapter.
• Execute an asynchronous query.
• Handle special data types.
• Query data sources by using LINQ.
• Manage exceptions when selecting data.

Modifying Data (24 percent)

• Manage transactions.
• Manage data integrity.
• Update data.
• Manage exceptions when modifying data.
• Transform data by using LINQ.

Synchronizing Data (15 percent)

• Monitor event notifications.
• Cache data.
• Manage update conflicts between online data and offline data.
• Partition data for synchronization.
• Implement Synchronization Services.

Working with Disconnected Data (16 percent)

• Manage occasionally connected data.
• Programmatically create data objects.
• Work with untyped DataSets and DataTables.
• Expose a DataTableReader from a DataTable or from a DataSet.
• Work with strongly typed DataSets and DataTables.

Object Relational Mapping by Using the Entity Framework (11 percent)

• Define and implement an Entity Data Model.
• Query data by using Object Services.
• Map data by using the Entity SQL Language.
• Access entity data by using the EntityClient Provider.

Exam 70-505:

• TS: Microsoft .NET Framework 3.5, Windows Forms Application Development

Audience Profile

Candidates for this exam work on a team in a development environment that uses Microsoft Visual Studio .NET 2008 and the Microsoft .NET Framework 3.5 to create Windows-based applications. Candidates should have at least one year of experience developing Windows-based applications by using the .NET Framework 2.0 and should be able to demonstrate the following:

• a solid understanding of Windows Forms applications in the context of the.NET Framework 3.5 solution stack
• experience programming against the System.Windows.Forms object model
• experience creating graphical user interface applications
• experience creating data-driven user interfaces (UI)
• experience deploying Windows applications

Credit Toward Certification Exam 70-505: TS: Microsoft .NET Framework 3.5, Windows Forms Application Development: counts as credit toward the following certification(s):MCTS: .NET Framework 3.5, Windows Forms Applications

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.

Creating a UI for a Windows Forms Application by Using Standard Controls (13%)

• Add and configure a Windows Form.
• Manage control layout on a Windows Form.
• Add and configure a Windows Forms control.
• Create and configure menus.
• Create event handlers for Windows Forms and controls.

Integrating Data in a Windows Forms Application (22%)

• Implement data-bound controls.
• Manage connections and transactions.
• Create, add, delete, and edit data in a connected environment.
• Query data from data sources by using LINQ
• Create, add, delete, and edit data in a disconnected environment.
• Manage XML by using the XML Document Object Model (DOM).
• Read, write, and validate XML by using the XmlReader class and the XmlWriter class.

Implementing Printing and Reporting Functionality in a Windows Forms Application (11%)

• Manage the print process by using print dialogs.
• Construct print documents.
• Enable security features for printing in a Windows Forms application
• Create a customized PrintPreview component.

Enhancing Usability (13%)

• Perform drag and drop operations.
• Implement globalization and localization for a Windows Forms application.
• Implement accessibility features
• Create and configure multiple-document interface (MDI) forms.
• Create, configure, and customize user assistance controls and components.
• Persist Windows Forms application settings between sessions

Implementing Asynchronous Programming Techniques to Improve the User Experience (15%)

• Manage a background process by using the BackgroundWorker component.
• Change the appearance of a UI element by using triggers.
• Implement an asynchronous method.

Deploying Windows Forms Controls (11%)

• Create a composite Windows Forms control.
• Create a custom Windows Forms control by inheriting from the control class
• Create an extended control by inheriting from an existing Windows Forms control

Configuring and Deploying Applications (15%)

• Configure the installation of a Windows Forms application by using ClickOnce technology.
• Install a Windows Presentation Foundation (WPF) browser application by using ClickOnce
• Install a Visual Studio Tools for Office (VSTO) application by using ClickOnce
• Configure and work with Windows Vista User Account Control (UAC) by using ClickOnce deployments
• Create a Windows Forms setup application.
• Set appropriate security permissions to deploy the application.
• Configure Trusted Application deployments
• Configure security features in an application.

Exam 70-504:

• TS: Microsoft .NET Framework 3.5 – Workflow

Audience Profile

Candidates for Exam 70-504 use Microsoft Visual Studio 2008 and the Microsoft .NET Framework 3.5 to build applications that automate workflow. Candidates should have a minimum of one year of experience developing either Windows-based or Web-based applications by using the .NET Framework and should be able to demonstrate the following by using Windows Workflow Foundation (WF).

• A solid understanding of WF in the context of the .NET Framework 3.5 solution stack
• Experience creating both sequential and state machine workflows
• Experience using various workflow activities
• Experience creating custom activities
• Experience maintaining state in a workflow
• Experience managing transactions and handling errors in a workflow

Credit Toward Certification Exam 70-504: TS: Microsoft .NET Framework 3.5 – Workflow: counts as credit toward the following certification(s):

• Microsoft Certified Technology Specialist (MCTS): Microsoft .NET Framework 3.5, Windows Workflow Foundation Applications

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Creating and Hosting Workflows (14 percent)

• Create state machine workflows.
• Create sequential workflows.
• Select workflow authoring mode.
• Host a workflow and designer in an application.
• Initialize and manage the workflow life cycle.
• Modify a workflow at runtime.

Communicating with Workflows (23 percent)

• Handle events from the host.
• Call methods on the host.
• Consume services from a workflow.
• Expose workflow as a service.

Creating and Configuring Custom Activities (25 percent)

• Create custom activities.
• Create custom composite activities.
• Define custom activity layout.
• Add dependency properties.
• Communicate with the host from a custom activity.
• Customize activity serialization.

Applying Rules and Conditions (13 percent)

• Write rule sets.
• Define rule chaining, priority, and property dependency.
• Change rules at runtime.
• Execute rule sets.
• Implement conditional branching logic.

Managing Transactions and Compensations (13 percent)

• Create and manage transactional workflows.
• Create and handle compensations.
• Enlist batch process in a transaction.
• Perform exception handling.
• Handle cancellations.

Creating and Managing Runtime Services (12 percent)

• Create a runtime service.
• Hydrate and dehydrate workflows.
• Track workflows.
• Monitor workflows.