Oracle 12c Administration II

Price
$2,695.00
Duration
 5 Days
Delivery Methods
 VILT    Private Group

In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties.

 

Upcoming Class Dates and Times

Oct 25  - Oct 29, 2021
8:00AM - 4:00PM Central
5 Days
Virtual Instructor Led
 GTR

Course Objectives

    Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database.

Agenda

1 - INTRODUCTION: MANAGING THE DATABASE INSTANCE
  • The Database Management Tools
  • EM Database Express
  • EM Cloud Control
  • SQL Developer
  • Database Administrator
2 - INTRODUCTION: DATABASE ARCHITECTURE REVIEW
  • Database Instance Configurations
  • Memory Structures
  • Process Structures
  • Storage Architecture
3 - INTRODUCTION: STARTING & STOPPING DATABSE SERVICES
  • Start & Stop the Database Listener
  • ABOUT DATABASE STARTUP/SHUTDOWN
  • SYSOPER
  • SYSDBA
  • DATABASE STATE & STAGES
  • STARTUP WITH EM CLOUD CONTROL
  • STARTUP WITH SQL*PLUS
  • SHUTDOWN WITH EM CLOUD CONTROL
  • SHUTDOWN WITH SQL*PLUS
  • USING MS WINDOWS SERVICES
4 - INTRODUCTION: ORACLE NETWORK ENVIRONMENT
  • Oracle Net Services Architecture
  • ORACLE NET CONFIGURATION ASSISTANT
  • ORACLE NET MANAGER
  • USING EM CLOUD CONTROL
  • ADVANCED NETWORK COMPRESSION
  • TROUBLESHOOTING NETWORK PROBLEMS
5 - INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT
  • About Database Diagnostics
  • Fault Diagnosability Infrastructure
  • DATABASE INSTANCE HEALTH SNAPSHOT
  • THE SUPPORT WORKBENCH
  • PROACTIVE DATABASE HEALTH CHECKS
  • PACKAGE DIAGNOSTIC DATA
  • WORKING WITH THE KNOWLEDGE BASE
6 - STORAGE: TABLESPACE MANAGEMENT
  • Starter Tablespaces
  • CREATE TABLESPACE WITH EM CC
  • CREATE TABLESPACE WITH SQL
  • MANAGE TABLESPACES WITH EM CC
  • MANAGE TABLESPACES WITH EM DE
  • MANAGE TABLESPACES WITH SQL
  • DROP TABLESPACE
  • ALTER TABLESPACE
7 - STORAGE: ADVANCED TABLESPACE MANAGEMENT
  • Managing Temporary Tablespaces
  • TEMP TABLESPACE GROUPS WITH EM
  • TEMP TABLESPACE GROUPS WITH SQL
  • DEFAULT PERMANENT TABLESPACES
  • BIGFILE TABLESPACES
  • MANAGING THE SYSAUX TABLESPACE
8 - STORAGE: DATA FILES & TEMP FILES MANAGEMENT
  • Manage Data Files with EM
  • ACCESS METADATA WITH SQL
  • MANAGE DATA FILES WITH SQL
  • MANAGE TEMP FILES
  • ORACLE-MANAGED FILES (OMF)
9 - STORAGE: UNDO DATA & UNDO TABLESPACES
  • About UNDO Space Management
  • GUARANTEE UNDO RETENTION
  • MONITOR UNDO SPACE WITH SQL
  • USE THE EM UNDO ADVISOR
10 - SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES
  • Database Security Principles
  • DATABASE SYSTEM PRIVILEGES
  • DATABASE OBJECT PRIVILEGES
  • SUPER ADMINISTRATOR ROLES
  • PRIVILEGE ANALYSIS
11 - SECURITY & SCHEMAS: USER SECURITY
  • Create & Manage User Accounts
  • MANAGE USERS WITH EM
  • MANAGE USERS WITH SQL
  • CREATE USER
  • ALTER USER
  • DROP USER
  • GRANT & REVOKE PRIVILEGES
  • RESOURCE LIMITS VIA PROFILES
  • ALTER PROFILE
  • DROP PROFILE
  • PASSWORD MANAGEMENT VIA PROFILES
  • ROLE-BASED SECURITY MANAGEMENT
  • ALTER USER...DEFAULT ROLE
  • SET ROLE
  • DELEGATING PRIVILEGE AUTHORIZATION
  • WITH ADMIN OPTION & System Privileges
  • WITH GRANT OPTION & Object Privileges
  • PRINCIPLE OF LEAST PRIVILEGE CHECKLIST
12 - SECURITY & SCHEMAS: DATABASE AUDITING
  • Auditing Database Activity
  • Traditional Auditing
  • Unified Auditing
  • Create Audit Policy
13 - SECURITY & SCHEMAS: SQL LOADER
  • Loader Concepts
  • Loader From the Command Line
  • control File Options
  • Load Methods
  • Loader Express Mode
  • Loader From EM
14 - SECURITY & SCHEMAS: EXPORT & IMPORT
  • Manage Directory Objects
  • The Data Pump Architecture
  • Data Pump Export
  • Data Pump Import
  • Data Pump Dictionary Views
  • Using the EM CC Interface
15 - PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING
  • Management Advisory Framework
  • Performance Monitoring & AWR
  • The SQL Tuning Advisor
  • Monitoring Exceptions with Metrics
16 - PERFORMANCE & AVAILABILITY: DATA CONCURRENCY
  • About System & User Locks
  • Monitor & Manage User Locks
  • Monitor Locks with Data Dictionary
  • Manage Locks with EM
17 - PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS
  • Backup & Recovery Structures
  • Managing REDO Data
  • Configuring for Recoverability
  • Instance Recovery
  • Recoverability Checklist
 

Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with United Training