Skip to content
Play overlay
Preview this course

Oracle DBA Certification Training

Self-paced videos. Course Completion Certificate. Deep-dive in all topics. Become a DBA (Oracle Database Administrator)


Uplatz

Summary

Price
Save 90%
£10 inc VAT (was £100)
Offer ends 31 January 2022
Study method
Online, On Demand What's this?
Duration
4.9 hours
Qualification
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

27 students purchased this course

Add to basket or enquire

Overview

Uplatz offers comprehensive training on Oracle Database Administration (DBA). This is video-based online course (self-paced training).

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

Curriculum

1
section
15
lectures
4h 55m
total
    • 1: Architecture Preview 33:49
    • 2: DBCA and Instance 38:13
    • 3: Users 22:00
    • 4: Managing Database Storage Structure 23:02
    • 5: Undo 08:59
    • 6: Flashback Technology 17:37
    • 7: Oracle Networking Environment 16:40
    • 8: Oracle Locking 25:23
    • 9: Oracle Auditing 09:48
    • 10: EM and Data Pump 15:46
    • 11: Backup and Recovery 13:49
    • 12: User Managed Database Backup 14:22
    • 13: User Managed Database Recovery 11:09
    • 14: RMAN Backup and Recovery 29:34
    • 15: Oracle Database Migration to Cloud 14:33

Course media

Description

Oracle DBA Course Curriculum

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?

Everyone

Requirements

Passion and determination to achieve your goals!

Career path

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

Questions and answers


No questions or answers found containing ''.


Matthew Lewis asked:

Can I do this online course by working from home?

Answer:

Hi Matthew Yes ofcourse. These are videos that can be played from anywhere, anytime, and on any device. Team Uplatz

This was helpful. Thank you for your feedback.

tinki asked:

hi, i learn oracle 11g 2 years ago. can i eligible for this course.

Answer:

Yes . You can enroll for this course.

This was helpful. Thank you for your feedback.

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value

FAQs

What does study method mean?

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.

What are CPD hours/points?

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.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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.