.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida
.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridadelphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida
 



 

Web Tech, USA
1-866-844-6179

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



 
Quick Search:

 

Visual Basic Power Programming | UK Only Next Course Dates    
Cost / Duration Price: UK £1,495 + VAT | 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 - 2010 - Web Tech Training & Development - All Rights Reserved

 

home ] contact ] courses ] schedule ] register ]