Oracle Database: Administration Workshop | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle Database: Administration Workshop

Oracle Oracle Database Oracle Database 19c

Location

Format What’s this?

Ways to train

Classroom
Live, instructor-led training in a standard, professional classroom environment

Virtual
Live, instructor-led training conducted over the internet, with hands-on labs

Online
An online, HTML5, self-paced learning experience available for all courses

On-site
Private training for your entire team, delivered at your location, a training center, or online

Video classroom
High-definition video of our most popular courses, streamed to your laptop or personal device

Learn more about our training formats
Starting From
RM 5900.00
  1. 5 Day with 08 hours per day
  1. Mon 05 Sep 09:00 - Fri 09 Sep 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
Get started
  1. 5 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

Already purchased this offering? Log in

Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Oracle Database: Administration Workshop

WHAT YOU WILL LEARN

The Oracle Database: Administration Workshop course provides you with a firm foundation in administration of an Oracle database. In this course, you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner.


Learn To:
• Manage an Oracle Database instance.
• Configure the Oracle Network environment.
• Create and manage storage structures.
• Manage and move data.
• Create and manage users.
• Monitor the database and manage performance.
• Create and manage Database Cloud Service database deployments.

Benefits To You
You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

AUDIENCE

• Data Warehouse Administrator

• Database Administrator

• Database Designer

• Support Engineer

• Technical Administrator


PREREQUISITES

• Oracle Database 12c: Introduction to SQL

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

COURSE OBJECTIVES

Upon completion of this course, the student should be able to:

• Describe Oracle Database architecture

• Describe Oracle Database Cloud Service (DBCS) architecture and features

• Create and manage DBCS database deployments

• Configure the database to support your applications

• Manage database security and implement auditing

• Implement basic backup and recovery procedures

• Move data between databases and files

• Employ basic monitoring procedures and manage performance


Expand All

Modules

Outlines

• Module 1: Introduction

• Module 2: Oracle Database Architecture
• Module 3: Introduction to Oracle Database Cloud Service
• Module 4: Creating DBCS Database Deployments
• Module 5: Accessing an Oracle Database
• Module 6: Managing DBCS Database Deployments
• Module 7: Managing Database Instances
• Module 8: Understanding Oracle Net Services
• Module 9: Administering User Security
• Module 10: Creating PDBs
• Module 11: Creating Master Encryption Keys for PDBs
• Module 12: Creating and Managing Tablespaces
• Module 13: Managing Storage Space
• Module 14: Managing Undo Data
• Module 15: Moving Data
• Module 16: Backup and Recovery Concepts
• Module 17: Backup and Recovery Configuration
• Module 18: Creating Database Backups
• Module 19: Performing Database Recovery
• Module 20: Monitoring and Tuning Database Performance
• Module 21: SQL Tuning

Oracle Certified Trainer

Oracle Certified Trainer

Read More

Genesis Douglas Row

Genesis Douglas Row

Mr. Genesis Douglas Row has been working in the IT industry since 1996 and has contributed more than 17 years to the industry. Along the years, he has picked up skills in sales, marketing, business management, presales and product management that has made him an all-rounded skilled and experienced IT personnel in the industry.He has a strong technical background in Oracle Database Management, Solaris System Administration and Web Publishing. He has also proven to be a very talented and passionate trainer in delivering easy-to-understand, straight-to-the-point training sessions. He utilizes effective training techniques for maximum knowledge transfer, information retention and customer satisfaction. Read More

Course Reviews

No Remarks

0

0 Ratings