VB Training

Microsoft Certified Partner

Advanced Visual Basic Programming

Duration: 5 days | Price: $2495 | Class Dates:

Students Will Learn:

Win32 API
COM Components and Clients
Multithreaded COM Servers
Building ActiveX Controls

ADO/ODBC
Data-Aware Components
IIS Applications
Multi-Tier Programming

Description: This hands on Visual Basic training course emphasizes object-oriented programming, component development and deployment, and techniques for connecting client applications to databases. Students start by interacting directly with the Win32 API to provide grounding in important Visual Basic programming principles. Students are then shown how to design and use class hierarchies. In the course's hands on exercises, students gain direct experience creating Visual Basic programs that both use existing components and create new ones. Students create both in-process and out-of-process COM components that can be deployed directly to the client's machine and shared by multiple client programs, as well as in-process components that can be deployed to remote servers.

Students build ActiveX controls that can be used both in Windows applications and on web pages. The course provides extensive practice developing database client/server systems. It provides thorough coverage of building 3-tier, component-oriented client applications that can use both RDO (ODBC) and ADO (OLEDB) to connect to databases. Students practice low-level programming to retrieve and output data from databases, invoke stored procedures, and also use Visual Basic database development tools such as DataView, DataEnvironment, and DataReport. Students also use a suite of Microsoft's ActiveX controls to interact with a local area network and/or the internet.

Prerequisites: Visual Basic programming experience.

Advanced Visual Basic Programming Course Overview:

Windows API Programming Understanding the Win32 API Interacting with the Win32's C Data Structures Using the API Text Viewer Using Declare Statements Calling Win32 Functions COM Components and Clients Understanding COM and ActiveX Creating a COM Component Registering a COM Component Using the OLE/COM Object Viewer Tool Controlling COM Component Versions Creating a COM Client Interacting with a COM Server using Late Binding Interacting with a COM Server using Early Binding Understanding the Differences between .DLL and .EXE Components		Object-Oriented Programming Understanding Classes and Objects Understanding Private vs. Public Members Defining Classes Defining Data Members Defining Methods and Properties Instancing Objects using New Instancing Objects using CreateObject Calling Methods and Properties using Object Variables Defining Events Trapping Events Understanding Interfaces Implementing Interfaces Using Interfaces Defining Type Hierarchies Using Polymorphism
Multithreaded COM Servers Understanding Threading Understanding VB's Limited Threading Capabilities Comparing Thread Per Object and Thread Pool Options for Threading Comparing Single Use and Multi Use Options for Instancing		ActiveX Controls Understanding the ActiveX Control Standards Building an ActiveX Control Designing the GUI Interface Implementing Methods and Properties Interacting with Extended and Ambient Properties Implementing Property Pages Persisting Properties Testing the ActiveX Control Using the ActiveX Control Interface Wizard Deploying Controls
Developing Database Desktop Clients Understanding RDO (ODBC) and ADO (OleDb) Technologies Registering a Data Source Name (DSN) using the ODBC Administrator Using the DataView Tool Connecting to a Database Executing Queries Interating through Records Working with Transactions Controlling Record Locking Working with the DataEnvironment Tool Handling Database Exceptions		Stored Procedure Programming Understanding Stored Procedure Concepts Calling Stored Procedures Sending Parameters Retrieving ResultSets and Return Values Using the Stored Procedure Editor
Data Reporting Understanding Reporting Concepts Designing a Report Interacting with a Report's Properties Binding a Report to a Query Displaying a Report Using Report Functions Working with Group Sections		Visual Data Manager Understanding the Visual Data Manager's Capabilities Creating Databases Creating and Modifying Tables Defining Relationships Creating Schema Diagrams
Data-Aware Components Understanding Data Providers and Data Consumers Creating Data-Bound ActiveX Controls Creating Data Sourced Components

Student Testimonials

"Hands on labs are a very good idea, it solidifies the learning more then I have experienced in other classes."
– S.N., Sirius Satellite Radio

"Thank you for the excellent course. I am looking forward to my next two courses. Thank you also for your patience and flexibility in setting up my course schedule."
– J.L., Independent Contractor

"Excellent course! Objectives covered were exactly what I needed! Instructor was fantastic and demonstrated a thorough knowledge of topics."
– V.S., Mutual of Omaha

Northeast/New England	Southeast	Midwest	West/Southwest	Canada	United Kingdom
CT - Hartford CT - New Haven CT - Stamford DC - Washington MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence	AL - Huntsville FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah LA - Shreveport NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem SC - Charleston VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg	AR - Little Rock IA - Cedar Rapids IA - Des Moines IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - St. Charles MO - Springfield NE - Omaha OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa TN - Memphis TN - Nashville WI - Milwaukee	AZ - Phoenix AZ - Tucson CA - Bakersfield CA - Fresno CA - Irvine CA - Los Angeles CA - Modesto CA - Oakland CA - Riverside CA - Sacramento CA - San Diego CA - San Francisco CA - San Jose CA - Santa Clarita CA - Santa Monica CA - Temecula CO - Denver ID - Boise NM - Albuquerque NM - Las Cruces NV - Las Vegas OR - Portland TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City WA - Seattle WA - Spokane	AB - Calgary AB - Edmonton BC - Vancouver MB - Winnipeg QC - Montreal QC - Quebec City ON - Kingston ON - Mississauga ON - Ottawa ON - Toronto SK - Regina	Birmingham Bristol Chelmsford Edinburgh Glasgow Leeds Liverpool London Manchester

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299