Detailed Course Outline
Introduction: Managing The Database Instance
- The Database Management Tools
- EM Database Express
- EM Cloud Control
- SQL Developer
- Database Administration Duties
Introduction: Database Architecture Review
- Database Instance Configurations
- Memory Structures
- Process Structures
- Storage Architecture
Introduction: 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
Introduction: Oracle Network Environment
- Oracle NET Services Architecture
- Oracle NET Configuration Assistant
- Oracle NET Manager
- Using EM Cloud Control
- Advanced Network Compression
- Troubleshooting Network Problems
Introduction: 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
Performance & Availability: Managing Performance & SQL Tuning
- Management Advisory Framework
- Performance Monitoring & AWR
- The SQL Tuning Advisor
- Monitoring Exceptions With Metrics
Performance & Availability: Data Concurrency
- About System & User Locks
- Monitor & Manage User Locks
- Monitor Locks With Data Dictionary
- Manage Locks With EM
Performance & Availability: Backup & Recovery Concepts
- Backup & Recovery Structures
- Managing Redo Data
- Configuring For Recoverability
- Instance Recovery
- Recoverability Checklist