Application Development and Administration

Students will receive the basics of Oracle user, system and object security and will be exposed to some additional available security features. Students will also be introduced to PL/SQL programming and related concepts, and will learn to write a basic program unit capable of performing simple functions.

Students will also be exposed to backup and recovery concepts. Drawing from the fundamentals learned in the first class, they will not only understand the available backup tools, but they will be able to design a backup process appropriate for a typical recovery requirement.

Finally, students will learn additional system management techniques for managing Oracle software within the context of the UNIX or Linux operating system.

Topics include:

• Security (Users, roles, and profiles, System and object privileges, Authentication, Auditing, Network security, OS security)
• PL/SQL
• Data types
• PL/SQL fundamentals
• Cursors and variables
• Control structures
• Packages, procedures, and functions
• Triggers
• Exception handling and pragmas
• Transactional control
• Backup and Recovery (Archive modes, LOGGING and NOLOGGING, Flash recovery and flashback database, RMAN: Backup, recovery and the RMAN catalog, Data Pump)
• System Management (Automatic Diagnostic Repository, reverse engineering w/ Metadata)
• OS housekeeping (Log rotation, file system cleanup, etc.)
• Scheduling database and Linux cron jobs
• Moving tables, Index-Organized Tables, Index rebuilds, Materialized Views
• Oracle Inventory and Software Patching
• Automated startup and shutdown
• Oracle 11g new features

Find the Offering That's Right for You

We offer programs throughout the year in different locations and learning formats designed to meet your education needs. To learn more about this program, select one of the following sections.