The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - Available 24/7

Send us your message.

X

Oracle Database 19c Administration Training - Australia

Key points about this course


Duration: 5 Days*

Support: 24/7

Dates & Prices Enquire
  • Acquire in-depth knowledge of how to administer Oracle Database instances.
  • Learn how to create and manage database storage structures.
  • Get an understanding of how to configure a database for backup and recovery.

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

In-house

Course Information

Oracle Database 19c Administration Training​ Course Overview

Oracle Database 19c is a multi-model database providing complete support to relational as well as non-relational data, for e.g. XML, JSON, text, and graph data. Along with this, Oracle Database enables SQL access to non-relational data using SQL extensions or native APIs.

This course is designed to provide the knowledge of how to administer, monitor, tune, and troubleshoot an Oracle database. Delegates will get familiarised with the architecture and processes of the Oracle database server. They will learn how to ensure the company’s data integrity and availability within the Oracle environment. This course explains how to monitor the database performance, resource allocation with the resource manager and schedule jobs with the Oracle Job Scheduler.

This course describes how to configure the Oracle Network Environment as well as create and manage database storage structures. In this course, delegates will learn how to manage users, profiles, privileges and roles. They will also gain an understanding of how to manage temporary segments. This course teaches delegates how to monitor and resolve lock conflicts. Delegates will learn how to load and unload data. They will also acquire knowledge of how to use the job scheduler and configure a database for backup and recovery.

Oracle Database 19c Administration Training Course Outline

Module 1: Introduction to Oracle Database

  • Overview of the Oracle Database
  • Overview of the Oracle Cloud
  • Relational Database Concepts
  • Database Administration Tasks

Module 2: Oracle Database Architecture

  • Overview of the Oracle Database Architecture
  • The Oracle Database Instance
  • Oracle Database Memory Structures
  • Process Architecture and Structures
  • Server and Client Processes
  • Oracle Database Storage Architecture
  • Connect to the Oracle Database Instance

Module 3: Administer a Database Instance

  • Administrative Tools Available to a DBA
  • Use SQL*Plus in Oracle to Manage a Database Instance
  • Use SQL Developer to Manage a Database Instance
  • Administer the Database using Enterprise Manager (EM)
  • Overview of the Enterprise Manager Framework
  • Access Enterprise Manager Database Express
  • Enterprise Manager Database Express Home Page
  • Enterprise Manager Cloud Control
  • Initialisation Parameter Files

Module 4: Configure the Oracle Network Environment

  • Overview of Network Configuration
  • Oracle Net Listener Configuration and Management
  • Oracle Net Naming Methods
  • Tools for Configuring and Managing the Oracle Network
  • Using the Net Configuration Assistant
  • Configure Client Connections with Net Manager
  • View Listener Configuration
  • Start and Stop the Oracle Listener
  • Use TNSPING to Test Oracle Net Connectivity
  • Connect to the Database
  • Configure Net Services with Enterprise Manager

Module 5: Storage Structures

  • Overview of Data Storage
  • The Database Block
  • Overview of Tablespaces and Data Files
  • Use Enterprise Manager to View the Storage Structure of the Database
  • Create and Alter Tablespace Commands
  • Temporary Tablespaces
  • Create and Manage Datafiles
  • Use OMF
  • Drop Tablespaces and Datafiles

Module 6: Manage Users

  • Predefined Database Administration Accounts
  • User Accounts
  • Create a User Account
  • User Authentication
  • Change a User's Password
  • Manage and Drop a User Account
  • Monitor User Information
  • Terminate User Sessions
  • Create a Schema Only Account

Module 7: Manage Privileges

  • Database Access
  • Oracle Supplied Roles
  • System and Object Level Privileges
  • Grant and Revoke Commands
  • Create, Modify and Drop Roles
  • Use Predefined Roles

Module 8: Manage Profiles and Resources

  • Overview of User Profiles
  • Profile Resource Parameters
  • Create Profile Command
  • Manage Passwords with Profiles
  • Control Resource Usage with Profiles
  • Maintain Profiles

Module 9: Database Auditing

  • Overview of Database Security
  • Overview of Database Auditing
  • Security Compliance
  • Standard Auditing
  • Unified Audit Trail
  • Separation of Audit Responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Audit Trail
  • Specify Audit Options

Module 10: Data Concurrency and Lock Conflicts

  • Levels of Locking in Oracle
  • Methods used to acquire Locks
  • Data Concurrency
  • Possible causes of Contention
  • DML Locks
  • Prevent Locking Problems
  • Detect Lock Contention
  • Resolve Conflicts

Module 11: Undo Management

  • Undo Data Overview
  • Monitor and Administer Undo
  • Configure Undo Retention
  • Switch Undo Tablespaces
  • Specify the Retention Period
  • Guarantee Undo Retention
  • Retention Period for Flashback Queries
  • View Undo Space Information
  • Use the Undo Advisor
  • Size the Undo Tablespace
  • Alter an Undo Tablespace to a Fixed Size

Module 12: Backup and Recovery Configuration

  • Oracle Backup Solutions
  • Oracle Suggested Backup Strategy
  • Overview of Database Backup, Restore and Recover
  • Flashback Technology
  • Types of Failure
  • Instance Recovery
  • Tune Instance Recovery
  • The MTTR Advisor
  • Media Failure
  • Configure a Database for Recoverability

Module 13: Proactive Database Maintenance

  • Database Maintenance
  • View the Alert Log
  • Automatic Workload Repository
  • Statistic Levels
  • Automatic Database Diagnostic Monitoring
  • Monitor an Oracle Database
  • Use the Advisors
  • Set Up Notification Rules

Module 14: Performance Management

  • Tuning Information Sources
  • Performance Monitoring
  • Tuning Activities
  • Performance Planning
  • Instance Tuning
  • Performance Tuning Methodology
  • Performance Tuning Data
  • Monitoring Performance
  • Managing Memory
  • Manage Private Temporary Tables

Module 15: SQL Tuning

  • SQL Tuning
  • Cancel a SQL Statement in a Session
  • The Oracle Optimiser
  • SQL Plan Directives
  • Adaptive Execution Plans
  • SQL Advisors
  • Automatic SQL Tuning Results
  • Implement Automatic Tuning Recommendations
  • SQL Tuning Advisor

Module 16: Moving Data

  • Create Directory Objects
  • Data Pump Architecture
  • Data Pump Data Dictionary Views
  • Data Pump Interactive Mode
  • Data Pump API
  • Use Data Pump to Export and Import Data
  • Overview of SQL Loader
  • Command Line Parameters
  • Record Filtering
  • Control File Keywords
  • Data Files
  • SQL Loader Data Paths
  • External Tables

Module 17: Managing Resources with Resource Manager

  • Overview of the Database Resource Manager
  • Use the Resource Manager
  • Create Resource Plans
  • Default Maintenance Resource Manager Plan
  • Create Resource Plan Directives
  • Allocate Resources for Resource Plans

Module 18: Automate Tasks with the Scheduler

  • Introduction to the Scheduler
  • Access Rights
  • Scheduler Components and Workflow
  • Create a Job
  • Job Classes
  • Use Time Based, Event-Based Schedules
  • Create an Event-Based Schedule

Module 19: Manage Space

  • Overview of Space Management
  • Block Space Management within Segments
  • Segment Types
  • Allocate Extents and Space
  • Row Chaining and Migration
  • Create Tables without Segments

Module 20: Oracle Support

  • Enterprise Manager Support Workbench
  • Register for Security Updates
  • Work with Oracle Support
  • My Oracle Support Integration
  • Log Service Requests
  • Manage Patches
  • Apply a Patch

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals who want to learn about databases and Oracle Technologies.

Please arrive at the venue at 8:45am.
There are no prerequisites for this course.
This course is for IT Professionals who want to learn about databases and Oracle Technologies.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 5 days.
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The price for Oracle Database 19c Administration Training certification in Australia starts from $7079
The Knowledge Academy is the Leading global training provider in the world for Oracle Database 19c Administration Training.
Please see our Oracle Training courses available in Australia
  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Key points about this course


Duration: 5 Days*

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
+61 1-800-150644

Oracle Database 19c Administration Training Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
Mon 9th Mar 2020
Places available
$7995
Perth
Mon 16th Mar 2020
Places available
$9495
Adelaide
Mon 16th Mar 2020
Places available
$9495
Melbourne
Mon 16th Mar 2020
Places available
$9095
Canberra
Mon 16th Mar 2020
Places available
$9095
Sydney
Mon 16th Mar 2020
Places available
$9095
Brisbane
Mon 16th Mar 2020
Places available
$9495
Mon 27th Apr 2020
Places available
$7995
Melbourne
Mon 18th May 2020
Places available
$9095
Canberra
Mon 18th May 2020
Places available
$9095
Sydney
Mon 18th May 2020
Places available
$9095
Brisbane
Mon 18th May 2020
Places available
$9495
Perth
Mon 18th May 2020
Places available
$9495
Adelaide
Mon 18th May 2020
Places available
$9495
Mon 25th May 2020
Places available
$7995
Mon 15th Jun 2020
Places available
$7995
Canberra
Mon 20th Jul 2020
Places available
$9095
Sydney
Mon 20th Jul 2020
Places available
$9095
Brisbane
Mon 20th Jul 2020
Places available
$9495
Perth
Mon 20th Jul 2020
Places available
$9495
Adelaide
Mon 20th Jul 2020
Places available
$9495
Mon 20th Jul 2020
Places available
$7995
Melbourne
Mon 20th Jul 2020
Places available
$9095
Mon 17th Aug 2020
Places available
$7995
Mon 7th Sep 2020
Places available
$7995
Sydney
Mon 21st Sep 2020
Places available
$9095
Brisbane
Mon 21st Sep 2020
Places available
$9495
Perth
Mon 21st Sep 2020
Places available
$9495
Adelaide
Mon 21st Sep 2020
Places available
$9495
Melbourne
Mon 21st Sep 2020
Places available
$9095
Canberra
Mon 21st Sep 2020
Places available
$9095
Mon 19th Oct 2020
Places available
$7995
Mon 9th Nov 2020
Places available
$7995
Perth
Mon 16th Nov 2020
Places available
$9495
Adelaide
Mon 16th Nov 2020
Places available
$9495
Melbourne
Mon 16th Nov 2020
Places available
$9095
Canberra
Mon 16th Nov 2020
Places available
$9095
Sydney
Mon 16th Nov 2020
Places available
$9095
Brisbane
Mon 16th Nov 2020
Places available
$9495
Mon 14th Dec 2020
Places available
$7995

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 5 Days*

Support: 24/7


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

hsbc-logo
mercedes-logo