StarCom Group Software/Networking Training Center
Visual Basic + Oracle Developer (PL/SQL)

This course will help participants understand how Oracle tools methodologies and Visual Basic can be used to fulfill real-world business information requirements.

The first part of this course is designed to teach Visual Basic Fundamentals, and equip students with this most popular windows front end tool.

In the second part of this course, participants will learn how to design and create database structures to store, retrieve, update and display data in a relational database. Participants will also learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, web pages and applications developed by third party tools.

The third part of this course is to teach Window-based desktop application using Oracle objects for Visual Basic and OLE. Through this part of course, students are expected to eater the real working environment in which they will use Oracle Server, PL/SQL and Visual Basic to develop client/server applications.

Part I. Visual Basic

1. Introduction to Application Development Using Visual Basic

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

2. Visual Basic Fundamentals

Objects, properties, methods, and events, Form, control, and application, Object Browser Properties and methods of a form, Properties and methods of basic control, Changing properties and calling methods with code, Adding code to event procedures, Control accessibility.

3. Working with Code and Forms

Working with the code window, Interacting with the user, Working with code statements, Managing forms, Ending your applications.

4. Variables and Procedures

Variables, Constants, Converting data types, Working with procedures.

5. Controlling Program Execution

Common visual basic functions, comparison and relatioonal operators, conditional structures, looping structures.

6. Debugging

Types of errors, Debugging toolbar, Break mode, Debug window.

7. Working with Controls

Types of controls, standard controls, advanced stardard controls, activeX controls, insertable objects.

8. Data Access Using the Data Control

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.

9. Input Validation

Field-Level Validation; The Masked Edit Control; Form-Level Validation; Form-Level Validation; Form Events Used When Validating Data.

10. Error Trapping

Trapping Run-Time Errors; Error Handling

11. Menus, Status Bars, and Toolbars

Menus; Using Menu Editor; Pop-Up Menus; Status Bars; Toolbars

12. More about Controls

Using Control Arrays; Using the Controls Collection; Working with Object Variables; Collections

Part II. Oracle Application Developer (PL/SQL)

1. Oracle Server

  • Introducing Oracle Server Concepts and Architecture, like databases and information management, the Oracle server (memory, structure and processes), database structure and space management, data access, data concurrency and consistency, distributed processing and distributed databases, database security, data access, database backup and recovery, ER model, the object-relational model.

2. Oracle SQL: DDL and DML

  • Retrieve and Display Information. Query, display and format data. Save, retrieve and run queries. Build and format reports. Group and summarize data.

  • Manipulate Information. Insert, update, automatically generate and delete data. Control transaction processing.

  • Create Tables and Data Structures. Create, confirm, modify and remove tables to store data. Apply business rules to ensure data integrity. Restrict user access into tables. Improve query performance.

  • Control User Access. Grant, confirm and remove system and object privileges. Create and remove user roles.

  • Perform Computations with Data. Perform calculations with numeric, date and character data. Count, group and summarize data.

  • Display Data from Multiple Tables. Display data and create a view of multiple tables.

  • Nest Queries. Nest, subqueries within another SQL command.

3. Develop Applications Using Procedural Capabilities (PL/SQL)

  • PL/SQL fundamentals. Describe PL/SQL block structure. Define input and output values. Describe PL/SQL control structures. Insert and manipulate data with PL/SQL. Execute SQL statements from a PL/SQL block. Discuss a typical development cycle.

  • Develop and Debug PL/SQL Programs in Procedure Builder. Create, manage, and execute program units using the Object Navigator and the PL/SQL Interpreter. Define and compile procedures using the Program Unit Editor. Control the execution of a PL/SQL program unit. Test possible solutions by making changes to variables and procedures at runtime.

  • Prototype PL/SQL Blocks. Manipulate multiple rows with cursors. Pass values to PL/SQL blocks using variables. Define variables based on predefined objects. Execute statements conditionally. Enhance code using cursor FOR loops. Pass values between cursors.

  • Implement and Test PL/SQL Blocks. Modularize code. Pass values from one program construct to another. Handle errors. Follow programming standards.

Part III. Windows-Based Client/Server Application

Working in a windows graphical user interface (GUI) development environment participants will build windows-based desktop applications using Oracle Objects for OLE, VB, etc.

  • Connect to the database. Perform queries against database. Navigate the records returned by queries. Insert records. Update records. Delete records. Execute stored procedures. Handle the LONG datatype. Trap errors, etc.

  • How to design and develop Client/Server application using Oracle Server, SQL*Net, and windows frontend tools. A business project implementation.

  • Real project to be introduced in class and lab session.