Visual Basic Courses > Visual Basic 6.0 Database Programming Training Course
Course Fee = £1475 (excl.VAT)
Visual Basic 6.0 Database Programming Course Outline
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
| July 2009 |
August 2009 |
September 2009 |
October 2009 |
November 2009 |
If you want to attend the course but can't make the dates published, then please get in touch as we may well be able to add additional dates to those published or to re-arrange the course. Additionally, you could take advantage of one-to-one training with our SoloIT Training packages that also enables you to attend this course on dates that suit.
|
