Visual Basic hands-on training class, course in the UK, USA, FL.

Web Tech, USA
1-800-279-9717

Web Tech, UK
+44 (0) 1452 814 303

Quick Search:

Visual Basic Power Programming | UK Only

Next Course Dates

Duration

4 days

Pre-requisites

A solid programming experience with Visual Basic 5 or Visual Basic 6, preferably to the level of our VB Power course, is essential. You should be familiar with the creation of classes and ActiveX DLLs.

Who Should Attend?

The course is intended for experienced Visual Basic programmers who require a fast-track introduction to the development of advanced database applications.

Course Benefits

Visual Basic 6 has a number of powerful and sophisticated tools that work hand in glove with Microsoft SQL Server, providing a compelling reason for choosing this combination. Visual Basic 6 can also create components that interact closely with Microsoft Transaction Server. This course teaches you how to combine these elements to create robust and powerful multi-tiered client-server applications in Visual Basic 6.

You Will Learn How To:

Develop client-server applications using ADO ( ActiveX Data Objects)
Use powerful Visual Basic 6 data tools such as the Data Link window, the Data Environment Designer and the Transact-SQL Debugger
Write SQL Server stored procedures using Transact-SQL · Design and implement a multi-tier database application
Create ActiveX components that interact with Microsoft Transaction Server (MTS)

Course Content

Client-Server Concepts
Client-server architecture | Cursors | Concurrency & locking | Transactions & referential integrity | Validation techniques | Stored procedures | Batch updates

Overview of SQL Server
Devices & databases | Stored procedures | Transact-SQL

Visual Basic 6 Database Tools
Data Link window | Data Environment | Transact-SQL

Accessing SQL Server from VB
Overview of ADO, DAO and RDO | ODBC | OLE DB | ActiveX Data Objects (ADO)

ActiveX Data Objects (ADO) In Depth
The ADO object model | Connection, Recordsrt, Command, & Field objects | The ADO event model | Dealing with errors | Hierarchical recordset | Disconnected recordsets & RDS (Remote Data Services)

Server-Side Programming
Creating stored procedures with Transact-SQL | Implementing triggers | Declarative referential integrity | The transact-SQL Debugger

Client-Side Programming
Connecting to the server | Data maintenance | Client-side validation | Handling stored procedures: input & output parameters, return codes | Batch updates | Concurrency & locking issues | Error handling

Creating Business Objects & Servers
Splitting up a "traditional" application | The Presentation, business & data services tiers | Designing classes - properties & methods | Implementing in-process & out-of-process services | Creating the "business server" | COM & DCOM performance issues | Distributing objects with DCOM

Microsoft Transaction Server (MTS)
MTS concepts | Implementing a server in MTS

Hands on Sessions

Use ADO to access and manipulate data
Maintain data using procedural code and stored procedures
Deal with messages, errors and events · Build business objects and a business server using ActiveX
Build ActiveX components that work with MTS
Design and implement a simple multi-tiered application

Copyright 1996 - 2013 - Web Tech Training & Development - All Rights Reserved

[ home ] [ contact ] [ courses ] [ register ]