|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.
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,
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
2. Oracle SQL: DDL and DML
3. Develop Applications Using Procedural Capabilities (PL/SQL)
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.