Oracle 12c Administration II

Price
$2,695.00 USD

Duration
4 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

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

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.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

There are no prerequisites for this course.

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
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with New Horizons