Training that's Easy, Convenient and Affordable! High-quality, online, self-paced training designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else.

Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

Try our FREE courses right now, and see for yourself how much you will learn!

This course is for programmers and database administrators who will work with Oracle database products or Oracle Developer/2000.

Introduction to PL/SQL provides an introduction to the PL/SQL Oracle's procedural language extension to SQL.
Overview of Developer/2000 presents the common features shared by the suite of tools in Oracle Developer/2000. These tools include Oracle Forms 4.5 Oracle Reports 2.5 Oracle Graphics 2.5 and Oracle Procedure Builder 1.5.
Forms 4.5 and Reports 2.5 provides an overview of Oracle Forms 4.5 and Oracle Reports 2.5.
Graphics 2.5 and Procedure Builder 1.5 provides an overview of Oracle Graphics 2.5 and Oracle Procedure Builder 1.5.
Developer/2000 Applications explores the development of applications using Oracle Forms and Oracle Reports.
Developer/2000 Integration explores the incorporation of Oracle Graphics displays into an application and the integration of Oracle Forms Oracle Reports Oracle Graphics and Oracle Procedure Builder applications through a single point of entry for the user.

After completing our courses, the user should be able to:

Describe the building blocks of PL/SQL and its environment
Explain the benefits of the basic components of PL/SQL structures
Explain the benefits of packages over stand-alone procedures and functions
Create various types of triggers
Create and use procedures
Navigate the menus and toolbars of the development environment
Describe the features available for editing and debugging an application
Explain the features that provide object-orientation product integration and OLE2 support
Develop a Forms application a menu and a library
Use the PL/SQL Editor in Forms
Develop tabular and master/detail reports
Use the Data Model Editor Parameter Form Editor and Program Unit Editor in Reports
Develop a pie chart and a column chart
Use the Chart Template Editor in Graphics
Develop functions procedures packages and database triggers
Use the Database Trigger Editor in Procedure Builder
Create Forms templates containing visual attributes property classes a toolbar and triggers
Use OLE2 in your application
Use Visual Basic Custom Controls to enhance your application
Create Reports templates containing standard headers trailers and margin items
Create break drill-down and integrated application reports using templates and OLE2
Add buttons and PL/SQL to drill-down into a detail report
Create a report trigger for auditing
Create a parameter-driven display
Pass parameters from Forms to Graphics
Create a format trigger to conditionally modify a chart
Import an image file
Create multiple environments for development testing demonstration training and production
Recognize GUI styles and standards
Optimize memory disk space and performance
Insert OLE2 objects into an database

Our courses have special design features listed below:

Certificates of Completion
Instructional steps -- walk through a procedure
Exercises -- try it out
Notes - See additional information related to the topic in the text
Tips - See a different, faster, or easier way of doing something
Quick References - See a quick reference guide to the features introduced in a chapter
Details - Display more detailed information related to the current topic
Hotwords - See related information
Navigation Bar - Maneuver easily through the courses
Microsoft Approved Courseware Logo - to prepare you for a Microsoft certification
Course Topics and Index -- with searching feature and hyper-links
Printable Exercises - PDF downloadable files
Sample Application Files - PDF downloadable files
Course Glossary
Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.