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

Curriculum

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

Developing and Using Web Forms Controls

• Validating user input
• Creating the page layout
• Implementing user controls
• Implementing server controls
• Code-behind in user controls

Developing Web Forms Pages

• Configuring Web Forms pages
• Implementing master pages and themes
• Globalization and Localization
• Page life cycle events
• Caching
• Managing State

Implementing Client-Side Scripting and AJAX

• Add dynamic features to a page using JavaScript
• Alter a page dynamically by manipulating the DOM
• Handle JavaScript Events
• Implement ASP.NET AJAX
• Implement AJAX using jQuery

Enhancing the Functionality and Usability of a Solution

• ASP.NET Providers
• Authentication and Authorization
• HttpHandlers and HttpModules
• Initialization and error handling
• Reference and configure ASMX and WCF services
• Configure projects and solutions, and reference assemblies
• Debug a web application
• Deploy a web application

Displaying and Manipulating Data

• Implement data-bound controls
• Implement DataSource controls
• Query and manipulate data using LINQ
• Create and consume a data service
• Create and configure a Dynamic Data project

Developing a Web Application by Using ASP.NET MVC 2

• Create custom routes
• Create custom controllers and actions
• Structure and ASP.NET MVC application
• Create and customize MVC views

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