This training program is designed for people who are interested in entering into computer programmer work force, yet are having little or no prior knowledge and/or experience in computers. With our strong training team, coupled with a variety of business cases and real projects, we strive to lay a solid foundation for our trainees, and equipt them with the best basic computer skills, strong enough to qualify for a good entry level programmer position. In the mean time, participants will have obtained enough computer knowledge to make intelligent decisions on further professional development to build a successful career in the computer software profession.

Class Schedule: Total 80 hours (Teaching & Guided Lab/Project)

Tuition: $1550.00

What is Microsoft Visual Basic

Development environment

Introduction to programming concepts

Files involved in a project

Steps to create an application

Tutorials and Help

Define the elements in the development environment

Differentiate the terms design time and run time

List file types that can be included in a project

Describe the purpose of a project .vbp file

Objects, properties, methods, and events

Form, control, and application

Object Browser

Properties and methods of a form

Properties and methods of basic controls

Changing properties and calling methods with code

Adding code to event procedures

Control accessibility

Working with the code window

Interacting with the user

Working with code statements

Managing forms

Ending your applications

Variables

Constants

Converting data types

Working with procedures

Common visual basic functions

comparison and relational operators

conditional structures

looping structures

Types of errors

Debugging toolbar

Break mode

Debug window

Types of controls

standard controls

advanced standard controls

activeX controls

insertable objects

Fundamentals of Client/Server Computing

Visual basic Database Access Features

Fundamentals of Relational Database

Using the Data Control to Access Data

Manipulating Data

Using the Data Form Wizard

Field-Level Validation

The Masked Edit Control

Form-Level Validation

Form-Level Validation

Form Events Used When Validating Data

Trapping Run-Time Errors

Error Handling

Menus

Using Menu Editor

Pop-Up Menus

Status Bars

Toolbars

Using Control Arrays

Using the Controls Collection

Working with Object Variables

Collections

The Database Developer

Designing Database

Creating and Managing Database Objects

Accessing Data in databases

ODBC

Data Access Model for Visual Basic

DAO

RDO

ADO

OLE DB

VBSQL

Oracle Objects for OLE

Optimizing Database Application

Creating Tables

Using Index

Using View

Data Integrity

Basic Queries

Using Join for multipletable queries

Using subqueries

Using GROUP BY, HAVING, etc Clauses

Using Built-in Functions

Adding, Changing, or Removing Data

Processing Transactions in Batches

Creating Stored Procedures

Using Triggers to Define Business Processes

DAO Overview

Connecting to SQL Server

Working with Recordsets

Modifying Data

Finding Records

Using Queries

Using SQL Pass-Through Queries

Working with Stored Procedures

Handling SQL Server Messages

RDO Overview

Connecting to SQL Server with RDO

Building Result Sets

Data manipulation

Working with Stored Procedures

Using RDO UserConnection Designer

Using the Transact-SQL Debugger

Using RemoteData Control

Oracle Overview

using Oracle Objects for OLE

Compare OOO with other OLE controls

Illustrations with examples

Oracle database and how it works

Introduction to SQL & PL/SQL