|
Provided by: 123-CBT Computer Based Training Visual InterDev 6 0 Accessing Remote Data |
 |
Course Overview
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote Data Services (RDS); identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS); create a COM component in Visual Basic 6; and register a component in Visual InterDev.
Learn To:
- Identify the components of the ActiveX Data Objects (ADO) model.
- Work with database records and identify the methods of managing recordset size.
- Manipulate database records by using SQL, stored procedures, data access models and cursors.
- Implement business rules by using triggers.
- Identify the components of Remote Data Services (RDS).
- Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS).
- Identify the benefits of using COM components.
- Create a COM component in Visual Basic 6.
- Register a component in Visual InterDev.
Content Emphasis
Skills-Based
Audience
This course series is designed for site developers who perform architectural planning, technology selection, or Web site programming tasks. This series will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. Participants should have completed the first three courses in the series.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: ActiveX Data Objects (ADO)
Duration: 1 - 2 Hour(s)- Identify the components of Universal Data Access.
- Match the Microsoft Data Access Components with their functions.
- Match the ActiveX Data Objects (ADO) with their functions.
- Write the code to establish a database connection with a data source by using a Connection object.
- Write the code to retrieve records from a database by using the Open method of the Recordset object.
- Write the code to retrieve records from a database by using the Execute method of the Command object.
- Write the code to execute a stored procedure that accepts parameters by using the Execute method of the Command object.
- Write the code to create a subprocedure to navigate through the records in a Recordset by using the Recordset navigation methods.
- Write the code to add a record to a database by using the AddNew method of the Recordset object.
- Write the code to update a record in a database by using the Update method of the Recordset object.
- Write the code to delete a record from a database by using the Delete method of the Recordset object.
- Write the code to trap a database error by using the Err object of the Errors collection.
- Identify the methods to efficiently manage the size of a Recordset.
- Identify the benefits of using business objects for database updates.
Unit 2: Creating Data Services
Duration: 1 - 2 Hour(s)- Retrieve data from a database by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
- Add a record to a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
- Update a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
- Delete a record from a database table by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
- Create a stored procedure to retrieve database data by using Microsoft
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
