Skip to content

Oracle DBA (Database Administration)

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate



£12 inc VAT
Study method
Course format What's this?
10 hours · Self-paced
Access to content
Lifetime access
No formal qualification
  • Certificate of completion - Free

3 students purchased this course

Add to basket or enquire


Uplatz offers comprehensive training on Oracle Database Administration (DBA). This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the course.

Databases represent the core of an organization's informational infrastructure. In this Oracle administration training course, you learn the fundamental knowledge and skills to configure and support Oracle 12c databases, maintain your company’s data, and ensure the availability of your data by deploying backup, recovery, and flashback operations.

The Oracle Database is the most commonly used type of relational database. This creates demand for Oracle DBAs. The system is based on a relational database framework wherein data objects can be directly accessed by users. The Oracle Database is commonly used by global enterprises, which manage and process data across wide and local area networks.

Oracle DBAs generally share similar duties as database administrators but also need to stay on top of Oracle updates. Companies that make use of the Oracle Database range from mid to large-sized corporations, as such Oracle DBAs generally work in small, specialized teams to maintain the company database. You’ll find Oracle DBAs in virtually any and all industries as generally, every business needs some form of database management.

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

Uplatz’s video course will help students in learning the basics to build a well-made Oracle database with the help of basic database commands. Students will get to learn how to operate the stored data and return meaningful results to analyze the data stored.

By the end of the training, you will learn how to:

  • Create, configure, and maintain Oracle 12c databases
  • Automate database administration using OEM Cloud Control 12c
  • Ensure database security by managing user privileges and roles
  • Manage storage to optimize space and performance
  • Implement Oracle partitions to manage large tables and indexes


Certificate of completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Course media


Oracle DBA - Course Syllabus

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

Who is this course for?



Passion and determination to achieve your goals!

Career path

  • Oracle Database Administrator
  • Oracle Developer
  • Data Engineer
  • Database Administrator
  • Application Developer
  • Data Architect
  • Oracle Engineer
  • Cloud Database Engineer

Questions and answers

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


Currently there are no reviews for this course. Be the first to leave a review.


Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.