Computer SciencePrograms

Find Your Programs

Advanced Oracle10g SQL, PL/SQL (Oracle Developer)

course code : IOSPS201

course hours : 40 hours

PREREQUISITE : N/A

Course Description

This course introduces trainees to PL/SQL and helps them understand the benefits of this powerful programming language. Trainees learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Trainees get to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also declaring and controlling cursors. This course introduces the trainee to the main concepts of Oracle Reports Developer. Trainees will design reports and retrieve, display, and format data in numerous reporting styles and publish the output. Adding dynamic content to a static Web page, publishing reports on the Web, customizing complex reports, and embed charts are also included. This course is presented in an intensive workshop format where participants absorb the complex topics of object hierarchies, frame hierarchies, field-level control of report output and many other subjects.

Learning Outcomes

By the end of the course, participants will be able to:

  • Create reports of sorted and restricted data
  • Develop forms to store and validate data
  • Create anonymous PL/SQL blocks
  • Produce stored procedures and functions
  • Use stored procedures and functions
  • Write complex SQL Statements

Apply Area

© 2017 All Rights Reserved. Future University in Egypt (FUE)