CBT Nuggets Oracle 9i-10g OCA Series
Need to run an Oracle database? Studying for the 10g or 9i Oracle OCA exams?
The Oracle OCA Series teaches you the fundamentals of running and managing an Oracle 9i or 10g database, plus prepares you for the Oracle Certified Associate (OCA) exam.
Learn how to be an Oracle DBA
The series starts basic, but quickly moves on to teach you what you need to know to manage daily operations on an Oracle database as a Database Administrator (DBA):
- Install the Oracle software, plus configure how the database starts up and shuts down.
- Create a database, and create objects within it - following the standard database structure.
- Use SQL*Plus to input and output information from the database.
- Tune your database for better performance, and interpret poor performance to fix problems.
- Backup your database and easily recover data when the database goes down, using either OS commands or Recovery Manager.
- Implement Oracle networking and manage Oracle security.
- Easily monitor and manage daily operations on your database with Enterprise Manager.
Dive in and start working with Oracle
This training takes you from having little-to-no experience on Oracle, to managing your own Oracle database. If you're new to Oracle, this is just the start you need to dive in and start working in Oracle. If you already work with Oracle, this series can fill out your knowledge and teach you more about making Oracle function well, plus show you the latest features of Oracle version 10g.
Earn OCA certification
This series also maps to exam objectives for the Oracle Database 10g: Administration I exam 1Z0-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.
Prerequisites
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 (free video!)
- Performance
- Backup and Recovery Techniques
- Backups using RMAN
- Database recovery
- Enterprise Manager
Download:
http://rapidshare.com/files/25706879/oracle_10g.zip
http://rapidshare.com/files/25708600/oracle_10g.z01
http://rapidshare.com/files/26546631/oracle_10g.z02
http://rapidshare.com/files/26547093/oracle_10g.z03
