Description
This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential integrity.
Audience
This course is designed for programmers who need to create basic applications with Microsoft Visual Basic 6.0. Participants should have completed the first two courses in this series.
Prerequisites
(Currently no course prerequisite information)
Objective
- Use ActiveX Data Objects to access and manipulate data sources.
- Understand SQL Server security implementations.
- Implement an appropriate cursor for a recordset object.
Topics Include
Unit 1: Using ActiveX Data Objects (ADO) - Identify the characteristics of ADO.
- Identify the components of the ADO object model.
- Identify methods of handling data access errors.
- Connect to a database using ADO.
- Connect to a data source.
- Identify connection object events.
- Identify database connections.
- Identify the uses of the Command object.
- Identify the uses of the Recordset object.
- Identify ways of presenting data to the user.
- Identify the properties and methods that allow navigation through a recordset.
- Identify code to sort records.
- Identify code to filter and search records.
- Update data using the Execute method.
- Update data using a recordset.
- Create a disconnected Recordset object.
- Identify the methods used in data persistence.
- Identify how much connection information is required to reconnect to a data source.
- Identify issues related to the performance of batch updates.
- Create a dynamic recordset.
Unit 2: Advanced Data Access Issues - Identify the guidelines for incorporating user ID and user password values in SQL Server security.
- Select a cursor type for a Recordset object.
- Select a cursor location for a Recordset object.
- Create a cursor.
- Select a LockType property for a Recordset object.
- Identify the features of implicit and explicit transactions.
- Identify SQL Server data integrity features.
- Identify guidelines for handling referential integrity errors.
- Identify the guidelines for executing statements directly.
- Identify the features of stored procedures.
- Call a stored procedure.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).
The network version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
|
