Oracle
Overview
Oracle Database 11g Administrator Certified Associate (OCA) Describing the Oracle Architecture Oracle Server SGA Datafiles Background Processes Creating an Oracle Database Database Configuration Assistance Database Templates Managing an Oracle Instance Oracle Enterprise Manager Database Storage Structures Tablespaces Datafiles Tempfiles Database Security System Accounts Application Accounts Database Roles.
Oracle Database 11g Administrator Certified Associate (OCA)
Describing the Oracle Architecture
- Oracle Server
- SGA
- Datafiles
- Background Processes
Creating an Oracle Database
- Database Configuration Assistance
- Database Templates
Managing an Oracle Instance
- Oracle Enterprise Manager
Database Storage Structures
- Tablespaces
- Datafiles
- Tempfiles
Database Security
- System Accounts
- Application Accounts
- Database Roles
Schema Objects
- Tables
- Indexes
- Views
- Synonyms
Data Manipulation Language
- Insert
- Update
- Delete
- Database Packages
- Database Procedures
Undo Data
- Flashback Query
Database Maintenance
- Automatic Workload Repository
- Automatic Database Diagnostic Monitor
Database Performance
- Memory Advisors
Database Backup
- RMAN
- Open database Backup
- Closed database Backup
Database Recovery
- Open Database Recovery
- Closed Database Recovery
Moving Data
- Data Pump
- SQL*Loader
Oracle
- Duration : 40 hours
- Certificates : Yes
Quick Facts
Oracle Database 11g Administrator Certified Associate (OCA) Describing the Oracle Architecture Oracle Server SGA Datafiles Background Processes Creating an Oracle Database Database Configuration Assistance Database Templates Managing an Oracle Instance Oracle Enterprise Manager Database Storage Structures Tablespaces Datafiles Tempfiles Database Security System Accounts Application Accounts Database Roles.