Visual Basic Database Programming

This 2-day course is suitable for programmers who are already familiar with the basics of Visual Basic programming and wish to use it for accessing local or remote databases. It assumes familiarity with Visual Basic and can be taken together with our 'Visual Basic 6 Programming' ('GN-101') course to provide full 5-day coverage. The standard course covers Visual Basic version 6 and concentrates on the newer ADO technologies. Alternative courses for older versions can also be accommodated.


Course Content
The Database Object Models & Technologies
- The acronyms and what they mean -
- SQL, JET, DAO, RDO, ODBC, ODBC Direct and ADO.

ActiveX Data Objects - ADO
- ADO and OLEDB
- Providers and consumers
- ADO as the future

The Data Control & the Wizards
The data control and its associated data bound controls provide the simplest way of interfacing an application to a database and tools like the Data Form Wizard can simplify this even further
- Discusses what can be achieved and the limitations

A Quick Guide to SQL
- Where Structured Query Language has come from and how it is used
- The basic syntax for SELECT
- and action queries
- Joins and aggregates

Using ADO & SQL
- Using a Data Environment and using the ADO object model directly
- Recordset manipulation
- The SQL Builder utility
- Commands, queries and parameter passing
- Dynamic SQL
- Queries involving multiple tables and joins
- Executing action queries

The Report Designer
- How the designer works
- Creating sophisticated reports from your database information using
the Report Designer and SQL

Multi-User Considerations
- Sharing database data
- Record locking and why we need it
- Optimistic, batch optimistic and pessimistic locking
- Why we need transactions and how these are implemented

Using Enterprise Data
- Open DataBase Connectivity (ODBC) and OLEDB
- Connecting to remote databases
- Using stored procedures
- Client and server-side cursors
- 2 and 3-tier architectures