Oracle DBA - Level 1

Oracle DBA - Level 1

Oracle Database Administration – entry level for configuration, securing, maintaining and protecting databases

 

Understanding Oracle Database Architecture

  • Understanding Oracle Database Instance Configurations
  • Understanding Oracle Database Memory and Process Structures
  • Understanding Logical and Physical Database Structures
  • Understanding Oracle Database Server Architecture

Managing Database Instances

  • Starting Up Oracle Database Instances
  • Using Data Dictionary Views
  • Shutting Down Oracle Database Instances
  • Using Dynamic Performance Views
  • Using the Automatic Diagnostic Repository (ADR)
  • Using the Alert Log and Trace Files
  • Managing Initialization Parameter Files

Managing Users, Roles and Privileges

  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • Creating and Assigning Profiles
  • Administering User Authentication Methods
  • Managing Oracle Database Users, Privileges, and Roles

Managing Storage

  • Managing Resumable Space Allocation
  • Shrinking Segments
  • Deferring Segment Creation
  • Using Space-Saving Features
  • Deploying Oracle Database Space Management Features
  • Managing Different Types of Segments
  • Using Table and Row Compression
  • Understanding Block Space Management

Moving Data

  • Using External Tables
  • Using Oracle Data Pump
  • Using SQL*Loader

Accessing an Oracle Database with Oracle supplied Tools

  • Using the Database Configuration Assistant (DBCA)
  • Using Oracle Enterprise Manager Cloud Control
  • Using Oracle enterprise Manager Database Express
  • Using SQL Developer
  • Using SQL Plus

Course Enquiry