Visual InterDev 6 0 Accessing Remote Data

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)

Unit 1: ActiveX Data Objects (ADO)

• 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

• 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 ISQL_w of Microsoft SQL Server 6.5.
• Create a trigger to implement a business rule by using Microsoft ISQL_w of Microsoft SQL Server 6.5.
• Write the ADO code to retrieve data from a table by using the Execute Direct model.
• Write the ADO code to retrieve data from a table by using the Prepare and Execute model.
• Write the ADO code to retrieve data from a table by using the Stored Procedure model.
• Create a membership site in ASP by using ADO.
• Write the code to retrieve data from a table by using a server-side cursor.
• Write the code to retrieve data from a table by using a client-side cursor.

Unit 3: Remote Data Services (RDS)

• Match the RDS components with their functions.
• Sequence the steps that occur when RDS displays a recordset.
• Identify the factors to be considered when using the DataSource object to bind data to elements in an HTML page.
• Insert an RDS.DataControl object in an HTML page by using the Object tag.
• Write the code to send a database query by using the Refresh method of the ADC RDS.DataControl object.
• Create a sub procedure to navigate through the records in a recordset by using the RDS.DataControl object.
• Write the code to create a recordset by using the RDSServer.DataFactory object.
• Write the code to display table data by using the RDSServer.DataFactory object.

Unit 4: Creating and Using COM Components

• Identify the advantages of creating business processes by using an object-oriented model.
• Identify the advantages of using COM components.
• Identify the criteria for selecting a specific type of COM component for a project.
• Match the options in the General property page of the Project Properties dialog box with their descriptions.
• Match the settings of the Instancing property of a class module with their descriptions.
• Create a method in a class module by using the Add Procedure dialog box in Visual Basic 6.
• Create a property in a class module by using the Add Procedure dialog box in Visual Basic 6.
• Create an event in a class module by using the Add Procedure dialog box in Visual Basic 6.
• Compile an ActiveX DLL as a COM component by using the Make Project dialog box in Visual Basic 6.
• Register a COM component by using Visual InterDev Project Explorer window.
• Write the code to create an instance of a COM component in ASP by using the CreateObject method.
• Write the code to create a remote business object instance by using the CreateObject method of RDS.DataSpace.
• Deploy a Web application containing COM components by using the Visual InterDev Project Explorer window.
• Match the version compatibility options in the Component property page of the Project Properties dialog box with their descriptions.