Course Description

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.

Audience Profile

• Database administrators
• Support engineers
• Technical consultants
• Systems administrators
• Network managers
• Technical support personnel

Prerequisites

• Knowledge of SQL
• Oracle 12c SQL & SQLPLUS Express Introduction
• Oracle 12c PL/SQL Introduction

Learning 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

Course Outline

Module 1: Introduction
Lessons
• Describe the Basic Concepts of a Relational Database
• Discuss Core Database Administrator Tasks

Module 2: Installing Oracle Database Software
Lessons
• Identify System Requirements
• Use Optimal Flexible Architecture
• Install Software with the Oracle Universal Installer

Module 3: Create an Oracle Database
Lessons
• Describe Oracle Database Architecture
• Understand the Instance Architecture
• Use the Management Framework and the Database Creation Assistant
Lab: Architecture / Advanced Memory Mgt.

Module 4: Controlling the Database
Lessons
• Start and Stop the Listener
• Startup and Shutdown the Database
Lab: Starting and Stopping the Database
Lab: Using the Database Console (EM)

Module 5: Storage Structures
Lessons
• Define the Purpose of Tablespaces and Data Files
• Create and Manage Tablespaces
• Obtain Tablespace Information
Lab: Managing Tablespaces / Datafiles
Lab: Oracle Database Files
Lab: Tables, Indexes, and Constraints

Module 6: Administering Users
Lessons
• Create and Manage Database User Accounts
• Manage Roles
• Grant and Revoke Privileges
• Control Resource Usage by Users
• Control Password History
Lab: Creating Other Database Objects
Lab: Users and Security

Module 7: Managing Schema Objects
Lessons
• Create and Modify Tables, Indexes, and Views
• Define Constraints
• View the Attributes and the Contents of a Table

Module 8: Managing Data
Lessons
• Manipulating Data through SQL
• Use Import, Export, Data Pump, and SQL Loader
Lab: Import, Export, Data Pump, and SQLDR

Module 9: Oracle Database Security
Lessons
• Manage Default User Accounts
• Implement Standard Password Security Features
• Audit Database Activity
Lab: Performance Metrics and Monitoring

Module 10: Oracle Net Services
Lessons
• 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
Lab: Archivelog Setup

Module 11: Proactive Maintenance: Objectives
Lessons
• Set Warning and Critical Alert Thresholds
• Collect and Use Baseline Metrics
• Use Tuning/Diagnostic Advisors/ADDM/ADR
Lab: Automation Tools

Module 12: Undo Management
Lessons
• Monitor and Administer Undo
• Configure and Guarantee Retention

Module 13: Recovery Manager Configuration
Lessons
• Parameters Affecting RMAN
• Use of a Flashback Recovery Area
• The CONFIGURE Command
• Persistent Settings
• NOCATALOG / CATALOG Mode
• Channel Allocation
• Controlfile Autobackup
• Retention Policies
Lab: Recovery Manager Configuration

Module 14: Recovery Manager Operations
Lessons
• Using the BACKUP Command
• Creating Backup Sets / Image Copies
• Compressed Backups
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands
Lab: Recovery Manager Backups

Module 15: Non-Critical Loss Recovery
Lessons
• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files

Module 16: Database Recovery
Lessons
• Complete Recovery
• Incomplete Recovery

Module 17: Flashback Database
Lessons
• Configuration
• Monitoring Flashback Database
Lab: Flashback Database

Module 18: User Error Recovery
Lessons
• Flashback Table
• Flashback Versions Query
• Flashback Transaction Query
Lab: Flashback for User Errors

Module 19: Automatic Database Management
Lessons
• Management and Advisory Framework
• Automatic Statistics Collection
• The Automated Workload Repository
• Database Advisors
• Automatic Statistics Collection
Lab: Automated Management Tools

Module 20: Scheduler
Lessons
• Creating Jobs and Job Classes
• Creating Schedules and Windows
• Create Scheduler Programs
• Prioritizing Jobs
• Query Scheduler Information
• Working with Calendaring tools
Lab: Using the Scheduler
Lab: Diagnostic Sources