Oracle

Oracle 2018-05-08T16:54:48+00:00

Oracle

Course Length :  40 hours
Mode Of Delivery :  Fully instructor-led classroom or online training

Overview

Oracle Database 11g Administrator Certified Associate (OCA) Describing the Oracle Architecture Oracle Server SGA Datafiles Background Processes Creating an Oracle Database Database Configuration Assistance Database Templates Managing an Oracle Instance Oracle Enterprise Manager Database Storage Structures Tablespaces Datafiles Tempfiles Database Security System Accounts Application Accounts Database Roles.

Oracle Database 11g Administrator Certified Associate (OCA)

Describing the Oracle Architecture

  • Oracle Server
  • SGA
  • Datafiles
  • Background Processes

Creating an Oracle Database

  • Database Configuration Assistance
  • Database Templates

Managing an Oracle Instance

  • Oracle Enterprise Manager

Database Storage Structures

  • Tablespaces
  • Datafiles
  • Tempfiles

Database Security

  • System Accounts
  • Application Accounts
  • Database Roles

Schema Objects

  • Tables
  • Indexes
  • Views
  • Synonyms

Data Manipulation Language

  • Insert
  • Update
  • Delete
  • Database Packages
  • Database Procedures

Undo Data

  • Flashback Query

Database Maintenance

  • Automatic Workload Repository
  • Automatic Database Diagnostic Monitor

Database Performance

  • Memory Advisors

Database Backup

  • RMAN
  • Open database Backup
  • Closed database Backup

Database Recovery

  • Open Database Recovery
  • Closed Database Recovery

Moving Data

  • Data Pump
  • SQL*Loader
Online Course Fee Payment
Other Amount:
Your Email Address:

Oracle

  • Duration :   40 hours
  • Certificates :   Yes
Online Course Fee Payment
Other Amount:
Your Email Address:

Quick Facts

Oracle Database 11g Administrator Certified Associate (OCA) Describing the Oracle Architecture Oracle Server SGA Datafiles Background Processes Creating an Oracle Database Database Configuration Assistance Database Templates Managing an Oracle Instance Oracle Enterprise Manager Database Storage Structures Tablespaces Datafiles Tempfiles Database Security System Accounts Application Accounts Database Roles.