Oracle Database 19c Essential Administration (O19CEA) course. Live Virtuel direct training or on-site. In English

Oracle Database 19c Essential Administration Course Overview

The Oracle Database 19c Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 19c database.

The Oracle Database 19c Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The Oracle Database 19c Essential Administration course is not aimed at delegates who are full time Database Administrators. The focus is on using Enterprise Manager Express and SQL Developer to teach delegates how to manage the database. The usage of SQL*Plus is also covered.

Full time Database Administrators should attend the Oracle Database 19c Administration course.

Versions supported 12cR2, 18c, 19c.

Course Objectives

The Oracle Database 19c Essential Administration course is designed to provide the knowledge and skills needed to successfully manage an Oracle database.

Who will the Course Benefit?

The Oracle Database 19c Essential Administration course is aimed at Database Administrators of small sized databases who need to install the Oracle Database 19c software, create, monitor and support an Oracle Database 12c database.

The Oracle Database 19c Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 19c software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Skills Gained

The delegate will learn and acquire skills as follows:

• Installing Oracle Database 19c Software
• Creating an Oracle database
• Administering an Oracle database with Enterprise Manager Express, SQL Developer and SQL*Plus
• Configuring the Oracle Network Environment
• Creating and Managing Database Storage Structures
• Managing Schema Objects
• Managing Users
• Maintaining Database Security
• Backing up, Restoring and Recovering the Database
• Monitoring the Performance of the Database Using Advisors

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: INTRODUCTION

• Oracle product overview
• Oracle Support services
• Relational database concepts
• Oracle architecture
• Oracle Multitenant architecture
• Overview of the Oracle Cloud
• Database administration tasks
• Database administration responsibilities

Session 2: INSTALL THE ORACLE DATABASE SOFTWARE WITH THE OIU

• Installation planning
• Understand system requirements and operating system pre-requisites
• Oracle flexible architecture
• Environment variables
• Use Oracle Universal Installer to install Oracle software (OUI)
• The Oracle Inventory
• De-install Oracle Database softare

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

• Select a storage method
• Select a CDB or non-CDB database
• Select a database type based on workload
• Select a character set for the database
• Create a database using the DBCA

Session 4: ADMINISTER A DATABASE

• Administrative tools available to a DBA
• Use SQL*Plus and SQL Developer to manage a database
• Administer the database using Enterprise Manager Express
• An overview of Enterprise Manager Cloud Control

Session 5: 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
• Configure local naming for client connections with Net Manager
• Start and stop the Oracle listener
• Configure the listener with EM
• Use TNSPING to test Oracle Net connectivity
• Connect to the database

Requirements

Delegates wishing to attend the Oracle Database 19c Essential Administration course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.

This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.

Pre-Requisite Courses

• Oracle SQL