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

Information Request

Apply to course now

Oracle

  • Duration :   40 hours
  • Certificates :   Yes

Next Class Start Date - Call us at (416) 292-0003

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.