|
The best Oracle certification training site on the Internet.
FREE Online Courses
Video and CD's Info and Order!
Oracle Tutorial
Microsoft
MCSE
2000
Training
Microsoft
Office
MOUS
Certification
Access
2000
Excel
2000
Power
Point
Cisco
CCNA
CompTIA
Courses
SQL Server
IIS 4
TCP/IP
QuickBooks
RPG IV
Crystal Reports 8
XML
SAP R/3
GroupWise 5.5
GUI Programming
Visual Basic
Visual InterDev
Lotus Notes
Novell 560 CNE
Novell 570 CNE
SAS Tutorial
SAS 8
LAN Training
UNIX
Sybase
|
|
This course is for programmers and database administrators who will work with Oracle database products or Oracle Developer/2000.
This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.
- Introduction to PL/SQL provides an introduction to the PL/SQL procedural language extension to SQL.
- Overview of Developer/2000 presents the common features shared by the suite of tools in Developer/2000. These tools include Forms 4.5 Reports 2.5 Graphics 2.5 and Procedure Builder 1.5.
- Forms 4.5 and Reports 2.5 provides an overview of Forms 4.5 and Reports 2.5.
- Graphics 2.5 and Procedure Builder 1.5 provides an overview of Graphics 2.5 and Procedure Builder 1.5.
- Developer/2000 Applications explores the development of applications using Forms and Reports.
- Developer/2000 Integration explores the incorporation of Graphics displays into an application and the integration of Forms Reports Graphics and 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
This course is distributed with:
- Simulations that allow users to practice course skills, even if they don't have access to the product
- An glossary
All courses are included in "Tech General Pack"
All courses are design so that new knowledge and skills will be remembered and retrieved for future use. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth and stimulate job satisfaction.
|