Menu

Tel: 01423 534630    Email: info@tts-uk.com

Oracle Database 18c Essential Administration

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

The Oracle Database 18c 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 18c 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 18 Administration course.

Versions supported 12cR2, 18c, 19c.

Course Objectives

The Oracle Database 18c 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 18c Essential Administration course is aimed at Database Administrators of small sized databases who need to install the Oracle Database 18c software, create, monitor and support an Oracle Database 12c database.

The Oracle Database 18c 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 18c 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 18c 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

Prerequisites

Delegates wishing to attend the Oracle Database 18c 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


  • Course content

    Day 1

    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

    Day 2

    Session 6: MANAGE AN ORACLE INSTANCE

    Oracle Instance
    Instance management
    Memory structures
    Background processes
    Database authentication methods
    Initialization parameters
    Password file
    Shut down the database
    Start up the database
    View alert log and trace files

    Session 7: DATABASE STORAGE STRUCTURES

    Oracle database structures
    Control files
    Redo log and archive redo log files
    Tablespaces and data files
    Create tablespaces
    Manage tablespaces
    Manage undo and use the Undo Advisor
    Use Enterprise Manager Express and SQL Developer to view the storage structure of the database

    Session 8: MANAGE USERS

    Database administration accounts
    User accounts
    Create and administer user accounts
    Lock and unlock user accounts
    Change a user’s password
    Administer privileges and roles

    Session 9: MANAGE SCHEMA OBJECTS

    Create schema objects
    Create a new table
    View the attributes and contents of a table
    Understand data integrity
    Define constraints
    Create indexes
    View index attributes
    Create views
    Create synonyms
    Create sequences

    Session 10: BACKUP, RECOVER AND RESTORE A DATABASE

    Oracle backup strategy
    Overview of backup, restore and recovery
    Backup and recovery configuration
    Configure ARCHIVELOG mode
    Overview of backup and recovery operations
    Overview of scheduled backups
    Configure backup settings
    Configure recovery settings
    Perform recovery

    Session 11: PERFORMANCE MONITORING

    Overview of self-monitoring architecture
    Monitor an Oracle database
    Automatic Workload Repository
    Automatic Database Diagnostics Monitor (ADDM)
    Additional monitoring
    Use the advisors

Duration: 2 days
Price: £945 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.