Visual Basic Database Programming
Course
In Portadown
Description
-
Type
Course
-
Location
Portadown (Northern Ireland)
-
Duration
2 Days
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
Facilities
Location
Start date
Start date
Reviews
Course programme
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
Visual Basic Database Programming