We are happy to advise you!
+49 40 253346-10     Contact
> > > ORDB12C Detailed outline

Oracle Database 12c: Administration Workshop (ORDB12C)

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
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!