| Course Title |
Course Description |
| SQL *Plus and PL/SQL |
This course will teach participants how
to manipulate SQL commands and PL/SQL blocks. At the end of the course, they will
be able to:
- enter, edit , store, retrieve and run SQL commands and PL/SQL blocks
- list column definitions for any table
- access and copy data between SQL databases
- send messages to and accept responses from an end user
- format, perform calculations on and store query results in the form of reports
- create and manipulate simple database objects
|
| Oracle Forms |
This course will provide participants the
knowledge and skills to design and develop form-based applications for entering,
querying, updating, and deleting information stored in the database. |
| Oracle Reports |
In this course, participants will learn to
develop, display, and print reports. They will be able to create a wide variety
of reports including master/detail reports, nested matrix reports, form letter,
and mailing labels. |
| Oracle Database Administration
|
At the end of the course, participants
will be able to do the following database administration functions:
- Install and upgrade the ORACLE9i Server and application tools
- Create primary database storage structures and primary objects
- Allocate system storage and plan future storage requirements for the database
system
- Modify the database structure
- Enroll users
- Control and monitor user access to the database
- Back-up and recover the database
- Maintain and optimize database performance
- Use Oracle utilities
|
| I.T. Project Management |
This course aims to teach skills to develop
effective project managers. It is intended for people with some project management
involvement in IT projects either as project managers or senior analysts/programmers.
It consists of lectures, case studies, games and interactive discussions. By the
end of the workshop, the participants would have learned how to:
- Create and manage a project organization;
- Set practical goals for the projects and stay on top of schedules, workloads
and people problems;
- Acquire project management skills to ensure delivery of projects on time;
and
- Successfully manage change and risks that may lead to project failure.
|
| Information Systems Analysis |
The course is intended for programmers and
those involved in systems development work, who may also be tasked to take on
the role of systems analyst and/or designer. It gives the participant a good grasp
of the systems development life cycle and the tasks associated with each phase,
and enables them to build on the skills (technical and otherwise) they need to
effectively carry these tasks. Lectures, case studies and fun games are integrated
into the course to make learning more meaningful and relevant |
|