Oracle OCA Certification
This series maps to exam objectives for the Oracle Database. 10g: Administration 1 exam 1zo-042, for Oracle 10g OCA certification. Plus, the training covers topics from the Oracle 9i OCA exams, making distinctions where a new feature applies to just 10g.
OCA is industry-recognized as a great way to add basic Oracle DBA skills to your resume, and is required for advanced Oracle certification. Many employers consider OCA certification as a knowledge baseline for new hires to start working on their Oracle database. Earning OCA certification can be just what you need to jump start your Database Administration career.
Prequisities:
Basic computer network knowledge such as A+ and Network+ or equivalent knowledge is recommended before viewing these videos.
The Oracle 9i/10g OCA Series contains these videos:
- Series Intro
- SQL *Plus and ISQL *Plus
- Installing Oracle Software and Creating a Database
- Oracle Database and Instance Architecture
- Startup, Shutdown, and the Initialization File
- Managing Tables, Views, Constraints and Sequences
- Data Moving Utilities
- PL/SQL Basics
- Triggers, procedures, functions
- Packages
- Managing undo
- Tablespaces
- Managing Users
- Oracle net services
- Oracle’s Shared server option
- Oracle Security
- Locks, latches and waits
- Performance
- Backup and Recovery Techniques
- Backups using RMAN
- Database recovery
- Enterprise Manager
