THE POSSIBILITIES ARE INFINITE

  1. Training > Course Details

Name: Oracle Database 10g: Administration Workshop I
Course Code: OR17090
Duration: 5

Scheduled Dates for OR17090

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam. You will learn: Install the Database; Back up and Recover Data; Administer Users; Transport Data between Databases; Manage Data; Configure the Network

Target Audience
Database Administrators Sales Consultants Support Engineer Project Manager Database Designers Technical Consultant

Key Topics

  • Introduction (Database Architecture)
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Performing Flashback
  • Moving Data

Objectives

  • nstall Oracle Database 10g and configure a database
  • Manage the Oracle instance
  • Manage the Database storage structures
  • Create and administer user accounts
  • Perform backup and recovery of a database
  • Monitor, troubleshoot, and maintain a database
  • Configure Oracle Net services
  • Move data between databases and files

Required Skills/Experience

  • Working knowledge of SQL

Suggested Next Course(s)

  • Oracle Database 10g: Administration Workshop II

Fee: $3,000.00


Course Schedule:
Back to Course Description

Austin

Charlotte

Columbia

Hunt Valley

Lansing

Madison

Milwaukee

Minneapolis

Oak Brook

Oklahoma City

Phoenix

Raleigh

San Antonio

Schaumburg

Tulsa

Washington DC