Info Tech Universe
home
certifications
schedule
feedback
about us
contact us
my account
  

 
Certifications
Microsoft
 
MCSE
MCDBA
MCSD
MCP
Cisco
Novell
CIW
Programming
Other Courses
  

 
Certification News
New PC Upgrade and Maintenance Course has been released (more).
For other courses and schedules, please refer to the Schedule section.
 
 
 
certifications::microsoft::MCSD
MCSD (Microsoft Certified Solution Developer)
 

Designing and Implementing Desktop Applications with Visual Basic 6.0 (*Prices excludes GST)

Course Code Exams Sessions Hours Price ($AU)*
- 70-176 15 30 $2,000

Designing and Implementing Distributed Applications with Visual Basic 6.0 (*Prices excludes GST)

Course Code Exams Sessions Hours Price ($AU)*
- 70-175 15 30 $2,000

Course Outline

Designing and Implementing Desktop Applications with Visual Basic 6.0

This course is intended to provide attendees with the knowledge of how to create database applications using components.

  • General Review.
 
  • Creating an application.
  • Debugging and Error handling.
  • Compiling an EXE file.
  • Creating User Service.
 
  • Advanced use of control.
  • Creating Data Service.
 
  • Data bound control.
  • Active Data Object.
  • Creating and Managing COM component.
 
  • Class Modules.
  • Building ActiveX Controls.
  • Creating Active Documents.
  • Using COM Components.
  • Introduction to Using COM Components.
  • Creating a Client Application.
  • Deploying Application.
 
  • Optimizing and Deploying an Application.
  • Optimizing an application.
  • Deploying an application.
  • Debugging.

Course Prerequisites

The prerequisites for this course are a good working knowledge of Visual Basic. Potential students should be able to accomplish the following tasks before taking this course:

  • Create an application with multiple forms.
  • Write a Function procedure and a Sub procedure and invoke them.
  • Declare variables and use conditional statements.
  • Use of each of the controls in the Toolbox.
  • Use of menu.
  • Retrieve and validate information from a user.
  • Add a custom control to a project.
  • Describe the relationship between properties, methods, and objects.
  • Error handling.
  • Run the application and use debug mode within the Visual Basic environment.
  • Create an EXE file from the project files.
  • Design and use a relational database.
  • Use SQL Syntax to create database queries.

Course Objectives

On completion of this course, participants should be able to:

  • Write a Visual Basic application that accesses data from a database.
  • Write a Visual Basic application that uses COM components.
  • Create an ActiveX Control; create a COM component.

Designing and Implementing Distributed Applications with Visual Basic 6.0

This course will teach Microsoft Visual Basic programmers, who currently build desktop applications and access corporate databases, the basics of how to build three-tier client/server solutions.

  • Microsoft Solutions Framework.
 
  • Introduction to MSF.
  • MSF Team Model.
  • MSF Process Model.
  • MSF Application Architecture Model.
  • Building COM DLLs with Visual Basic.
  • Implementing business services in Microsoft Visual Basic.
  • Implementing an interface.
  • Microsoft Transaction Server.
 
  • Introduction to Microsoft Transaction Server.
  • MTS architecture.
  • Using MTS Explorer.
  • MTS security architecture.
  • Deploying an MTS component.
  • Using MTS Transaction Services
 
  • Transactions.
  • Context object.
  • Security (programmatic).
  • Debugging.
  • Error handling issues.
  • Creating an MTS component.
 
  • Creating a shared property.
  • Accessing Data from the Middle Tier.
  • Using stored procedures from ActiveX Data Objects.
  • Debugging.
  • Error handling.
  • Security.
  • Using ActiveX Data Objects to implement data services.
 
  • Building Stored Procedures with SQL.
  • Introduction to Microsoft SQL Server.
  • Using data integrity.
  • Querying data.
  • Programming with T-SQL.
  • Writing stored procedures.
  • SQL Server security.
  • Examining key registry settings.
  • Using OLE VIEW.

Course Prerequisites

This course assumes that the student has intermediate Visual Basic programming skill. Before attending this course, students must be able to demonstrate the following skills:

  • Build and debug a simple Visual Basic application.
  • Create code components using Visual Basic and invoke them from a client application.
  • Use ActiveX Data Objects to open a database and work with record sets.

Course Objectives

On completion of this course, participants should be able to:

  • Use the Microsoft Visual Basic programming system to build component object model (COM) dynamic-link libraries (DLLs) and implement them in a multiuser environment using Microsoft Transaction Server (MTS).
  • Use MTS to address application infrastructure issues associated with building server-side COM objects that are used by many clients.
  • Create COM objects that use MTS services to participate in transactions and that use security.
  • Use programming techniques to increase the scalability of COM objects.
  • Use ADO from the middle tier to access data.
  • Implement business and data services in a Microsoft SQL Server database.
  • Apply basic debugging, error handling, and security techniques in a three-tier application.