Menu

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

Oracle Database 18c Administration

This Oracle Database 18c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.

A database administrator will gain an understanding of the architecture and processes of the Oracle database server. The delegate will learn how to ensure the integrity and availability of a company’s data within the Oracle environment. The delegate will also learn how to monitor the performance of a database, allocate resources with the Resource Manager and schedule jobs with the Oracle Job scheduler.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Versions supported 12cR2, 18c, 19c.

Course Objectives

This course aims to provide the delegate with the knowledge required to maintain successful and efficient day-to-day operations of an Oracle database. The delegate will gain practical experience in administering and monitoring an Oracle database.

Who will the Course Benefit?

This Oracle Database 18c Administration course is for anyone who needs to administer, monitor and support an Oracle database.

Skills Gained

The delegate will learn and acquire skills as follows:

Administering an Oracle Database Instance
Monitoring an Oracle Database
Configuring the Oracle Network Environment
Creating and Managing Database Storage Structures
Managing Users, Profiles, Privileges and Roles
Managing Undo Data and Temporary Segments
Monitoring and Resolving Lock Conflicts
Maintaining Database Security
Implementing Database Auditing
Monitoring the Performance of the Database
Loading and Unloading Data
Using the Job Scheduler
Configuring a Database for Backup and Recovery

Requirements

Delegates who wish to attend the Oracle Database 18c Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. The ability to describe and use Oracle built-in PL/SQL packages would be highly advantageous but is not essential.

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

Pre-Requisite Courses

Oracle SQL

Examinations

This course will aid the delegate in their preparation for the following exam:

Oracle Database Administration I: 1Z0-082

Attending this course together with the Oracle SQL Fundamentals course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.


  • Course content

    Course Introduction

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

    Session 1: INTRODUCTION TO ORACLE DATABASE

    Overview of the Oracle database
    Overview of the Oracle Cloud
    Relational database concepts
    Database administration tasks

    Session 2: ORACLE DATABASE 18c ARCHITECTURE

    Overview of the Oracle database architecture
    The Oracle database instance
    Oracle Database memory structures
    Process architecture and structures
    Server and client processes
    The Oracle database storage architecture
    Connect to the Oracle database instance

    Session 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
    The Enterprise Manager Database Express Home Page
    Enterprise Manager Cloud Control
    Initialization parameter files

    Session 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

    Session 5: STORAGE STRUCTURES

    Overview of data storage
    The database block
    Overview of tablespaces and datafiles
    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

    Session 6: MANAGE USERS

    Predefined database administration accounts
    User accounts
    Create a user account
    User authentication
    Change a user’s password
    Manage a user account
    Drop a user account
    Monitor user information
    Terminate user sessions
    Create a Schema Only Account

    Session 7: MANAGE PRIVILEGES

    Database access
    Oracle supplied roles
    System and object level privileges
    The grant and revoke commands
    Create, modify and drop roles
    Use predefined roles

    Session 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

    Session 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

    Session 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

    Session 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

    Session 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

    Session 13: PROACTIVE DATABASE MAINTENANCE

    Database Maintenance
    View the alert log
    The Automatic Workload Repository
    Statistic levels
    The Automatic Database Diagnostic Monitoring
    Monitor an Oracle database
    Use the Advisors
    Set up notification rules

    Session 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

    Session 15: SQL TUNING

    SQL tuning
    Cancel a SQL Statement in a Session
    The Oracle Optimizer
    SQL Plan directives
    Adaptive execution plans
    SQL Advisors
    Automatic SQL Tuning results
    Implement automatic tuning recommendations
    SQL Tuning Advisor

    Session 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 data
    Use Data Pump to import data
    Overview of SQL Loader
    Command line parameters
    Record filtering
    Control file keywords
    Datafiles
    SQL Loader data paths
    External Tables

    Session 17: MANAGING RESOURCES WITH RESOURCE MANAGER

    Overview of the Database Resource Manager
    Use the Resource Manager
    Create Resource Plans
    The default maintenance resource manager plan
    Create Resource Plan Directives
    Allocate resources for Resource Plans

    Session 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

    Session 19: MANAGE SPACE

    Overview of space management
    Block space management within segments
    Segment types
    Allocate extents
    Allocate space
    Row chaining and migration
    Create tables without segments

    Session 20: ORACLE SUPPORT

    The Enterprise Manager Support Workbench
    Register for security updates
    Work with Oracle Support
    My Oracle Support integration
    Log Service Requests
    Manage patches
    Apply a patch

Duration: 5 days
Price: £2150 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.