Skip to Content Text Only

SITEMAP

• Current Class Schedules
• Customized Contractual Education
• 4 Ways to Register
• Rent a Computer Lab
• Upcoming Events
• Directions & Parking
• General Information About CTU
• MCE&CE Home Page

• Welcome Message
• Request Information

• Sitemap
• Search
• Adverse Weather
• Contact Us

Oracle Database Administrator 10g Program (DBA)

Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills.

Suggested Prerequisites: Working knowledge of SQL. Should have clear understanding about Database concepts. Worked with at least one database management system, for example MS Access.

In order to become Oracle 10G Certified DBA you will have to pass both the Workshop I and Workshop II

Duration: 120 contact hours
Tuition: $4999

WORKSHOP I: Program with PL/SQL

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. Demonstrations and hands-on practice reinforce the fundamental concepts.

Suggested Prerequisites: Should have taken Oracle Database 10g: Introduction to SQL course.

Duration: 40 contact hours
Tuition: $1999

Attend and You Will Learn

• Design PL/SQL anonymous blocks that execute efficiently
• Write PL/SQL code to interface with the database
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Handle runtime errors
• Create simple procedures and functions
• Design PL/SQL packages to group and contain related constructs
• Categorize and Use the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output
• Schedule PL/SQL jobs to run independently
• Write dynamic SQL for more coding flexibility
• Create triggers to solve business challenges
• Manage dependencies between PL/SQL subprograms

WORKSHOP II: OCA

Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills.

Suggested Prerequisites: Working knowledge of SQL should have clear understanding about Database concepts, Worked with at least one database management system.

In order to become Oracle 10G Certified DBA you will have to pass both the Workshop I and Workshop II

Duration: 40 contact hours
Tuition: $1599

Attend and You Will Learn

• Install Oracle Database 10g and configure a database
• Manage the Oracle instance
• Manage the Database storage structures
• Create and administer user accounts
• Perform backup and recovery of a database
• Monitor, troubleshoot, and maintain a database
• Configure Oracle Net services
• Move data between databases and files

WORKSHOP III: OCP

The Oracle Database 10g OCP credential demonstrates your expertise with Oracle Database 10g, the industry's first relational database designed for grid computing. This advanced certification indicates to the marketplace that you know how to configure an Oracle database for multilingual applications, use various methods of recovering and tuning the database, and use database technologies such as Resource Manager, Scheduler, and Automatic Storage Management (ASM). The marketplace knows an Oracle Database 10g OCP can manage the most advanced information systems for large enterprises, small and midsize businesses, and departments.

Suggested Prerequisites: Working knowledge of SQL should have clear understanding about Database concepts, Worked with at least one database management system.

Duration: 40 contact hours
Tuition: $1599

Attend and You Will Learn

• Use RMAN to create and manage backup sets and image copies
• Recover the database to a previous point in time
• Use Oracle Secure Backup to backup and recover a database
• Use Oracle's Flashback technology to recover your database
• Detect block corruptions and take appropriate measures to correct them
• Use the various Database advisors and views to monitor and improve database performance
• Control database resource usage with the Resource Manager
• Simplify management tasks by using the Scheduler
• Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions
• Administer a VLDB
• Implement a secure database
• Transport data across platforms

or Phone/Fax/Mail
or call 919.515.8163