Welcome to ONLC Training Centers
Welcome to ONLC Training Centers


Oracle Database 11g: Administration I Course Outline

 (5 days)
Version 11g

Overview
This Oracle 11g courseware training guide book will allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

Audience
The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.

Prerequisites
Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are these titles:
ORACLE DATABASE 11G: SQL FUNDAMENTALS COMPLETE LIBRARY
ORACLE DATABASE 11G: PROGRAM WITH PL/SQL COMPLETE LIBRARY

Suggested Next Courses
This course should be considered the first part of the integrated database administrator curriculum. Therefore, in the not-too-distant future one should proceed to the follow-up course
ORACLE DATABASE 11G: ADMINISTRATION II.

Certification
This course along with its prerequisites cover information necessary to complete the certification test EXAM #1Z1-052 ORACLE DATABASE 11G: ADMINISTRATION I.

Objectives
Major tasks to be considered within this course are:
Software installation and the creation of new databases.
An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
Management of database files.
Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.
Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
Control over database support services, including the Database Control, Oracle Net and others.
A primer on backup and recovery structures and strategies.
Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.

Course Outline

ENTERPRISE EDITION INSTALLATION IDENTIFY SYSTEM REQUIREMENTS THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA) ORACLE_BASE ORACLE_HOME CONFIGURE THE INSTALLATION ENVIRONMENT ENTERPRISE EDITION INSTALLATION DBCA

THE ADMINISTRATOR INTERFACE ENTERPRISE MANAGER TOUR USING EM SQL WORKSHEET DUTIES OF A DATABASE ADMINISTRATOR EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL

THE ORACLE ENTERPRISE ARCHITECTURE

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY WHAT IS AN ORACLE DATABASE INSTANCE? MORE ABOUT THE SYSTEM GLOBAL AREA (SGA) ABOUT THE PGA MANAGING MEMORY

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES INSTANCE BACKGROUND PROCESSES SQL EXECUTION PROCESSES

CREATING AN ORACLE DATABASE CREATE A NEW DATABASE CONFIGURE AN EXISTING DATABASE DROP A DATABASE MANAGE DBCA TEMPLATES MANUALLY CREATE A DATABASE

MANAGING THE DATABASE INSTANCE CONFIGURING A LINUX ENVIRONMENT STARTING & STOPPING DATABASE CONTROL STARTING & STOPPING THE DATABASE LISTENER STARTING & STOPPING THE DATABASE INSTANCE MORE ABOUT THE DATABASE FILES

MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES ABOUT TABLESPACES TABLESPACE MANAGEMENT DROP TABLESPACE ALTER TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES MORE ABOUT TEMPORARY TABLESPACES ABOUT TEMPORARY TABLESPACE GROUPS MORE ABOUT PERMANENT TABLESPACES MORE ABOUT BIGFILE TABLESPACES MORE ABOUT THE SYSAUX TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES DATA FILES & TEMP FILES MANAGING DATA FILES MANAGING TEMP FILES ENABLE ORACLE-MANAGED FILES (OMF)

MANAGING UNDO DATA ABOUT UNDO SPACE MANAGEMENT CONFIGURE AUTOMATIC UNDO MANAGEMENT UNDO_MANAGEMENT UNDO_TABLESPACE UNDO_RETENTION GUARANTEE UNDO RETENTION MONITOR UNDO SPACE USE THE UNDO ADVISOR

NETWORK ENVIRONMENT: ORACLE SHARED SERVERS SHARED SERVERS ARCHITECTURE CONFIGURE SHARED SERVERS MONITOR SHARED SERVERS V$SHARED_SERVER V$SHARED_SERVER_MONITOR V$SESSION V$CIRCUIT V$DISPATCHER & V$DISPATCHER_CONFIG V$QUEUE

SECURITY: IMPLEMENTING DATABASE SECURITY DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES ADMINISTRATOR AUDITING OF DATABASE ACTIVITY ENHANCED DEFAULT SECURITY SETTINGS

SECURITY: ADMINISTERING USER SECURITY CREATE & MANAGE DATABASE ACCOUNTS GRANT & REVOKE DATABASE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ABOUT ROLE-BASED SECURITY WITH ADMIN OPTION ALTER USER...DEFAULT ROLE SET ROLE ENHANCED DEFAULT SECURITY SETTINGS

MOVING DATA: SQL LOADER LOADER CONCEPTS CONTROL FILE OPTIONS LOAD METHODS USING THE EM INTERFACE

MOVING DATA: EXPORT & IMPORT MANAGE DIRECTORY OBJECTS ABOUT THE DATA PUMP ARCHITECTURE DATA PUMP EXPORT DATA PUMP IMPORT DATA PUMP DATA DICTIONARY VIEWS USING THE EM INTERFACE

DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT THE MANAGEMENT & ADVISORY FRAMEWORK MANAGE THE AUTOMATIC WORKLOAD REPOSITORY AUTOMATIC DATABASE DIAGNOSTIC MONITOR USE METRICS & ALERT THRESHOLDS AUTOMATIC MAINTENANCE TASKS

MANAGING CONCURRENCY & LOCKS ABOUT LATCHES & LOCKS MANAGE & MONITOR LATCHES MANAGE & MONITOR LOCKS V$LOCK V$LOCKED_OBJECT V$SESSION V$SESSION_WAIT DBA_BLOCKERS & DBA_WAITERS DBA_DML_LOCKS & DBA_DDL_LOCKS DML_LOCKS

BACKUP & RECOVERY CONCEPTS & CONFIGURATION ABOUT DATABASE BACKUP & RECOVERY STRUCTURES MANAGING REDO DATA MANAGING ARCHIVAL DATA AUTOMATIC CRASH RECOVERY CREATING A BASIC BACKUP STRATEGY
View outline in Word

OAD11G

Attend hands-on, instructor-led Oracle Database 11g: Administration I 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