Advanced Visual Basic Programming

 View Dates & Sign Up ·  Print Brochure ·  Email Reminder ·  Bring On-site

Detailed Overview/Outline

PREREQUISITES: Visual Basic programming experience.

DURATION: 5 days

DESCRIPTION: This hands-on advanced Visual Basic Course emphasizes two main topical areas: component programming in Visual Basic, and connecting client applications to databases. In the Course’s hands on exercises, the student will learn to create Visual Basic programs that both use and provide components. Win32 API programming and object-oriented programming is presented to ground the student in Windows programming principles. Students will create components that can be deployed directly to the client’s machine and shared by multiple client programs using in-process and out-of-process COM servers, including implementation of COM server multi-threading and the creation of DLL's. The student will also create components that can be deployed to Microsoft Transaction Server (MTS) mid-tier server. The Course provides extensive practice developing database client/server systems. This Course provides thorough coverage of building 3-tier, component-oriented client applications that can use OLE DB and ADO to connect to both local JET databases as well as remote SQL server databases. Visual Basic’s new Data Environments, Data Connections, Data Commands, Data Reports, and other database development tools are covered in depth. Participants will be able to develop Visual Basic clients that invoke stored procedures on database servers, and use Visual Basic’s new Query and Diagramming tools. Students will also learn how to use Visual Basic’s new WebClasses to create Internet Information Server (IIS) components that allow connection to data sources from interactive web applications.

Overview of Topics Covered
Windows API Programming

• Windows API Concepts
• The Win32 API
• Declare Statements
• Converting Visual Basic Variables to C Variables
• Asynchronous Calls and Callbacks

Writing Multithreaded COM Servers

• Threading Concepts
• Shared Resources
• Blocking and Deadlocking
• Apartment Threading
• Thread Pooling

Review of Object-Oriented Programming

• Classes
• Methods and Properties
• Private vs. Public Items
• Object Variables
• Instancing with New
• Instancing with CreateObject
• Implementing Interfaces
• Type Hierarchies and Polymorphism
• Events and Objects: WithEvents and RaiseEvent

Creating COM Component Servers and Clients

• Component Concepts
• COM and ActiveX
• Component Servers
• .DLL Servers v. .EXE Servers
• In-Process v. Out-of-Process Servers
• Multi Use and Single Use Components
• Compiling a COM Server
• Creating a COM Client
• Friend Methods
• COM Versioning
• Creating a DLL

Creating Components for IIS

• Web Classes
• Active Server Scripts
• IIS Components
• VBScript and COM
• ActiveX Controls on Web Pages
• Deploying ASP Applications

Writing Data Reports

• Report Concepts
• Using the Report Designer
• Using Crystal Reports Designer
• Developing Customizable Reports

Creating ActiveX Controls and Documents

• User Controls
• Interface Development
• Control String
• Property Pages
• Compiling .OCXs
• ActiveX Documents
• Deploying Controls

Developing Database Desktop Clients

• Database Concepts
• Data Environments and Data Connections
• Microsoft JET Databases
• Network Database Servers
• ODBC, RDO and OLE DB/ADO
• Data Binding
• Data Object Libraries
• Client/Server Model
• Creating JET Database Clients
• Creating SQL Server Database Clients
• Handling Database Exceptions
• Record Locking
• Transaction Processing

Using SQL Server Design Tools

• Creating Tables
• Creating Diagrams
• Creating Relationships · Creating Queries

Stored Procedure Programming

• Stored Procedure Concepts
• Calling Stored Procedures
• Sending Parameters
• Retrieving ResultSets and Return Values
• Using the Stored Procedure Editor

Network and Internet Programming

• Using the Internet Protocols
• Using the Winsock Control
• Using the Web Viewer Control

Creating Components for MTS

• MTS Concepts
• Three-Tier DNA Systems
• Business Components
• MTS Servers
• MTS Clients
• Proxy/Stub .DLLs
• Transactions and Contexts
• Deploying MTS Applications

Creating DataSource Components

• Data Source Concepts
• Creating Data Binding Classes
• Creating Data Source Classes
• Creating Persistable Classes

Sponsor Background:
First-rate materials. Top-notch instructors. Small classes. Well-structured, challenging hands-on exercises. These are the critical elements of a truly effective training program – and the key reasons why Hands On Technology Transfer (HOTT) should be your source for software skills training. HOTT is dedicated to providing programming professionals like you with the skills and knowledge necessary to enhance competency and productivity. Whether you are moving into a new technology or advancing your current skill set, HOTT will provide you with an unparalleled learning environment.

Here’s why:

• Convenience HOTT offers courses at frequent intervals in a number of cities across the United States to help provide a location convenient to you. Easy access helps you minimize your travel time and expenses as well as down time from your job. There’s no financial penalty if you have to withdraw or change your plans after you register, so you can reserve your place as early as you’d like. And registration’s as easy as reaching for the phone.
• Perspective As an independent, dedicated training organization, HOTT offers a practical, realistic and unbiased view of competing technologies and products that you won’t get at training centers authorized by a particular software vendor. Our courses emphasize task-oriented, not product-oriented training – training that integrates technologies the way your business does. Because our instructors have cross-platform knowledge and experience, you’ll get the full picture – not just how to use a particular tool, but the issues involved in using multiple tools in today’s open environments, including practical design, architecture, and coding issues. You’ll understand technology well enough to create good designs before you code – and be prepared to design for a client/server, cross-platform or multi-tier environment. HOTT prepares you to become a more knowledgeable, efficient, effective and valuable employee, as well as a more educated technology consumer.
• Quality In addition to being seasoned professional trainers, our instructors also have many years of training and industry experience working in their respective fields. Practiced developers, software engineers, and system administrators, they understand the challenges you face in your job and have first-hand knowledge of the skills you need to succeed. Extensive national and international teaching experience has prepared our instructors to manage a variety of group dynamics and relate to foreign students, ensuring all participants’ full involvement and success.
• Substance HOTT class sizes are kept significantly smaller than classes at other national training firms in order to provide you with more personalized attention, more focused content, and greater access to instructors for problems and questions. We continually refine and upgrade our courseware to reflect new product features and industry requirements. Equally important, we’ve built our materials and curriculum to reflect the needs of our students as they have communicated them to us. As a result, you don’t just learn what we think you should learn, you learn what other professionals like you have identified as necessary to their jobs. You’ll find HOTT labs exceptionally challenging. Their objective is to provide an in-depth, hands-on experience that replicates real work experience and trains you to deal with the complexities of real scenarios. With an average class size of 12 students, you’re assured full attention from the instructor. Course materials, including student and lab guides and your lab software, are yours to keep. Certain courses also include a complimentary industry textbook, which provides additional supporting information and reference material.
• Value HOTT delivers high-quality training, with all the benefits of small-size classes, at highly competitive prices. Special rates for large groups attending our public classes save you even more. For extensive individual training needs, HOTT Training Pass provides an extremely cost-effective option. And we can often charge far less than you’d think to bring a tailored program right to your facility.
• Selection HOTT’s extensive offerings include introductory and advanced courses in Object Oriented Analysis and Design, C++, Visual C++, MFC, Win32, ActiveX, COM, Visual Basic, UNIX, X/MOTIF, ANSI C, Windows NT, Java, Networking, Web Programming, and more. Because we focus on advanced programming skills, you’ll find a greater selection of advanced courses at HOTT than at most other training centers. An even greater array of highly focused courses are available for delivery at your site.

Quote From Past Participants:
"Great class, covered a lot of information. I found the interaction between instructor and students an excellent learning tool - especially questions from the experienced VB programmers."

Get updated when new dates are added for this seminar.

Get a free personalized recommendation from our experts!

Questions? Please call us Toll-free at (877) SEM-INFO.