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:
01.Series Intro
02.SQL *Plus and ISQL *Plus
03.Installing Oracle Software and Creating a Database
04.Oracle Database and Instance Architecture
05.Startup, Shutdown, and the Initialization File
06.Managing Tables, Views, Constraints and Sequences
07.Data Moving Utilities
08.PL/SQL Basics
09.Triggers, procedures, functions
10.Packages
11.Managing undo
12.Tablespaces
13.Managing Users
14.Oracle net services
15.Oracle’s Shared server option
16.Oracle Security
17.Locks, latches and waits
18.Performance
19.Backup and Recovery Techniques
20.Backups using RMAN
21.Database recovery
22.Enterprise Manager
This post contains video for topic “Triggers, procedures, functions”. Hope you like the series.


Oracle 9i/10g OCA Series CBT Nuggets Part 9 | Bazish.Net … | Drakz Free Online Service : 12 January 2010 at 2:12 pm
[...] here: Oracle 9i/10g OCA Series CBT Nuggets Part 9 | Bazish.Net … Share and [...]