Oracle DBA - COURSE DETAILS
Complete course on Oracle Database Administration (DBA).
- Architecture
- Instances
- Creating the OFA file structure ($DBA, bdump, udump, pfile)
- SQL*Plus
- Connectivity
- SQL*Plus DBA commands
- Control Files
- User and Security Management
- Parameter Files
- Parameter files (tnsnames.ora, init.ora, listener.ora)
- Rules for sizing SGA components
- Automated Oracle memory management (AMM)
- Tablespace & Schema Management
- Oracle*Net configuration
- Data Buffer configuration & sizing
- Shared pool and PGA configuration & Sizing
- Oracle tables, views and materialized views
- Indexes
- Types of Oracle indexes (b-tree, bitmap, bitmap join index)
- Creating B*-Tree, bitmap and function-based Indexes
- Constraints
- Costs & benefits of constraints
- Types of Oracle indexes constraints (check, not null, unique, PK, FK)
- Cascading constraints
- Database Maintenance
- Oracle DBA Utilities
- Data pump (Imp and exp utilities)
- SQL*Loader
- LogMiner
- Flashback
- DataGuard
- Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
- Replication (Streams, multimaster, materialized views)
- Monitoring
- STATSPACK and AWR performance management
- Performance Management & Tuning
- Tracing
- Oracle High Availability tools
- Backup & Recovery