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