Oracle DBA

indu khemchandani

Training

Online

£ 10 VAT inc.

The best Oracle courses

See all

See all

Description

  • Type

    Training

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    10h

  • Duration

    Flexible

Oracle Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of Oracle databases in organizations. The role includes installing, configuring, architecting, building and scaling databases for future data growth and capacity. Oracle DBAs are also responsible for security, performance and availability of data to users and customers. This Oracle Database Administration training by Uplatz will help you master the Oracle DBA skills and will take a deep-dive into Oracle Database architecture, the database processes, memory structures, schema objects, security, data recovery and backup through hands-on projects and case studies.

About this course

Please find the course link below:
https://training.uplatz.com/online-it-course.php?id=oracle-dba-57

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • SQL
  • Database Administration
  • Database training
  • Performance Management & Tuning
  • Monitoring
  • Database Maintenance
  • Costs & benefits of constraints
  • Bitmap and function-based Indexes
  • Schema Management

Teachers and trainers (1)

Uplatz Elite trainer

Uplatz Elite trainer

SAP ABAP consultant

Course programme

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

See related categories

Oracle DBA

£ 10 VAT inc.

The best Oracle courses

See all

See all