Welcome to the e-Learning Oracle Introduction & PL/SQL course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning Oracle Introduction & PL/SQL course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning Oracle Introduction & PL/SQL

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning Oracle Introduction & PL/SQL course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning Oracle Introduction & PL/SQL course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning Oracle Introduction & PL/SQL online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

This Online Oracle Training is for programmers and database administrators who will be using PL/SQL with Oracle database products or Oracle Developer/2000.

This training presents the common features shared by the Oracle Developer/2000 suite of tools, including Forms 4.5, Reports 2.5, Graphics 2.5, and Procedure Builder 1.5

About the course

Introduction to PL/SQL -  Duration 5 Hour(s)

• This course provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL. 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

Overview of Developer/2000 - Duration 6 Hour(s)

• This course 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. 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

Forms 4.5 and Reports 2.5 - Duration 6 Hour(s)

• This course provides an overview of Oracle Forms 4.5 and Oracle Reports 2.5. Develop a Forms application, a menu, and a library Use the PL/SQL Editor in Oracle Forms Develop tabular and master/detail reports Use the Data Model Editor, Parameter Form Editor, and Program Unit Editor in Oracle Reports

Graphics 2.5 and Procedure Builder 1.5 - Duration 6 Hour(s)

• This course provides an overview of Oracle Graphics 2.5 and Oracle Procedure Builder 1.5. Develop a pie chart and a column chart Use the Chart Template Editor in Oracle Graphics Develop functions, procedures, packages, and database triggers Use the Database Trigger Editor in Oracle Procedure Builder

Developer/2000 Applications - Duration 8 Hour(s)

• This course explores the development of applications using Oracle Forms and Oracle Reports. Create Oracle 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 Oracle 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

Developer/2000 Integration - Duration 5 Hour(s)

• This course 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. Create a parameter-driven display Pass parameters from Oracle Forms to Oracle Graphics Create a format trigger to conditionally modify a chart Import an image file Create multiple environments for development, testing, demonstration, training, and production recognise GUI styles and standards Optimise memory, disk space, and performance Insert OLE2 objects into an Oracle database

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here