Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

  Beck-Bites
Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

 Visual Basic Database Programming

  Course Code - GN-102   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 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

© Beckinridge Ltd.

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development