ACLM Institute Of Professional Studies - CVRU

Length : 2 Months / 48 Hrs.

Language(s) : English

Audience(s) : IT Professionals

Level : 300

Technology : Oracle Certified Professional Training

Type : Boot-Up Training

Delivery Method : Instructor-led (classroom) – One to One

Course Fee : 12,000/-

Overview

This hands-on course will teach you to effectively plan, install, configure, administer, query, troubleshoot and manage Oracle Databases. All books and materials are included.
The course will prepare students for the Oracle exams, as well as deliver a foundation in the real world application of their database skills.

Learn how to:
• Install, configure, and administer Oracle Database systems
• Manage and maintain an Oracle Database
• Plan, design and create tables
• Create and update reports from Oracle Databases
• Query Oracle databases using SQL and iSQL*Plus to retrieve critical business data
• Backup and recovery of database systems
• Tune and optimize a Oracle Database for most efficient use of computer resources

Audience and Prerequisites
This course is designed for individuals with the Oracle 11g Certified Associate certification or equivalent knowledge.

Course Content
Database Architecture and ASM
• Oracle Database Architecture Overview
• ASM General Architecture
• Creating an ASM Instance
• Using Enterprise Manager to Manage ASM Users
• ASM Storage Concepts
• The ASMCMD Utility
• ASM Scalability and Performance

Configuring for Recoverability
• Purpose of Backup and Recovery Functionality
• Typical Backup and Recovery Tasks
• Oracle Backup and Recovery Solutions
• Using Recovery Manager (RMAN)
• Using a Flash Recovery Area
• Flash Recovery Area Space Management