|
Provided by: Serebra Learning Corporation Visual Basic 6 0 Database Access Part IIMicrosoft Visual Basic (VB) |
 |
Training
Provided by Serebra Learning Corporation
This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.
|
|
||||||||||
Visual Basic 6 0 Database Access Part II
Create and destroy connections to data sources and respond to events associated with the Connection object Create commands that build queries or access queries, tables, or stored procedures in a database Create recordsets and use them to view retrieved data Use the ADO Error collection to trap and handle errors Sort and filter records Search records using ADO navigation methods Insert, delete, and update record data Connect to a secured database system and understand how to protect the data within from corruption, once connected Choose suitable cursors for recordsets that balance application performance with features Execute stored procedures on a database system through the ADO command object
Audience
Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.
Topics
Programming with Active X Data Objects
- The ADO Object Model
- The Connection Object
- The Command Object
- The Recordset Object
- ADO Errors
Updating and Editing Data Records with ADO
- ADO Properties and Methods
- Modifying Data Records
- Disconnected Recordsets
Advanced Data Access with ADO
- Working with SQL Server Security
- Using ADO Cursors
- Maintaining Data Integrity Through ADO
- Running Stored Procedures with ADO
Objectives
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
