Visual Basic 6.0 Database Programming Course
Course Description
You will get the most out of this course if you want to learn how to develop database applications in Visual Basic 6.0. You should have some application experience, ideally in object-oriented programming, but no prior knowledge of data management or querying is assumed. This course is intended for application developers and other computer professionals who will use Visual Basic 6.0 to manage data.
Course pre-requisites:
Previous to taking this course, a student should take the Visual Basic 6.0: Introduction, or possess equivalent knowledge.
Topics covered on the 5 day Visual Basic 6.0 Database Programming course
Database Basics
What is a Database?
Using the Visual Basic Database Tools to Manage Your Data
Relational Database Structures
Overview of SQL
What is SQL?
Optional Clauses
Advanced Statements and Resource Management
The ActiveX Data Object (ADO) Model
Universal Data Access (UDA)
The ADO Model
Introduction to Data Access
The ADO Data Control
Properties, Methods, and Events of the ADODC
Bound Controls
The Data Form Wizard
The ADO DataEnvironment
The DataEnvironment (DE)
Creating Command and Recordset Objects in the DE
Using Bound Controls and Data Designing in the DE
Working with ADO Code
The Connection Object
The Recordset Object
The Command Object
Data Reporting
Printing From Within Visual Basic
Using the Data Report Designer in the DataEnvironment (DE)
Using ADO Code to Display Data Reports
Advanced Topics
The Data Access Objects (DAO) Model and Data Control
The Data Access Objects (DAO) Model
Comparing DAO and ADO
Intrinsic Controls and DAO
Working with DAO Code
Writing Code to Store Data
Creating a New Database with DAO Code
Coding the Project
Data Manipulation with DAO Code
Migration
Making the Decision to Migrate
Legacy Upgrade Compatibility Issues
Migration Dos and Dont’s
Using SQL
SQL Overview
SELECT Statements
Cursors
Record-locking
Stored Procedures
Internet Applications
WebBrowser Control
What is an Active Document?
Appendix A: Applications Used in This Course
Appendix B: Physical Design of Applications
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Course Fee = £1475 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
|
|
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
