Candidates for this exam work on a team in a medium or large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. Candidates have at least one year of experience developing Windows-based applications. Candidates should have a working knowledge of Microsoft Visual C# .NET.
Course Objectives
After completing this course, students will be able to:
- Describe data–centric applications, ADO .Net architecture, and ADO .Net and XML
- Connect to SQL server and other data sources
- Perform connected database operations including executing SELECT commands, database definition commands, Dynamic SQL commands, and commands that return data from a SQL Server database in XML
- Build a dataset schema, populate it with data, and modify the data programmatically
- Build a dataset from an existing data source
- Build web service that uses ADO .Net to query and update a data source
- Troubleshoot errors within an ADO .Net application
Prerequisites
The course assumes that students have the following skills:
- Understanding of C# programming
- Experience building applications
Course Track
Lesson 1: Create Windows Forms by using Windows Forms Designer
- Add and set properties on Windows Forms
- Create a Windows form by using a visual interface
- Build graphical interface elements by using the system.drawing namespace
Lesson 2: Add Controls to Windows Forms
- Set properties on controls
- Load controls dynamically
- Write code to handle control events and add the code to a control
- Create menus and menu items
Lesson 3: Implement error handling in the UI
- Create and implement custom error messages
- Create and implement custom error handlers
- Raise and handle errors
Lesson 4: Creating and Managing components and .Net assemblies
- Create and modify a .Net assembly
- Create a Windows Control
Lesson 5: 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
Lesson 6: Testing and Debugging
- Create a unit test plan
- Add trace listeners and trace switches to an application
- Display trace output
- Configure the debugging environment
- Create and apply Debugging code to components and applications.
Lesson 7: Deploying a Windows – Based application
- Plan the deployment of Windows-based application
- Create a setup program that installs the application and allows for the application to be uninstalled
- Deploy a Windows–based application
- Add assemblies to global assembly cache
- Verify security policies for a deployed application
Lesson 8: Maintaining and supporting windows based application
- Optimize the performance of a Windows-based application
- Diagnose and resolve errors and issues
Lesson 9: Configuring and Securing a Windows-based Application
- Configure a Windows-based application
- Configure security for a Windows-based application
- Configure authorization
Course Benefits
Students will be prepared to work with ADO .Net and to connect with Microsoft SQL Server Database. Students will learn the skills and techniques to work with .Net programs and to design and implement advanced Database Structures.
Course Duration
This course is covered in 40 hours of hands-on instructor led training sessions.