TRAINING

ROYALTECH offers a wide array of courses for the IT professional and beginners courses for those looking for a career change. Remote participants are assigned homework, given quizzes, and asked to register through the classroom portal.

WHY ORACLE?

Oracle still tops the RDBMS Market!

Leading IT industry analyst firm Gartner, Inc. announced its recent Worldwide RDBMS Market Share Report this quarter and, as in the past couple of years, Oracle is the clear leader with a 58.1% market share. Oracle touted this news by exclaiming that it holds more market share than its five closest competitors combined.
Oracle grew at 10.9%, exceeding both the industry average (9.9%) and the growth rates of its closest competitors.

PRE-REQUISITES FOR DBA TRAINING

Anyone is eligible to register for the Oracle DBA course @ CIT. But, the below is our recommended target audience.

Students and professionals who have at least a high school diploma or an associates degree.
Students having a bachelor’s degree in any discipline.
Students and professionals who already have prior exposure to Computer Science concepts.
Professionals who already have studied Oracle elsewhere but did not acquire the confidence level needed to get out there to interview, let alone work.
Organizations who want to provide Oracle DBA training to their employees.

World CLASS LAB ENVIRONMENT

Students get remote access to a computer server for practice.
Provides Remote server access to our HYBRID students spread all over the world.
Provides Windows 2012, LINUX (RHEL and CentOS 7.x) using file system and ASM as storage.
Introduces students to managing database servers on the Cloud.

Course Descriptions

ORACLE CERTIFIED ASSOCIATE (OCA) PREP COURSE

RoyalTech’s Oracle Database 12c Administrator Certified Associate course is a 15 week course that covers the skills set required for daily operational management and maintenance on Oracle 12c. This course will prepare serious students to take the Oracle certification exam. The OCA course will also incorporate employment guidance, resume assistance, and mock interviews. The final goal of this course is to obtain employment as a Jr Database administrator.

Oracle Database Certification Paths Overview

The Oracle Database is the most flexible, scalable, reliable, fast and secure data management platform available in the market. Today’s Oracle Database offers more cost and performance management features than ever before, whether you run it in your data center on your hardware, run it in Cloud as Customer, or run it in the Oracle Public Cloud. Oracle University partners with experts from product development, consulting and our own industry leading customers to provide you instruction, insight and best practices to get the most of out the Oracle Database.

Oracle Database Training will:

Help you choose which deployment architecture works for your data management situation.
Teach you the skills you need to install, configure, design and troubleshoot database systems.
Demonstrate how to use advanced features or the Oracle Database to extend it for your data management solution.

Exploring Oracle Database Architecture

Introducing Oracle Database
Relational Database Models
Oracle SQL and PL/SQL
Connecting to Oracle Databases
Oracle Database Tools
Oracle-Supplied User Accounts
Querying the Oracle Data Dictionary

Configuring the Oracle Network Environment

Oracle Net Services
How Listeners Work
Configuring Listeners for Dynamic Service Registration
Configuring Local Naming for Connections
Testing Oracle Net Connectivity with tnsping

Creating and Managing Tablespaces

Creating Tablespaces in SQL*Plus
Altering and Dropping Tablespaces in SQL*Plus
Viewing Tablespace Information in SQL*Plus
Implementing Oracle Managed Files
Moving or Renaming Online Data Files in SQL*Plus

Managing UNDO Data

Undo Data: Overview
Configuring Undo Retention
Guaranteeing Undo Retention
Changing an Undo Tablespace to a Fixed Size
Viewing Undo Information
Viewing Undo Activity

Backup and Recovery Concepts

DBA Responsibilities
Categories of Failure
Understanding Instance Recovery
Understanding Types of Backups
Comparing Complete and Incomplete Recovery
Oracle Data Protection Solutions
Flashback Technology

Tuning SQL

SQL Tuning Process

Managing DBCS Database Deployments

Managing Network Access to DBCS

Creating an Oracle Database by Using DBCA

Choosing and using Appropriate Character Sets
Using DBCA to Create and delete Databases and templates and for other tasks

Managing Database Instances

Working with Initialization Parameters
Starting Up Oracle Databases
Shutting Down Oracle Databases
Querying Dynamic Performance Views

Administering User Security

Creating Users
Granting Privileges
Creating and Granting Roles
Revoking Privileges and Roles
Creating and Assigning Profiles
Authenticating Users
Assigning Quotas to Users

Managing Storage Space

Types of Segments
Allocating Extents
Understanding Deferred Segment Creation
Monitoring Tablespace Space Usage
Reclaiming Space by Shrinking Segments

Moving Data

Moving Data: General Architecture
Oracle Data Pump: Overview
Oracle Data Pump: Benefits
Data Pump Export and Import Clients
Data Pump Utility: Interfaces and Modes
SQL*Loader Overview
Loading Methods
SQL*Loader Express Mode

Monitoring and Tuning Database Performance

Performance Management Activities
Performance Planning Considerations
Database Maintenance
Managing Memory Components

Introduction to Oracle Database Cloud Service

Database Cloud Service Offerings
DBCS Architecture
Features and Tooling

Backing Up and Restoring DBCS Database Deployments

Backup and Recovery tools and concepts

Upgrading to Oracle Database 12c

Earning an Oracle Database 12c R2 Administrator OCA certification exposes you to the fundamental concepts and skills DBAs need for daily operational management and maintenance. Earning this certification positions you to seamlessly move forward to the Oracle Certified Professional level when you’re ready.

Upgrading by Using the Database Upgrade Assistant (DBUA)
Manually Upgrading to Oracle Database 12c

The Oracle Certified Professional (OCP) credential builds upon the fundamental skills demonstrated by the OCA. The Oracle Certified Professional has a command of a specific area of Oracle technology and demonstrates a high level of knowledge and skills. IT managers often use the OCP credential to evaluate the qualifications of employees and job candidates.

OCP -details

Oracle Database 12c R2: Managing Multitenant Architecture Ed 2

CDB basics

Describe the CDB root and pluggable database containers
Differentiate the CDB root from a pluggable database

Application PDBs and Application Installation

Explain the purpose of application root and application seed
Define and create application PDBs
Install an application
Upgrade and patch applications
Describe the commonality concept in application contexts
Describe enhancements in various areas

CDB and PDB Management

Establish connections to CDB and PDB
Start up and shut down a CDB
Open and close PDBs
Start PDB service
Change the different modes and settings of PDBs
Evaluate the impact of parameter value changes

Security

Manage common and local users, roles, privileges and profiles in PDBs
Manage common and local objects in application containers
Enable common users to access data in PDBs
Manage PDB lockdown profiles
Manage other types of policies in application containers
Allow per-PDB wallets for certificates

Performance Monitoring

Monitor operations and performance in a CDB and PDBs
Manage SGA and PGA limits at the PDB level
Manage AWR snapshots at the CDB and PDB levels
Run ADDM tasks for CDB and PDB recommendations
Manage application shared object statistics
Control query DOP involving the containers() construct
Control PDB IO rate limits

Data Movement

Export from a non-CDB and import into a PDB
Export from a PDB and import into a PDB or into a non-CDB
Use SQL*Loader to load data into a PDB

PDBs in Cloud

Create a database deployment in the Cloud
Create PDBs in the Cloud database using DBaaS Monitor
Understand encryption in a Cloud CDB and PDBs
Manage PDBs in the Cloud database using DBaaS Monitor
Migrate on-premises PDBs in a database deployment in the Cloud

Configuring for Recoverability

Configure and manage RMAN settings
Configure the Fast Recovery Area
Configure the control file to ensure appropriate protection
Configure the redo log files for recoverability
Configure ARCHIVELOG mode and the archived redo log files for recoverability

Backup Strategies and Terminology

Describe RMAN backup types
Describe, compare and determine your backup strategy
Perform whole backups

Improving Your Backups

Compress backups
Use a media manager
Create multi-section backups of very large files
Create proxy copies
Create duplexed backup sets
Create archival backups
Backup non-database files:
Backup up a control file to trace
Backup archived redo log files
Catalog additional backup files
Back up ASM meta data

Diagnosing Failures

Detect and repair database corruption
Use the Automatic Diagnostic Repository
Analyze instance recovery with ADRCI
Find and interpret message output and error stacks
Use the Data Recovery Advisor
Handle block corruption

Performing Recovery, Part 1

Perform the appropriate type of restore and recovery operation based on the nature of your database failure
Recover from media failures in data files
Perform complete and incomplete or “point-in-time” recoveries

RMAN and Oracle Secure Backup

Configure for RMAN tape backups and restores
Perform RMAN backup to tape
Perform database recovery from tape
Manage tape backups

Using Flashback Database

Describe Flashback Database architecture
Configure your database to support Flashback Database
Perform Flashback Database

Performing Point-in-Time Recovery

Distinguish and describe point-in-time recovery (PITR) of table, tablespace, and database
Identify the circumstances where PITR is a good solution and where it cannot be used
List what operations occur when you perform a point-in-time recovery
Determine the correct target time for the point-in-time recovery
Perform automated TSPITR
Perform table recovery from backups

RMAN Troubleshooting and Tuning

Interpret RMAN message output
Apply best practice tuning principles
Diagnose RMAN performance issues

Oracle Database 12c R2: Install and Upgrade Workshop Ed 2

Oracle Software Installation Basics

Operating System Groups and Users
Environment Variables
Configuring the Oracle Software Owner Environment Using Oracle Universal Installer (OUI)
Installation Option: Silent Mode

Patching Oracle Software

Overview of Patching and patch types
Determining the latest patch sets available
Upgrading OPatch
Patching Using OPatch
Post Patch steps using Datapatch
Patching Using opatchauto
Patching Using OPlan

Oracle Restart

Configuring and using Oracle Restart
Choosing and using the Correct SRVCTL Utility
Displaying the Oracle Restart Configuration for a Component
Manually Adding Components to the Oracle Restart Configuration

Performing Post-Upgrade Tasks

Required and recommended Tasks After Database Upgrade
Understanding Auditing Implementation
Enabling Unified Auditing
Administering the Roles Required for Auditing
System-Managed SDB

Diagnosing Database Problems

TFA Collector utility
Tracing Data Pump
New ADRCI Command
Automatic Diagnostic Repository
MVs refreshed statistics history
Trace File Analyzer (TFA) Collector process and repository
ADR Retention
Network Performance