Oracle Database 12c: Administration Workshop

IT/Networking/Server/Operating Systems
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

This Oracle Database 12c: Administration Workshop training class teaches the day-to-day administration tasks required of an Oracle database administrator, assists students in preparation for certification as an Oracle Certified Associated (OCA) database administrator, and introduces students to many of the administration sub-specialties that they may wish to pursue next.

This training is appropriate for database administrators, application designers and developers, web server administrators, system administrators, implementation specialists, data center support engineers, chief Information Officers (CIO), and other information technology (IT) management professionals.

This course helps prepare students for the Oracle Database 12c Administrator Certified Associate (OCA) certification and for Exam: 1Z0-062: Oracle Database 12c: Installation And Administration.


  1. Learn to manage the database instance.
  2. Learn about database architecture.
  3. Learn to manage database services.
  4. Learn to work with the oracle network environment.
  5. Learn about diagnostics and support.
  6. Learn to manage tablespaces.
  7. Learn about data file and temp file management techniques.
  8. Learn to manage security and privileges.

  1. Introduction: Managing the Database Instance
    1. The Database Management Tools
    2. EM Database Express
    3. EM Cloud Control
    4. SQL Developer
    5. Database Administration Duties
  2. Introduction: Database Architecture Review
    1. Database Instance Configurations
    2. Memory Structures
    3. Process Structures
    4. Storage Architecture
  3. Introduction: Starting and Stopping Database Services
    1. Start and Stop The Database Listener
    2. About Database Startup/Shutdown
    3. SYSOPER
    4. SYSDBA
    5. Database State and Stages
    6. Startup with EM Cloud Control
    7. Startup with SQL*PLUS
    8. Shutdown with EM Cloud Control
    9. Shutdown with SQL*PLUS
    10. Using MS Windows Services
  4. Introduction: Oracle Network Environment
    1. Oracle NET Services Architecture
    2. Oracle NET Configuration Assistant
    3. Oracle NET Manager
    4. Using EM Cloud Control
    5. Advanced Network Compression
    6. Troubleshooting Network Problems
  5. Introduction: Diagnostics and Oracle Support
    1. About Database Diagnostics
    2. Fault Diagnosability Infrastructure
    3. Database Instance Health Snapshot
    4. The Support Workbench
    5. Proactive Database Health Checks
    6. Package Diagnostic Data
    7. Working with The Knowledge Base
  6. Storage: Tablespace Management
    1. Starter Tablespaces
    2. Create Tablespace with EM CC
    3. Create Tablespace with SQL
    4. Manage Tablespaces with EM CC
    5. Manage Tablespaces with EM DE
    6. Manage Tablespaces with SQL
    7. DROP Tablespace
    8. ALTER Tablespace
  7. Storage: Advanced Tablespace Management
    1. Managing Temporary Tablespaces
    2. Temp Tablespace Groups with EM
    3. Temp Tablespace Groups with SQL
    4. Default Permanent Tablespaces
    5. Bigfile Tablespaces
    6. Managing The SYSAUX Tablespace
  8. Storage: Data Files and Temp Files Management
    1. Manage Data Files with EM
    2. Access Metadata with SQL
    3. Manage Data Files with SQL
    4. Manage Temp Files
    5. Oracle-Managed Files (OMF)
  9. Storage: Undo Data and Undo Tablespaces
    1. About Undo Space Management
    2. Configure Undo Management
    3. Guarantee Undo Retention
    4. Monitor Undo Space with SQL
    5. Use The EM Undo Advisor
  10. Security and Schemas: Security Overview and Database Privileges
    1. Database Security Principles
    2. Database System Privileges
    3. Database Object Privileges
    4. Super Administrator Roles
    5. Privilege Analysis
  11. Security and Schemas: User Security
    1. Create and Manage User Accounts
    2. Manage Users with EM
    3. Manage Users with SQL
    4. CREATE User
    5. ALTER User
    6. DROP User
    7. Grant and Revoke Privileges
    8. Resource Limits Via Profiles
    9. ALTER Profile
    10. DROP Profile
    11. Password Management Via Profiles
    12. Role-Based Security Management
    13. Alter User...Default Role
    14. Set Role
    15. Delegating Privilege Authorization
    16. with Admin Option and System Privileges
    17. with Grant Option and Object Privileges
    18. Principle Of Least Privilege Checklist
  12. Security and Schemas: Database Auditing
    1. Auditing Database Activity
    2. Traditional Auditing
    3. Unified Auditing
    4. Create Audit Policy
  13. Security and Schemas: SQL Loader
    1. Loader Concepts
    2. Loader From The Command Line
    3. Control File Options
    4. Load Methods
    5. Loader Express Mode
    6. Loader From EM
  14. Security and Schemas: Export and Import
    1. Manage Directory Objects
    2. The Data Pump Architecture
    3. Data Pump Export
    4. Data Pump Import
    5. Data Pump Dictionary Views
    6. Using The EM Cc Interface
  15. Performance and Availability: Managing Performance and SQL Tuning
    1. Management Advisory Framework
    2. Performance Monitoring and AWR
    3. The SQL Tuning Advisor
    4. Monitoring Exceptions with Metrics
  16. Performance and Availability: Data Concurrency
    1. About System and User Locks
    2. Monitor and Manage User Locks
    3. Monitor Locks with Data Dictionary
    4. Manage Locks with EM
  17. Performance and Availability: Backup and Recovery Concepts
    1. Backup and Recovery Structures
    2. Managing Redo Data
    3. Configuring for Recoverability
    4. Instance Recovery
    5. Recoverability Checklist

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.


Class Prerequisites

Experience in the following is required for this Oracle class:

  • SQL fundamentals.
  • Install and upgrade experience.
  • Architecture and internals experience.

Prerequisite Courses

Courses that can help you meet these prerequisites:

  • Introduction to SQL Training
  • Oracle Database 12c: Architecture and Internals

Course Setup
  • Live Online: Course Setup | WebEx Setup