Core Concepts and tools of the Oracle DATABASE

Configuring for Recoverability

Using the RMAN Recovery catalog

Creating Backups with RMAN

Configuring Backup Setting

Managing The Database Instance
• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administration Duties
Database Architecture Review
• Database Instance Configurations
• Memory Structures
• Process Structures
• Storage Architecture
Starting & Stopping Database Services
• Start & Stop The Database Listener
• About Database Startup/Shutdown
• SYSOPER
• SYSDBA
• Database State & Stages
• Startup With EM Cloud Control
• Startup With SQL*PLUS

Creating Backups with RMAN

Configuring Backup Setting

Managing The Database Instance
• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administration Duties
Database Architecture Review
• Database Instance Configurations
• Memory Structures
• Process Structures
• Storage Architecture
Starting & Stopping Database Services
• Start & Stop The Database Listener
• About Database Startup/Shutdown
• SYSOPER
• SYSDBA
• Database State & Stages
• Startup With EM Cloud Control
• Startup With SQL*PLUS
• Shutdown With EM Cloud Control
• Shutdown With SQL*PLUS
• Using MS Windows Services
Oracle Network Environment
• Oracle NET Services Architecture
• Oracle NET Configuration Assistant
• Oracle NET Manager
• Using EM Cloud Control
• Advanced Network Compression
• Troubleshooting Network Problems
Diagnostics & Oracle Support
• About Database Diagnostics
• Fault Diagnosability Infrastructure
• Database Instance Health Snapshot
• The Support Workbench
• Proactive Database Health Checks
• Package Diagnostic Data
• Working With The Knowledge Base
Storage: Tablespace Management
• Starter Tablespaces
• Create Tablespace With EM CC
• Create Tablespace With SQL
• Manage Tablespaces With EM CC
• Manage Tablespaces With EM DE
• Manage Tablespaces With SQL
• DROP Tablespace
• ALTER Tablespace
Storage: Advanced Tablespace Management
• Managing Temporary Tablespaces
• Temp Tablespace Groups With EM
• Temp Tablespace Groups With SQL
• Default Permanent Tablespaces
• Bigfile Tablespaces
• Managing The SYSAUX Tablespace
Storage: Data Files & Temp Files Management
• Manage Data Files With EM
• Access Metadata With SQL
• Manage Data Files With SQL
• Manage Temp Files
• Oracle-Managed Files (OMF)
Storage: Undo Data & Undo Tablespaces
• About Undo Space Management
• Configure Undo Management
• Guarantee Undo Retention
• Monitor Undo Space With SQL
• Use The EM Undo Advisor
Security & Schemas: Security Overview & Database Privileges
• Database Security Principles
• Database System Privileges
• Database Object Privileges
• Super Administrator Roles
• Privilege Analysis
Security & Schemas: User Security
• Create & Manage User Accounts
• Manage Users With EM
• Manage Users With SQL
• CREATE User
• ALTER User
• DROP User
• Grant & Revoke Privileges
• Resource Limits Via Profiles
• ALTER Profile
• DROP Profile
• Password Management Via Profiles
• Role-Based Security Management
• Alter User…Default Role
• Set Role
• Delegating Privilege Authorization
• With Admin Option & System Privileges
• With Grant Option & Object Privileges
• Principle Of Least Privilege Checklist
Security & Schemas: Database Auditing
• Auditing Database Activity
• Traditional Auditing
• Unified Auditing
• Create Audit Policy
Security & Schemas: SQL Loader
• Loader Concepts
• Loader From The Command Line
• Control File Options
• Load Methods
• Loader Express Mode
• Loader From EM
Security & Schemas: Export & Import
• Manage Directory Objects
• The Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Dictionary Views
• Using The EM Cc Interface