Oracle DBA Certification Training

50 Hours
LIVE 1:1 TRAINING
USD 336 Oracle DBA Certification Training

  • LIFETIME ACCESS TO RECORDINGS OF SESSIONS
  • UPLATZ TRAINING HUB ACCESS
  • REAL-TIME PROJECTS & ASSIGNMENTS
  • RESUME & INTERVIEW PREPARATION SERVICES
  • CERTIFICATE & BADGE OF COURSE COMPLETION

Oracle DBA Certification Training

Course Details & Curriculum
Complete course on Oracle Database Administration (DBA).

1. Architecture

 
2. Instances
 
• Creating the OFA file structure ($DBA, bdump, udump, pfile)
 
 
3. SQL*Plus
• Connectivity
• SQL*Plus DBA commands
 
4. Control Files
 
 
5. User and Security Management
 
 
 
6. Parameter Files
• Parameter files (tnsnames.ora, init.ora, listener.ora)
• Rules for sizing SGA components
• Automated Oracle memory management (AMM)
 
7. Tablespace & Schema Management
 

8. Oracle*Net configuration
 
 
9. Data Buffer configuration & sizing
 

10. Shared pool and PGA configuration & Sizing
 
 
11. Oracle tables, views and materialized views
 
 
12. Indexes
• Types of Oracle indexes (b-tree, bitmap, bitmap join index)
• Creating B*-Tree, bitmap and function-based Indexes
 
 
13. Constraints
• Costs & benefits of constraints
• Types of Oracle indexes constraints (check, not null, unique, PK, FK)
• Cascading constraints
 
 
14. Database Maintenance
 
 
15. 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)
 
16. Monitoring
 
 
17. STATSPACK and AWR performance management
 
 
18. Performance Management & Tuning
 
19. Tracing
 
 
 
 
 
20. Oracle High Availability tools
 
 
21. Backup & Recovery
 
 

Location
Live 1:1 Virtual Class
Course Level
Expert
Live Meeting Tool
Availability
Monday Tuesday Wednesday Thursday Friday Saturday Sunday

Available Time Slots
Time Slot 1 --> 00:00 - 23:30


Time Zone : Europe/London

Tags
London UK Online Course Online Training Oracle Oracle DBA

THIS COURSE IS SPREAD OVER
1 MONTH

30-MINS FREE DEMO SESSION AVAILABLE

Copyright Ⓒ 2017 All rights reserved