Course Content:

General Database and Network Administration

Create and manage pluggable databases
Administer users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Administer database configuration files
Configure shared server
Manage network file directories

Manage Database Availability

Install the EM Cloud Control agent
Configure recovery catalog
Configure RMAN
Perform a full database backup
Configure and monitor Flashback Database

Data Warehouse Management

Manage database links
Manage a fast refreshable materialized view
Create a plug-in tablespace by using the transportable tablespace feature
Optimize star queries
Configure parallel execution
Apply a Patch
Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
Manage external tables

Data Management

Manage additional buffer cache
Optimize space usage for the LOB data
Manage an encrypted tablespace
Manage schema data
Manage partitioned tables
Set up Fine-Grained Auditing
Configure the database to retrieve all previous versions of the table rows

Performance Management

Configure the Resource Manager
Tune SQL statements
Use real application testing
Manage SQL Plan baselines
Capture performance statistics
Tune an instance – Configure and manage result cache, Control CPU use for Oracle Instances, Configure and manage “In Memory” features
Manage extended statistics
Create and manage partitioned indexes

Data Guard

Administer a Data Guard environment
Create a physical standby database
Configure a standby database for testing
Configure a standby database to apply redo
Configure a standby database to use for reporting
Configure fast start failover
Manage extended statistics
Manage DDL in a Data Guard environment

Grid Infrastructure

Install Oracle Grid Infrastructure
Create ASM Disk Groups
Create and manage ASM instances
Configure ASM Cloud File System (ACFS)
Administer Oracle Clusterware
Manage Flex Clusters and Flex ASM
Manage Flex Clusters and Flex ASM

Real Application Cluster Database

Install Oracle Database software
Create a Real Application Clusters (RAC) database
Configure Database Services
Administer Oracle RAC databases on one or more cluster nodes

Training Track: Database

Job Interview Preparation  (Soft Skills Questions & Answers)

• Tough Open-Ended Job Interview Questions
• What to Wear for Best Job Interview Attire
• Job Interview Question- What are You Passionate About?
• How to Prepare for a Job Promotion Interview

Flexible Class Options

• Week End Classes For Professionals  SAT | SUN
• Corporate Group Trainings Available
• Online Classes – Live Virtual Class (L.V.C), Online Training

Related Oracle Courses

Oracle 12c Master Certified Training

Oracle DBA 12c Fundamentals Course

Oracle SQL Database Expert Course