Oracle Database 10g Administrator Certified Associate

Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.

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

Duration: 40 hrs

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

Attend and You Will Learn
Lesson 1: Oracle Database 10g: Program with PL/SQL
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
Lesson 2: Workshop I (Oracle Database 10g Administrator Cert
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
...''

Phone:919.515.8163

School Address:

Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA

Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh

Microsoft Office Specialist Access 2003
Microsoft Office Specialist Word 2003
Microsoft Office User Specialist Test Prep
Certificate in Network Security
CompTIA Network+
Oracle 9i: SQL
Oracle Database Administrator 10g (DBA)
Oracle Database 10g Administrator Certified Professional
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Security
Oracle DBA
Oracle Performance Tuning and Monitoring
CompTIA Security+

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.