 |
Courses Offered
|
|
|
Oracle10g DBA Course
This practical foundation course is an essential
toolkit for all Database Administrators covering the practical skills needed by the DBA to perform the Oracle 10g
database administration function within their enterprise.
| Duration: | Four Weekends (Sat & Sun)Approx. 40 hrs |
| Skill Level: | Intermediate-Advanced |
| Price: | USD 895.00 |
Detailed Course Outline
Getting Started
- Introduction to Oracle RDBMS
- Oracle’s architectural components
- Interfaces with Oracle SQL*Plus, OEM
Installation & Configuration
- Installing the Oracle software
- Starting and configuring an Oracle Instance
- Creating an Oracle database
- Startup & Shutdown modes
Storage Management
- Setting up Tablespaces / Datafiles / Control Files
- Maintaining Online Redo Logs
- Understanding Undo Management
Database Objects
- Understanding Oracle Schemas
- Creating and managing Tables and Views
- Using Indexes, Sequences and Synonyms
- Maintaining Data Integrity using Constraints
Users Management
- Creating and altering Users and Roles
- Managing System and Object Privileges
- Database Security & Auditing
Database Utilities
- Usage of EXP/IMP
- Usage of SQL*Loader
Database Programming
- PL/SQL & Triggers
- Developing Functions, Procedures and Packages
- Writing Triggers
Advanced Topics
- Performance Tuning
- Resource Management
- Backup & Recovery
|
|
Employees Portal