Welcome to ONLC Training Centers
Welcome to ONLC Training Centers


Oracle Database 12c: Administration Workshop Course Outline

 (5 days)
Version 12c

Overview
The overall objective of this class is threefold. First, this course instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like.

Whenever appropriate this course demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.

Target Audience
The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
 Database administrators
 Application designers and developers
 Web server administrators
 System administrators
 Implementation specialists
 Data center support engineers
 Chief Information Officers (CIO) and other information technology (IT) 2management professionals

Prerequisites
These are mandatory prerequisite courses (or equivalent knowledge) for this course:
 Oracle Database 12c: SQL Fundamentals
 Oracle Database 12c: Install & Upgrade Workshop
 Oracle Database 12c: Architecture & Internals

Certification
This course considers subjects applicable to certification as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".
Oracle Database 12c: Administration Workshop

Duration
5 days

Contents

INTRODUCTION: MANAGING THE DATABASE INSTANCE
 THE DATABASE MANAGEMENT TOOLS
 EM DATABASE EXPRESS
 EM CLOUD CONTROL
 SQL DEVELOPER
 DATABASE ADMINISTRATION DUTIES

INTRODUCTION: DATABASE ARCHITECTURE REVIEW
 DATABASE INSTANCE CONFIGURATIONS
 MEMORY STRUCTURES
 PROCESS STRUCTURES
 STORAGE ARCHITECTURE

INTRODUCTION: STARTING & STOPPING DATABASE
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

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

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

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

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

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)

STORAGE: UNDO DATA & UNDO TABLESPACES
 ABOUT UNDO SPACE MANAGEMENT
 CONFIGURE UNDO MANAGEMENT
 GUARANTEE UNDO RETENTION
 MONITOR UNDO SPACE WITH SQL
 USE THE EM UNDO ADVISOR

SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES
 DATABASE SECURITY PRINCIPLES
 DATABASE SYSTEM PRIVILEGES
 DATABASE OBJECT PRIVILEGES
 SUPER ADMINISTRATOR ROLES
 PRIVILEGE ANALYSIS

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

SECURITY & SCHEMAS: DATABASE AUDITING
 AUDITING DATABASE ACTIVITY
 TRADITIONAL AUDITING
 UNIFIED AUDITING
 CREATE AUDIT POLICY

SECURITY & SCHEMAS: SQL LOADER
 LOADER CONCEPTS
 LOADER FROM THE COMMAND LINE
 CONTROL FILE OPTIONS
 LOAD METHODS
 LOADER EXPRESS MODE
 LOADER FROM EM

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

PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING
 MANAGEMENT ADVISORY FRAMEWORK
 PERFORMANCE MONITORING & AWR
 THE SQL TUNING ADVISOR
 MONITORING EXCEPTIONS WITH METRICS

PERFORMANCE & AVAILABILITY: DATA CONCURRENCY
 ABOUT SYSTEM & USER LOCKS
 MONITOR & MANAGE USER LOCKS
 MONITOR LOCKS WITH DATA DICTIONARY
 MANAGE LOCKS WITH EM

PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS
 BACKUP & RECOVERY STRUCTURES
 MANAGING REDO DATA
 CONFIGURING FOR RECOVERABILITY
 INSTANCE RECOVERY
 RECOVERABILITY CHECKLIST

2014 Sideris Courseware Corporation

View outline in Word

OAD12C

Attend hands-on, instructor-led Oracle Database 12c: Administration Workshop training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Oracle Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $2995

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com