Overview

In this course, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Hands-on exercises reinforce the material covered.

Duration

40 hours

Objectives

• Install and configure the Oracle 12c database

• Create and administer user accounts in the Oracle 12c database

• Backup and recover the database

• Monitor, troubleshoot, and maintain the database

• Configure Oracle Net services

Intended Audience

• Database administrators

• Support engineers

• Technical consultants

• Systems administrators

• Network managers

• Technical support personnel

Prerequisites

• Knowledge of SQL

• Oracle 12c: SQL & SQL*Plus Basics Express Introduction (OR110)

• Oracle 12c: PL/SQL Introduction (OR120)

Course Outline

1. Introduction

• Describe the Basic Concepts of a Relational Database

• Discuss Core Database Administrator Tasks

2. Installing Oracle Database Software

• Identify System Requirements

• Use Optimal Flexible Architecture

• Install Software with the Oracle Universal Installer

3. Create an Oracle Database

• Describe Oracle Database Architecture

• Understand the Instance Architecture

• Use the Management Framework and the Database Creation Assistant

4. Controlling the database

• Start and Stop the Listener

• Startup and Shutdown the Database

5. Storage Structures

• Define the Purpose of Tablespaces and Data Files

• Create and Manage Tablespaces

• Obtain Tablespace Information

6. Administering Users

• Create and Manage Database User Accounts

• Manage Roles

• Grant and Revoke Privileges

• Control Resource Usage by Users

• Control Password History

7. Managing Schema Objects

• Create and Modify Tables, Indexes, and Views

• Define Constraints

• View the Attributes and the Contents of a Table

8. Managing Data

• Manipulating Data through SQL

• Use Import, Export, Data Pump, and SQL Loader

9. Oracle Database Security

• Manage Default User Accounts

• Implement Standard Password Security Features

• Audit Database Activity

10. Oracle Net Services

• Understand Oracle Net Concepts

• Use Oracle Net Manager to Create and Configure Listeners

• Configure Client and Middle-Tier Connection

• Use the Listener Control Utility to Control the Oracle Net Listener

• Secure the Listener

• Use TNSPING to Test Oracle Net Connectivity

11. Proactive Maintenance: Objectives

• Set Warning and Critical Alert Thresholds

• Collect and Use Baseline Metrics

• Use Tuning/Diagnostic Advisors/ADDM/ADR

12. Undo Management

• Monitor and Administer Undo

• Configure and Guarantee Retention

13. Recovery Manager Configuration

• Parameters Affecting RMAN

• Use of a Flashback Recovery Area

• The CONFIGURE Command

• Persistent Settings

• NOCATALOG / CATALOG Mode

• Channel Allocation

• Controlfile Autobackup

• Retention Policies

14. Recovery Manager Operations

• Using the BACKUP Command

• Creating Backup Sets / Image Copies

• Compressed Backups

• Incremental Backups

• Block Change Tracking

• RMAN Backup Monitoring

• REPORT and LIST Commands

15. Non-Critical Loss Recovery

• Password and Network Files

• Read-Only Tablespaces

• Temporary Tablespaces

• Index Tablespaces

• Redo Log Members / Control Files

16. Database Recovery

• Complete Recovery

• Incomplete Recovery

17. Flashback Database

• Configuration

• Monitoring Flashback Database

18. User Error Recovery

• Flashback Table

• Flashback Versions Query

• Flashback Transaction Query

19. Automatic Database Management

• Management and Advisory Framework

• Automatic Statistics Collection

• The Automated Workload Repository

• Database Advisors

• Automatic Statistics Collection

20. Scheduler

• Creating Jobs and Job Classes

• Creating Schedules and Windows

• Create Scheduler Programs

• Prioritizing Jobs

• Query Scheduler Information

• Working with Calendaring tools

Labs

Lab 1: Architecture / Advanced Memory Mgt.

Lab 2: Starting and Stopping the Database

Lab 3: Using the Database Console (EM)

Lab 4: Managing Tablespaces / Datafiles

Lab 5: Oracle Database Files

Lab 6: Tables, Indexes, and Constraints

Lab 7: Creating Other Database Objects

Lab 8: Users and Security

Lab 9: Import, Export, Data Pump, and SQLDR

Lab 10 Performance Metrics and Monitoring

Lab 11: Archivelog Setup

Lab 12: Automation Tools

Lab 13: Recovery Manager Configuration

Lab 14: Recovery Manager Backups

Lab 15: Flashback Database

Lab 16: Flashback for User Errors

Lab 17: Automated Management Tools

Lab 18: Using the Scheduler

Lab 19: Diagnostic Sources