Computer SciencePrograms

Find Your Programs

Database Administration (Oracle Administrator)

course code : DBA 100

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 codes 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 learn how to declare and control cursors. This course introduces the trainee to the main concepts of Oracle Reports Developer. Trainees get to design reports and retrieve, display, and format data in numerous reporting styles as well as 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.
  • Create stored procedures and functions.
  • Use stored procedures and functions.
  • Write complex SQL Statements.

Apply Area

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