The course Microsoft Certified Application Developer for .NET (MCAD.NET) is for professionals who want to design and develop powerful new enterprise applications with using Visual Studio.NET and web services.
You will be building applications on Windows platform, deploying and maintaining applications.
The MCAD certification demonstrate the individual skills and knowledge in implementation of functional specification, build, deploy and maintain Windows and Web applications.
1. Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
|
2. Creating User Services |
Microsoft .NET, ASP.NET and Visual Studio .NET
• .NET Platform Technologies
• Visual Studio .NET
• Building Block Services
• .NET Alerts
• .NET Passport
• .NET Enterprise Servers
• .NET Framework
.NET Framework and its Components
• Common Language Runtime (CLR)
• Base Class Library (BCL)
• Namespaces
• .NET Framework Languages
• Common Language Specification (CLS)
• Common Type System (CTS)
• Microsoft Intermediate Language (MSIL)
• Compiling Source into managed modules
• Structure of managed module.
• What is Metadata?
|
Create ASP.NET pages.
• set directives on ASP.NET pages
• user interface
Web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages.
• Create Web custom controls and Web user controls
• Set properties on controls.
• Load controls dynamically.
• Apply templates.
• Set styles on ASP.NET pages by using cascading style sheets.
• Instantiate and invoke an ActiveX control. |
| 3. Implement navigation for the user interface |
4. Implement online user assistance |
• view state.
• Postback events.
• Use session state.
Validate user input.
• Validate non-Latin user input.
Implement error handling in the user interface.
• Configure custom error pages.
• Implement Global.asax, application, page-level, and page event error handling. |
• Incorporate existing code into ASP.NET pages.
• Display and update data.
• Instantiate and invoke Web services or components.
• Implement globalization.
Handle events.
• Create event handlers.
• Raise events.
Implement accessibility features.
Use and edit intrinsic objects. Intrinsic objects include response, request, session, server, and application.
• Retrieve values from the properties of intrinsic objects.
• Set values on the properties of intrinsic objects.
• Use intrinsic objects to perform operations. |
| 5.Creating and Managing Components and .NET Assemblies |
6. Testing and Debugging |
• Create and modify a .NET assembly.
• Create and implement satellite assemblies.
• Create resource-only assemblies.
Consuming and Manipulating Data
• Access and manipulate data from a Microsoft SQL Server database by creating and using ad hoc queries and stored procedures.
• Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO.NET.
• Handle data errors
|
• Create a unit test plan.
• Implement tracing.
• Debug, rework, and resolve defects in code.
Deploying a Web Application
• Plan the deployment of a Web application.
• Create a setup program that installs a Web application and allows for the application to be uninstalled.
• Deploy a Web application.
• Add assemblies to the global assembly cache.
Maintaining and Supporting a Web Application
• Optimize the performance of a Web application.
• Diagnose and resolve errors and issues. |
7. Configuring and Securing a Web Application
|
8..Configure and implement caching |
Configure a Web application • Modify the Web.config file. • Modify the Machine.config file. • Add and modify application settings.
Configure security for a Web application. • Configure authorization. Authorization methods include file-based methods and URL-based methods. • Configure role-based authorization. Implement impersonation.
|
Caching types include output, fragment, and data.
• Use a cache object.
• Use cache directives.
Configure and implement session state in various topologies such as a Web garden and a Web farm.
• Use session state within a process.
• Use session state with session state service.
• Use session state with Microsoft SQL Server.
Install and configure server services.
• Install and configure a Web server.
• Install and configure Microsoft FrontPage Server Extensions. |
| 9. Exam 70-431 Microsoft SQL Server 2005—Implementation and Maintenance |
10..Use XML-related features in Microsoft SQL Server 2005 |
Create databases and database files.
• Create databases.
• Create filegroups.
• Create schemas.
• Create database snapshots.
Create data types and tables.
• Creating Data Types.
• Creating Tables.
• Creating Partitioned Tables.
|
• Retrieving XML by Using FOR XML.
• Shredding XML by Using OPENXML.
• Using the xml Data Type.
• Mapping Relational Data and XML.
• Storing XML Natively in the Database.
Plan, create, and optimize indexes.
• Planning Indexes.
• Creating Indexes.
• Optimizing Indexes.
• Creating XML Indexes. |
| 11.Implement data integrity in Microsoft SQL |
12..Implement managed code in the database |
Server 2005 databases by using constraints, triggers, and XML schemas.
• Creating Constraints.
• Creating Triggers.
• Implementing XML Schemas.
Implement views.
• Creating Views.
• Creating Indexed Views.
• Creating Partitioned Views.
Implement stored procedures and functions.
• Creating Stored Procedures.
• Creating Functions.
|
• Creating Managed Database Objects.
Use Service Broker to build a messaging-based solution.
• Creating Service Broker Objects.
• Implementing the Initiating Service.
• Implementing the Target Service.
Install and configure SQL Server 2005.
• Preparing to install SQL Server.
• Installing SQL Server.
• Managing a SQL Server 2005 Installation. |
| 13. Manage database files |
14. Implement managed code in the database |
• Planning databases.
• Creating databases.
• Managing databases.
Manage security.
• Overview of SQL Server Security.
• Securing the Server Scope.
• Securing the Database Scope.
• Managing Keys and Certificates in SQL Server.
• Creating Logins.
• Creating and Managing Users.
|
• Configuring the SQL Server Agent.
• Creating Operators and Jobs.
• Creating Alerts.
Automating Administrative Tasks
• Automating Administrative Tasks in SQL Server 2005.
• Configuring the SQL Server Agent.
• Creating Jobs and Operators.
• Creating Alerts.
• Managing Multiple Servers.
• Managing SQL Server Agent Security |
| 15. Configuring Database Mirroring |
16. Monitor SQL Server |
• Setting the Recovery Model.
• Backing Up and Restoring the Database.
• Starting Database Mirroring.
• Performing an Automatic and Manual Failover.
Database Backup Recovery
• Back up databases.
• Restore databases. |
• Viewing Current Activity.
• Using System Monitor.
• Using SQL Server Profiler.
• Using DDL Triggers.
• Using Event Notifications. |
| 17. Transfer data |
18. Introduction to Replication |
• Create an SSIS Package.
• Deploying an SSIS Package.
|
• Overview of Replication.
• Replication Scenarios.
• Creating a Publication.
• Creating a Subscription. |
| 19. Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework |
20. Microsoft .NET Framework and XML |
Introduction to XML and Related Technologies
• Introduction of XML
• Features of XML
• W3C Recommendation
• Exchange Data
• Complement with existing standards
• Separation of Data and Presentation
• Integration between Non Compatible Systems
• XML and B2B
• Software, Hardware, Technology, Device Independent
• Data Storage
• Human Understandable Format
• Create New Languages
• Difference between XML and HTML
• Basic Overview of XML Related Technologies
• Presentation Technologies
• HTML, XHTML
• Validation Technologies
• DTD, XML Schema
• Transforming Technologies
• CSS, XSLT, XSLT FO
• Other Technologies
• XPath, XQuery, XLink
• XML Web Services
• SOAP, WSDL, UDDI
• Writing XML Documents
• XML Document Components
• Comments
• Declaration or Processing Instruction
• Root Element
• Nested Elements
• Template Dat
• Empty Elements
• Attributes
• Well formed XML Document
• Displaying Well Formed XML Document in Browser
|
• Microsoft .NET Platform
• .NET Platform Technologies
• Visual Studio .NET
• .NET Building Block Services
• .NET Enterprise Servers
• .NET Framework
• Overview of .NET Framework
• .NET Framework Components
• Common Language Runtime (CLR)
• Base Class Library (BCL)
• .NET Framework Languages
• Common Language Specification (CLS)
• Common Type Specification (CTS)
• Microsoft Intermediate Language (MSIL)
• Managed Modules and metadata
• .NET Assemblies
• Structure of .NET Assembly and Assembly Manifest
• Creating .NET Assemblies
• Types of .NET Assemblies
• Private Assemblies
• Public or Shared Assemblies
• Strong Name Assemblies
• Global Assembly Cache (GAC)
• Registration of Assemblies in Global Assembly Cache (GAC)
• Role of XML in .NET
• Working with XML Files in .NET
• Reading and Writing XML Files in .NET
• Working with XML and DataSets |
| 21. Microsoft .NET and XML Web Services |
22. Lecture 4: Microsoft .NET and Window Services |
• Overview of Service Oriented Architecture
• Understanding XML Web Services
• Communication between client and xml web service
• Searching Web Service Providers (UDDI)
• Discovering Web Service (DISCO)
• Describing Web Services Capabilities (WSDL)
• Describing Web Service Data (XML)
• Format of Communication (SOAP)
• Creating XML Web Service
• Creating XML Web Methods
• Discovering XML Web Service
• Publishing XML Web Services
• Publishing XML Web Service
• Adding Web Reference for XML Web Service
• Generating Proxy Class
• Accessing Web Services using Proxy Object
• Calling the methods exposed by XML Web Service
• Creating Web Client of XML Web Services
• Creating Windows Client of XML Web Services
• Advance XML Web Services Programming
|
• Overview of .NET Windows Services
• Service Application
• Service Controller Application
• Service Control Application
• Difference between Windows Services and Other .NET Applications
• Creating Windows Service Application
• Changing the Default Properties of Windows Service Application
• Adding Functionality to a Service Application
• Handling Events in window service
• Logging Information from window service
• Overview of Installers
• Installing window services
• Adding Installers to window service
• Managing Windows Services |
| 23. Database Programming using ADO.NET |
24. Database Programming using ADO.NET |
• Overview of ADO.NET
• Architecture of ADO.NET
• Data Sources, Data Providers, DataSets
• ADO.NET Connected Architecture
• Using ADO.NET Data Providers
|
• Accessing and Manipulating Data in .NET Applications
• ADO.NET Discontented Architecture
• Using ADO.NET DataSet Object |
| 25. Microsoft .NET Remoting |
26. Microsoft .NET Remoting |
• Overview of .NET Remoting
• Accessing Objects outside Remoting boundaries
• Microsoft .NET Remoting Architecture
• Types of Remoting Objects
• Creating Server Activated Remoting objects
|
• Creating Client Activated Remoting objects
• Configuring .NET Remoting objects
• Creating a Client Application to Access Remote objects |
| |
|