Microsoft MCTS .NET 4 Data Access, Windows and Service Communication Applications

The Microsoft MCTS .NET 4 Data Access, Windows and Service Communication Applications certification is designed to teach you the following:

• Developing Data Access Solutions with Microsoft Visual Studio 2010
• Developing Windows Applications with Microsoft Visual Studio 2010
• Developing Windows Communication Foundation Solutions with Microsoft Visual Studio 2010

You will be tested on the following exams:

• Exam 70-516 - TS: Accessing Data with Microsoft .NET Framework 4
• Exam 70-511 - TS: Windows Applications Development with Microsoft .NET Framework 4
• Exam 70-513 - TS: Windows Communication Foundation Development with Microsoft .NET Framework 4

Why .Net 4.0?

Microsoft is positioning Visual Studio 2010 as its tool platform to support Windows 7, Windows Server 2008 R2, Azure, SQL Server, Office 2010 and SharePoint 2010. The suite includes new drag and drop bindings for Silverlight and Windows Presentation Foundation; interoperability with the ASP.Net model view controller (MVC), better multicore support and UML support.

Below is a detailed list of new enhancements:

Visual Studio 2010

• Code Snippets
• New Profiles
• Generate from Usage
• Multi-Trageting
• Multi-Monitor
• Code Navigation in Class Files
• IntelliSense Improvements
• Enable Persisted Selection
• Add Reference Dialog
• Dynamic Lookup

C#

• Optional Parameters in C#
• Named Parameters in C#

ASP.NET 4.0

• Compressing Session Values
• Web.Config Transformation
• URL Routing
• Meta Tags
• Generating Client IDs
• Permanent Redirects
• New Browser Definitions
• New Publishing Project Interface

WCF 4.0

• Simple Configuration

Windows Applications 4.0

• Inclusion of WPF in the Windows Applications Exam

ADO.NET 4.0

• Foreign Keys in the Conceptual Model
• Self-Tracking Entities for N-Tier Application Development
• New Methods for N-Tier Application Development
• EntityDataSource Support for the QueryExtender Control
• Testability with IObjectSet
• Direct Execution of Store Commands
• Persistence-Ignorant Objects
• Lazy Loading of Related Objects
• Functions in LINQ to Entities Queries
• OrderBy Improvements in LINQ to Entities
• Customized Object-Layer Code Generation
• Model-First Support
• Complex Type Support
• Improved Model Browser Functionality

You will get answers to these questions:

• How is ASP.NET MVC different from building WebForms-based web applications?
• How does Entity Framework 4.0 help me build n-tier applications?

You will learn how to:

• Decouple your entity model from the data using Plain Old CLR Objects (POCOs).
• Write classes that can track changes to their own state for n-tier development with Entity Framework.
• Simplify your service deployment with zero config services with WCF 4.0.
• Write rich web applications that are simpler to unit test.
• Create REST based services based on the ASP.NET infrastructure

Modeling data

• Map entities and relationships by using the Entity Data Model
• Map entities and relationships by using LINQ to SQL
• Create and customize entity objects
• Connect a POCO model to the Entity Framework
• Create the database from the Entity Framework model
• Create model-defined functions

Managing Connections and Context

• Configure connection strings and providers
• Create and manage a data connection
• Secure a connection
• Manage the DataContext and ObjectContext
• Implement eager loading
• Caching data
• ADO.NET Data Services

Querying data

• Execute a SQL query
• Create a LINQ query
• Create an Entity SQL (ESQL) query
• Handle special data types
• Query XML data
• Query data using ADO.NET Data Services

Manipulating data

• Create, update, or delete data by using SQL statements
• Create, update, or delete data by using DataContext
• Manage Transactions
• Create disconnected objects

Developing and Deploying Reliable Applications

• Monitor and collect performance data
• Handle exceptions
• Protect data
• Synchronize data
• Deploy ADO.NET components

Building a User Interface by Using Basic Techniques

• Controls and control hierarchies
• Styles and theming
• Reusable resources
• Animation in WPF

Enhancing a User Interface by Using Advanced Techniques

• Routed events in WPF and WPF commanding
• User-defined controls and working with graphics
• Multimedia in WPF
• Control templates in WPF
• Create data, event, and property triggers in WPF

Managing Data at the User Interface layer

• Data Binding
• Value Converters in WPF
• Data validation
• Consuming change notification events
• Collections of data and binding hierarchical data
• Data templates in WPF

Enhancing the Functionality and Usability of a Solution

• Integration of WinForms and WPF
• Asynchronous processing and threading
• Globalization and localization
• Drag and drop operations
• Security
• User and application settings
• Dependency properties

Stabilizing and releasing a solution

• WPF test strategies
• Debug XAML using WPF visualize
• Debug WPF using PresentationTraceSources
• ClickOnce deployment
• Windows Installer project
• Deployment security settings

Creating Services

• Create service and operation contracts
• Create data contracts
• Create message contracts
• Implement generic message handling
• Implement RESTful services
• Create and configure a Routing service
• Create and configure a Discovery service

Hosting and Configuring Services

• Create and configure endpoints
• Configure behaviors
• Implement self hosting
• Implement web server hosting

Consuming Services

• Create a service proxy
• Configure client endpoints
• Invoke a service
• Consume RESTful services
• Implement service discovery

Securing Services

• Secure bindings
• Message security
• Authentication
• Authorization
• Impersonation
• Security auditing

Manage the Service Instance Life Cycle

• Service Instances
• Sessions
• Transactions
• Concurrency
• Manage consistency between instances, sessions, transactions and concurrency

Monitoring and Troubleshooting Distributed Systems

• Configure message logging
• Configure diagnostics
• Debug client-service interactions

You will take the following exams as part of the course:

• Exam 70-516 - TS: Accessing Data with Microsoft .NET Framework 4
• Exam 70-511 - TS: Windows Applications Development with Microsoft .NET Framework 4
• Exam 70-513 - TS: Windows Communication Foundation Development with Microsoft .NET Framework 4

Microsoft Official Curriculum

• MOC 10265A: Developing Data Access Solutions with Microsoft Visual Studio 2010
• MOC 10262A: Developing Windows Applications with Microsoft Visual Studio 2010
• MOC 10263A: Developing Windows Communication Foundation Solutions with Microsoft Visual Studio 2010

This course is for developers who:

• Want to gain experience of the new features of the .NET platform as soon as possible
• Want to plan how .NET 4.0 will affect their applications and what new features can be used

Students successful on this course have:

• Solid understanding of the .NET Framework
• Six months' experience in Visual Studio
• Minimum one to two years' experience developing application components that interact with a variety of data sources
• Thorough understanding of relational database concepts
• Minimum one to two years' experience using a relational database management system
• Fundamental Knowledge of .NET programming languages (C# or VB.NET)
• One year's experience developing Windows and web applications
• Experience in creating data-driven web applications
• Reasonable understanding of Web technologies (HTTP/HTTPS, HTML, CSS, JavaScript)
• Experience in creating data-driven user interfaces
• Working knowledge of setup and deployment projects

Seven reasons why you should sit your course with Firebrand Training

• Two training options. Choose between residential classroom-based and online courses
• You'll be certified fast. With us, you’ll be trained in record time
• Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
• Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
• You’ll learn more. A day with a traditional training provider generally runs from 9am–5pm, with a nice long break for lunch. With Firebrand, you’ll get at least 12 hours/day of quality learning time with your instructor
• You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
• You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals

*For residential training only. Doesn't apply for online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts

Are you ready for the course? 

Get access to free practice tests for your course  Free Practice Test