Boston Computer School

Call now to find out how:
617-230-0749

You are here:  Home » Courses » Oracle » ORACLE DBA 

ORACLE DBA

Introduction

  • Identify the oracle product
  • Describe the basic concept of a relational database

Installing oracle database 10g software

  • System requirements
  • Use Oracle Optimal Flexible Architecture (OFA)
  • Install software with the Oracle Universal Installer

Create an oracle database

  • Oracle Database Architecture
  • Oracle instance architecture
  • Use the Database Creation Assistant

Controlling the database

  • Manually configure the Oracle 10g EM dbconsole
  • Start and stop the agent
  • Start and stop the enterprise manager database console
  • Start and stop the listener
  • Startup and shutdown the database

Storage Structures

  • Defining the tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Obtain tablespace information
  • Create and manage tablespace using oracle enterprises manager

Administering users

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges

Oracle Database Security --- Only Theory

  • Apply the principal of least privilege
  • Manage default user accounts
  • Implement standard password security features

Oracle Net Services

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners
  • Use the Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity

Performance Monitoring

  • Gather optimizer statistics
  • View performance metrics

Monitoring and Managing Memory

  • Oracle Memory Structures
  • Automatic PGA Memory Management
  • Using the Memory Advisor
  • Using Automatic Shared Memory Management to avoid long running query issues

Monitoring and Resolving Lock Conflicts

  • Detect and resolve lock conflicts
  • Manage deadlocks

Diagnostic Sources

  • The Alert Log
  • Viewing Alerts with EM
  • Alerts Notification ----- Only Theory
  • Editing Thresholds ----- Only Theory
  • Trace Files

Proactive Maintenance: Objectives --- Only Theory

  • Set warning and critical alert thresholds
  • Collect and use baseline metrics
  • Use tuning and diagnostic advisors
  • Use the Automatic Database Diagnostic Monitor (ADDM)

Automatic Storage Management ---- Only Theory

  • ASM Concepts
  • ASM General Architecture
  • Creating an ASM instance
  • Creating tablespaces that use ASM storage
  • Viewing ASM information
  • Migrating a tablespace to use ASM storage.

Undo Management --- Only Theory

  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor

Backup and Recovery --- Only Theory

  • Describe the basics of database backup, restore and recovery
  • List the types of failure that may occur in an Oracle Database
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log files, and archived log file

Managing Data

  • Manipulating data through SQL
  • Using Import
  • Using Export

Database backups

  • Configure ARCHIVELOG mode
  • Create consistent database backups
  • Back your database up without shutting it down
  • Create incremental backups
  • Automate database backups
  • Monitor the flash recovery area

Managing schema objects

  • Create and modify tables
  • Define constraints
  • View the attributes of a table
  • View the contents of a table
  • Create indexes and views

Database Recovery

  • Recover from loss of a control file
  • Recover from loss of a redo log file
  • Recover from loss of a data file

Course: ORACLE DBA

BCS Fees: $1750