IT Training Courses
Microsoft Gold IT Training Partner
Contact Us
800-326-1044

Live Help

Our Learning Consultants are standing by available to help.

Search Courses:


IT Courses Offered In:


QuickStart uses Lync for remote classes and QSLive

Microsoft Gold Partner

This site runs on .NET 4.0 and SQL Server 2008 powered by Windows Server 2008 R2 Hyper-V. Built using Visual Studio 2010.

ORA11g201 - Oracle Database 11g R2: Administration I

Course ORA11g201


Price: $2,875.00
Software Assurance Value: Not Eligible       
Duration: 5 Days




This course is currently only available on a request basis. Request this class now.





 Course Description
SQLSoft Course ora11g201: Oracle Database 11g: Administration I

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

The overall objective of this course is to allow the student to gain the skills necessary for day-today 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

Return to Top

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.

Return to Top

At Course Completion

Specific subject areas to be explored and objectives to be reached 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.

Return to Top

Prerequisites

The following courses are mandatory prerequisites for this course:

  • ora11g001, Oracle Database 11G: SQL Fundamentals � Complete Library
  • ora11g101, Oracle Database 11G: Program with PL/SQL � Complete Library

    Return to Top

    Certified Professional Exams

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

    Return to Top

    Student Materials

    The student kit includes a comprehensive workbook and other necessary materials for this class.

    Return to Top

    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

    Return to Top