Microsoft MCTS .NET 3.5 Web and Data Applications

This course is no longer offered. See all available Microsoft certifications.

This accelerated instructor-led course provides students with the knowledge and skills to create a fully functional Web application by using ASP.NET 3.5, and to access and modify data by using ADO.NET 3.5.

This course is intended for application developers who know how to create applications in Visual Studio 2005 or 2008.

This course will prepare you and test you for the following certifications:

• MCTS: .NET Framework Application Development Foundation
• MCTS: .NET Framework 3.5 ASP.NET Application Development
• MCTS: .NET Framework 3.5 ADO.NET Application Development

After completing the Web (ASP) element of this course, students will be able to:

• Explain how to create dynamic Web pages by using ASP.NET
• Manage state, handle requests, and improve accessibility by using the features of ASP.NET
• Configure an ASP.NET application by using .config files
• Create a user interface on an ASP.NET page by using standard Web server controls
• Create a user control and a custom server control and add them to an ASP.NET page
• Access and manipulate data from different sources by using ADO.NET 3.5
• Access and manipulate data from Windows Communication Foundation services or Web services
• Present data to the user by placing data-bound controls on an ASP.NET page
• Improve page responsiveness by using the ASP.NET AJAX controls
• Interact with the user, access services, and access the AJAX client-side library by using client scripts
• Find and eliminate bugs in an ASP.NET application
• Deploy an ASP.NET application to a production Web server
• Write pages that adapt to the capabilities of mobile devices
• Utilise controls that adapt to the capabilities of mobile devices

After completing the Data (ADO) element of this course, students will be able to:

• Describe the purpose and structure of ADO.NET 3.5
• Explain the role of data providers in ADO.NET 3.5
• List the technologies and techniques available for managing data with ADO.NET 3.5
• Insert, update, and delete data by using ADO.NET Command objects
• Implement transactions to control data integrity and concurrency
• Define and use a DataSet for retrieving data
• Use a DataSet to update a database
• Use a DataSet as a local cache in an occasionally connected environment
• Define LINQ queries for selecting data from an in-memory data structure
• Use LINQ to SQL to query data in a database
• Use LINQ to SQL to modify data and save changes to the database
• Explain how to use the ADO.NET Entity Framework to map a database schema to a logical business model
• Use the ADO.NET Entity Framework to query and manage data
• Explain how Synchronisation Services supports occasionally-connected solutions
• Use Synchronisation Services to download data from a SQL Server database
• Use Synchronisation Services to upload data to a SQL Server database

Benefits of MCTS certification

• An MCTS certification highlights your areas of expertise, so that your skills and knowledge stand out to hiring managers and project leads
• By earning multiple MCTS certifications, you can demonstrate your breadth of knowledge of Visual Studio 2008. You can also build on your MCTS certifications to earn a Professional Series credential
• MCTS certification grants you access to the Microsoft Certified Professional (MCP) community and benefits, including a personal profile on Microsoft.com and access to the Microsoft Knowledge Base

Benefits of IT certification

For IT managers, certification is particularly important because it allows them to more easily identify the skills that an individual possesses. When a company has employees that possess certain skills, it can garner a competitive advantage when seeking to attract customers. Certification can also contribute to increased productivity, because studies have shown that certified individuals are generally quicker to implement and design new technologies. And of course by knowing that their employees are certified, IT managers can feel more confident about their ability to implement and support a network infrastructure.

While attending this blended-learning program, you will receive a robust set of course materials that caters to each of the three primary individual learning-intake styles (auditory, visual, and kinaesthetic-tactual) - critical for a successful accelerated learning experience.

Daily lectures, labs, and review sessions are supplemented by a combination of:

• Proprietary Lab Manual & Microsoft Courseware - developed in conjunction with Microsoft, adapting the Microsoft Offical Curriculum extended by Microsoft Press Books
• Self Test Testing Software

Our .NET 3.5 Web and Data program covers the following subjects:

.NET Framework Development Fundamentals

• Developing applications that use system types and collections
• Embedding configuration, diagnostic, management, and installation features into a .NET Framework application
• Implementing serialisation and input/output functionality in a .NET Framework application
• Improving the security of .NET Framework applications by using the .NET Framework security features
• Implementing interoperability, reflection, and mailing functionality in a .NET Framework application
• Implementing globalisation, drawing, and text manipulation functionality in a .NET Framework application

ASP.NET Application Development

• Configuring and Deploying Web Applications
• Working with Data and Services
• Consuming and Creating Server Controls
• Troubleshooting and Debugging Web Applications
• Working with ASP.NET AJAX and Client-Side Scripting
• Programming Web Applications
• Targeting Mobile Devices

ADO.NET Application Development

• Connecting to Data Sources
• Selecting and Querying Data
• Modifying Data
• Synchronising Data
• Working with Disconnected Data
• Object Relational Mapping by Using the Entity Framework

Skills Being Measured

During this course you will take the following exams:

• Exam 70-536 *-TS: .NET Framework Application Development Foundation, Prerequisite Exam for all 3 MCTS Certifications
• Exam 70-562 *-TS: .NET Framework 3.5 ASP.NET Application Development
• Exam 70-561 *-TS: .NET Framework 3.5 ADO.NET Application Development

Included:

• MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework-Application Development Foundation - Book/CD Package ISBN: 9780735626195
• MCTS Self-Paced Training Kit (Exam 70-562): Microsoft .NET Framework 3.5 - ASP.NET Application Development - Book/CD Package ISBN: 9780735625624
• MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5 ADO.NET Application Development - Book/CD/DVD Package ISBN: 9780735625631

Microsoft Official Curriculum

• MOC 6464 AK (Visual Studio 2008: ADO.NET 3.5)

Candidates for the ASP.NET exam use Microsoft Visual Studio in a team-based, medium 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 for the ADO.NET 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

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.