This course runs for a duration of 5 Days.
The class will run daily from 9:00 am CST to 5:00 pm CST.
Class Location: Houston - Houston, TX.
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. This course covers both Database as a Cloud Service and the on-premises Oracle Database.
Learn To:
Benefits To You
You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Audience
Course Objectives
Getting Started
Exploring Oracle Database Architecture
Managing Database Instances
Creating PDBs
Configuring the Oracle Network Environment
Administering User Security
Creating and Managing Tablespaces
Managing Storage Space
Managing UNDO Data
Moving Data
Backup and Recovery Concepts
Monitoring and Tuning Database Performance
SQL Tuning
Oracle Database Resource Manager
Enterprise Manager Cloud Control
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Managing DBCS Database Deployments
Backing Up and Restoring DBCS Database Deployments
Patching DBCS Database Deployments
Creating Master Encryption Keys for PDBs
Tablespace Encryption by Default
Required Prerequisites:
Suggested Prerequisites: