Developing Visual Basic/SQL Server Applications

Instructors: Ken Spencer or Ken Miller

Authors of books on NT and Visual Basic published by Microsoft Press, IDG, and Prentice Hall and frequent contributors to Visual Basic Programming Journal.

Duration: 2 days lecture only/3 days with hands-on labs

Seminar Description and Objectives

The most common programming activity undertaken with Visual Basic is also the most complex: Client/Server data access. This seminar identifies the different data access methods, and discusses in detail the advantages and disadvantages of each. Topics covered include:

• Understanding SQL Server's Role
• Remote Data Objects and the Remote Data Control
• Appropriate Cursor Usage
• Using the JET Engine
• ODBC Data Access
• Stored Procedures/Trigger/DRI
• Stored Procedures in Visual Basic
• VBSQL vs. ODBC vs. JET

Optional Hands-on Labs

Labs are available as an add-on option. The are interspersed throughout the class and extend it to 3 days. The hands-on learning environment permits the students to experience these techniques immediately.

PREREQUISITES

Attendees should have experience building Visual Basic applications and familiarity with some database product, preferably Visual Basic's JET engine. Experience with SQL Server is not a requirement.

About the Instructors:
Ken Miller
Ken Spencer

Fees and Scheduling

OTHER SEMINARS BY David Solomon Expert Seminars