reed.co.uk Courses

Header

Oracle DBA Certification online tutor-led training course

Free server access, Class recordings, Certification guidance, Job & Interview assistance, Course Completion Certificate


Uplatz

Summary

Price
Save 47%
£800 inc VAT (was £1,500)
Offer ends 31 December 2019
Study method
Online with live classes
Duration
40 Hours, Part-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

Add to basket or enquire

Overview

Uplatz offers comprehensive training on Oracle Database Administration (DBA). This is instructor-led online course.

Oracle Database Administration (DBA) Training

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

Resources

  • Course Syllabus - Oracle DBA - download

Description

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

Requirements

None

Career path

Oracle DBA

Questions and answers

Currently there are no Q&As for this course.Be the first to ask a question.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals