Home » Microsoft Training Courses » Visual Studio 2008 MCTS .NET
Framework 3.5 ADO .NET Applications

Visual Studio 2008 Microsoft Certified Technical Specialist MCTS: .NET Framework 3.5 ADO .NET Applications

The Microsoft Developer Certification for creating data driven applications such as SQL, Oracle, Access and more

Course Contents:

Stage 1: Software Programming Fundamentals

Stage 2: Programming Best Practices

Stage 3: Software Development Principles

Stage 4: Microsoft Exam 70-536 MCTS: Microsoft .NET Framework 3.5 - Application Development Foundation

Stage 5: Microsoft Exam 70-561 MCTS: Microsoft .NET Framework 3.5 - Application Development

Course Code:

VSMCF-9

Course Duration:

12 months

Typical Study Hours:

40 - 50 hours

Course Fees:

See our Fee Guide

Course Demo:

Request an online Course Demo

Study Prerequisite:

Computer programming certifications or relevant industry experience.

Additional Information for Stage 1:

• Software Programming Fundamentals:
  • Getting Started
  • Designing Programs

^top

Additional Information for Stage 2:

• Programming Best Practices:
  • Programming Techniques and Strategies
  • General Coding Best Practices
  • Object-oriented Coding Best Practices
  • Maintaining Quality Code

^top

Additional Information for Stage 3:

Software Development Principles:

• Developing a User-Centred Software Design Approach
  • Introducing User-Centered Design
  • Developing an Application Using User-Centered Design
  • The Iterative Process in User-Centered Design
  • Practical Examples of User-Centered Design

^top

Additional Information for Stage 4:

Microsoft Exam 70-536 MCTS: Microsoft .NET Framework 3.5 - Application Development Foundation

• Visual Basic: System Types and Collections
  • Recognise basic object-oriented programming procedures in Visual Basic
  • Identify the variables in Visual Basic
  • Create types
  • Create classes
  • Create types and classes in a given scenario
  • Recognise the interfaces in the System namespace
  • Recognise the interfaces in the System.Collections namespace
  • Use classes in the System.Collections namespace
  • Identify the classes in the System.Collections namespace
  • Identify the classes that provide the abstract base class
  • Use interfaces and classes in a given scenario
  • Create generic types
  • Create generic interfaces
  • Create generic classes
  • Create generic enumerators
  • Create generics

• Visual Basic: Serialisation and I/O
  • Serialise an object in Visual Basic
  • Distinguish between serialisation interfaces
  • Use the SerialisationInfo classes
  • Use XMLserialisation and deserialisation
  • Serialise and deserialise an object in binary format
  • Serialise and deserialise an object in SOAP format
  • Use serialisation in a given scenario
  • Use the FileStream class
  • Distinguish between the most common file handling classes in the System.IO namespace
  • Match the classes to examples of their file management tasks
  • Implement isolated storage
  • Use stream, isolated storage, and file management classes in a given scenario
  • Determine how to improve application performance using serialisation and I/O

• Visual Basic: Customised Programming
  • Integrate a COM object into .NET
  • Use data marshalling
  • Use DLL functions
  • Use System.Reflection
  • Use System.Reflection.Emit
  • Perform interoperation and reflection in a given scenario
  • Use GDI+ to draw a shape
  • Use GDI+ to display images
  • Manipulate text in an application
  • Draw and manipulate text in Visual Basic
  • Determine how to customise a Visual Basic application
  • Develop e-mail functionality in an application
  • Recognise how to configure CultureInfo
  • Recognise how to configure NumberFormatInfo
  • Recognise how to configure RegionInfo
  • Configure DateTimeFormatInfo
  • Develop e-mail capabilities in an application
  • Localise and application

• Visual Basic: Security
  • Implement evidence-based security
  • Implement role-based security
  • Implement evidence-based security in a given scenario
  • Implement role-based security in a given scenario
  • Implement file security
  • Implement authentication
  • Implement permissions using the System.Security namespace
  • Implement permissions using the System.Security.Permissions namespace in a given scenario
  • Use the command-line to implement permissions
  • Implement file and code access security permissions in a given scenario
  • Implement symmetric cryptography
  • Implement asymmetric cryptography in a given scenario
  • Use hash algorithms
  • Use the DPAPI
  • Use cryptography in a given scenario

• Visual Basic: Threading, Service Processing, and Application Domains
  • Implement threading
  • Use the WaitHandle class
  • Use the EventWaitHandle class
  • Use the ReaderWriterLock class
  • Use special classes
  • Use Thread Timers
  • Recognise the features of the ThreadState and ThreadPriority enumerations
  • Develop threads in Visual Basic
  • Create a Windows Service
  • Identify the characteristics of Windows Services
  • Install and run a Windows Service
  • Use the ServiceBase class
  • Use the ServiceController class
  • Use the ServiceInstaller class
  • Implement Windows Services in a given scenario
  • Configure application domains
  • Configure an application domain in a given scenario
  • Determine how to improve system operation using threading, service processing, and application domains

• Visual Basic: Diagnostics and Management
  • Recognise how to use configuration file and section classes
  • Recognise how to use configuration elements interfaces
  • Program custom installers for components
  • Configure .NET applications for deployment
  • Program configuration data
  • Program custom installers
  • Use event logs
  • Use system processes
  • Manage event logs and system processes
  • Determine how to manage configuration, custom installation, and system processes.
  • Debug an application
  • Trace an application
  • Describe management events
  • Retrieve system information
  • Debug an application
  • Manage system information

^top

Additional Information for Stage 5:

Microsoft Exam 70-561 MCTS: Microsoft .NET Framework 3.5 - Application Development

• Getting Started With ADO.NET Connections and Commands

  • Identify the features, capabilities, and benefits of ADO.NET
  • Identify the components and uses of the ADO.NET object model, the DataSet object, and data providers
  • Identify the uses and benefits of LINQ and the Entity Framework
  • Select the appropriate .NET data provider in a given scenario
  • Identify the steps for setting the ConnectionString property
  • Identify the features of the ConnectionString property's provider-specific attributes
  • Identify ways to open and close connections
  • Recognise ways for handling connection events
  • Recognise the code for handling typical exceptions
  • Select a data provider
  • Configure a connection
  • Encrypt data and add a user instance
  • Handle connection events
  • Recognise the steps for creating a command to retrieve a single value from a data source
  • Recognise the uses of DataReader properties and methods and the steps for retrieving a result set from a database
  • Name the different ways of processing rows of read-only data
  • Identify the code for using Execute XmlReader for returning an XML stream
  • Work with Command objects
  • Use a DataReader object
  • Retrieve a single value from a data source
  • Retrieve an XML data stream

• Managing ADO.NET Connections and Commands with VB 2008

  • Identify ways to pool connections
  • Recognise the steps for retrieving a connection string from a configuration file
  • Identify the steps for monitoring connection resources
  • Recognise the code for using parameters with SQL statements
  • Recognise the steps for using the ExecuteNonQuery method
  • Identify the steps for creating a stored procedure with parameters
  • Recognise how to use the DBProviderFactory, DbConnection, DbCommand, and DbException objects
  • Identify the steps for using generic data access code to retrieve provider information
  • Retrieve a connection string from a configuration file, based on a provider name
  • Create a DBProviderFactory and DBConnection
  • Create a DBCommand object
  • Handle data source errors
  • Recognise how the .NET Framework APIs can be used to configure transactions
  • Identify the code for implementing implicit and explicit transactions and for managing concurrency
  • Recognise the ways for managing and implementing transactions using the System.Transaction namespace
  • Implement an asynchronous explicit transaction
  • Implement an implicit transaction
  • Implement concurrency
  • Recognise the steps and considerations for enabling and using MARS
  • Identify the code for using MARS to manipulate data
  • Identify the uses of asynchronous design patterns in a given scenario
  • Recognise how to poll an asynchronous operation, implement a callback, and monitor asynchronous operations
  • Recognise the code for manipulating large objects
  • Identify the code for moving large amounts of data
  • Identify the benefits and uses of the SqlBulkCopy class
  • Identify the code for populating a table-valued parameter
  • Work with MARS, asynchronous commands, and special data types

• Getting Started with DataSets using Visual Basic 2008
  • Identify the scenarios in which its appropriate to use the disconnected access model in ADO.NET
  • Recognise the code for creating a DataSet, adding a DataTable to it, and setting column properties
  • Enforce and remove unique constraints for a column or an array of columns
  • Recognise how to programmatically fill an existing DataTable using a DataAdapter
  • Identify how to use a DataAdapter object to retrieve data
  • Recognise the steps for using the Fill method of a DataAdapter to page through query results
  • Create an untyped DataSet and DataTable structure
  • Enforce and remove unique constraints
  • Use a DataAdapter to fill a DataSet and enable results to be paged through
  • Recognise the steps for creating a typed DataSet
  • Identify the steps for creating a TableAdapter, using the TableAdapter Configuration Wizard
  • Recognise the different ways to create TableAdapters
  • Recognise the steps for updating a TableAdapter
  • Create a typed DataSet
  • Create and configure a TableAdapter
  • Add a query to a TableAdapter

• Viewing and Navigating Data with ADO.NET DataSets using Visual Basic 2008
  • Identify the steps for adding a DataRelation object and specifying settings for the ForeignKeyConstraint object
  • Recognise the uses of DataRelation objects
  • Recognise the steps for navigating a DataRelation object
  • Create a DataRelation object
  • Apply foreign key constraint rules
  • Navigate related DataTables
  • Recognise the code for using a DataTableReader to iterate over result sets
  • Recognise the code for using the Select and Find methods to access DataTable data
  • Use the Compute method to perform an aggregate calculation on a subset of DataTable columns
  • Identify the steps for creating a DataView
  • Identify the appropriate method to use to view, access, or locate data in a DataView in a given scenario
  • Recognise the code for editing a DataView
  • Identify the steps for using a DataViewManager to apply default and custom settings to a number of DataViews
  • Create a DataView
  • Edit a DataView
  • Configure DataView settings

• Updating ADO.NET DataSets With Visual Basic 2008
  • Identify different ways of inserting data into DataSets
  • Identify the code for adding rows to DataSets
  • Recognise the steps for loading a DataTable with rows from a data source
  • Recognise the code for editing existing ADO.NET data
  • Recognise how to commit or undo changes made to a DataSet
  • Identify the code for filtering and merging DataTable changes
  • Recognise the code for updating content with a DataAdapter
  • Recognise the steps for updating content using a TableAdapter
  • Recognise the steps for updating a DataSet within a transaction
  • Change DataTable content
  • Filter and merge DataTable changes
  • Update changes to a data source
  • Recognise the steps for validating data during row and column changes
  • Identify the steps for handling DataTable errors
  • Recognise the steps for implementing concurrency
  • Recognise ways to handle update errors
  • Use row and column events to validate data
  • Handle DataTable errors in a given scenario
  • Handle update errors and exceptions using DataAdapter events
  • Update DataTable content

• Using Query Notifications and Synchronising Data with Visual Basic 2008
  • Recognise the code for executing a SqlCommand with a SqlNotificationRequest
  • Recognise the steps for using SqlDependency to detect changes
  • Identify the steps for using a SqlCacheDependency object
  • Use SqlDependency to detect changes
  • Use query notifications in an ASP.NET application
  • Recognise the benefits and uses of Microsoft Synchronisation Services for ADO.NET
  • Identify the architectural requirements for implementing client and server synchronisation
  • Recognise the uses and benefits of classes used in Synchronisation Services
  • Recognise the steps for creating synchronisation tables and groups
  • Recognise the steps for retrieving an anchor value and creating a synchronisation adapter
  • Recognise the steps for coding statistics and events
  • Recognise the steps for building a basic synchronisation services application
  • Recognise the steps for configuring the cache for synchronisation using Microsoft Synchronisation Services
  • Code the synchronisation providers
  • Code the synchronisation agent
  • Code statistics and events
  • Call the Synchronisation method

• The ADO.NET Entity Framework and LINQ
  • Recognise the key features of the ADO.NET Entity Framework
  • Create an Entity Data Model
  • Update the Entity Data Model using the Update Model Wizard
  • Complete the code to build an object query against the Entity Data Model
  • Identify the code used to shape query results
  • Identify how code is used to ensure changed data is written back to the data store and transactions are managed
  • Identify the code used to customise data classes for use with an Entity Data Model
  • Recognise key code elements associated with the EntityClient Provider
  • Recognise key Connection String parameters
  • Generate an Entity Data Model (EDM)
  • Complete an object query
  • Perform coding task to ensure changed data is written back to the data store
  • Use key classes and commands associated with the EntityProvider class
  • Match the three ADO.NET LINQ technologies to their descriptions
  • Recognise how to use the language features supported by LINQ
  • Recognise the code used to perform different LINQ to DataSet queries
  • Recognise how to create a LINQ to SQL query
  • Recognise the steps for creating and executing a LINQ to Entities query
  • Write a LINQ to DataSet query
  • Write a LINQ to SQL query
  • Write a LINQ to Entities query

^top

<< back to previous page