Home About Courses Schedule Services Webinars Contact Search

Oracle DBA Starter

SEE SCHEDULE

Duration: 1 Day

Method: Instructor led, Hands-on Workshops

Price: $600.00

Course Code: OR5820


Audience

All

Description

This course targets the student that needs to get up to speed on managing an Oracle database/instance in a hurry and may not have the time/budget for a longer course at this time. The course gets the student up and running fast teaching them the details of Oracle's architecture and typical database administration tasks. This course is perfect for new DBAs, Project Managers, System Analysts and Network Administrators along with students that have been tasked with being a backup DBA. It can also be helpful for those students that have experience being a DBA in other environments such as Db2 or SQL Server but now have a need to support Oracle.Hands-on workshops provide students with a solid understanding of the concepts.

Prerequisites

None

Topics

  • I. The Oracle Architecture
    • Instance vs. Database
    • Memory Structures
      • SGA, PGA
      • Buffer Cache, Log Buffer, Shared Pool
      • Other Caches
    • Memory Management
      • Automatic Memory Management (AMM)
      • Manual Memory Management
    • Database Files
      • Data Files
      • Control Files
      • Redo Log Files
      • Archived Redo Log Files
      • Other Files (Parameter Files, Password File)
    • Database Modes
      • ARCHIVELOG Mode
      • Flashback Database Mode
    • Using the Database Data Dictionary
  • II. Starting, Stopping Oracle
    • Starting Oracle Options
      • STARTUP, STARTUP MOUNT, STARTUP OPEN, STARTUP FORCE
      • Oracle Parameters
    • Stopping Oracle
      • SHUTDOWN, SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, SHUTDOWN ABORT
    • The Instance Alert Log
  • III. Database Security
    • Creating Users
    • Database Privileges
      • Granting/Revoking System Privileges
      • Granting/Revoking Object Privileges
    • Using Database Roles
    • Profiles
      • Default Profile
      • Profile Password Limits
      • Profile Resource Limits
      • Assigning Profiles
  • IV. Creating Database Objects
    • Tablespaces
    • Tables, Indexes, Constraints
  • V. Introduction to Database Backups
    • Types of Backups
      • Database File Backups
      • Logical Backups (Export Utility)