Call 0800 860 6719 info@uniquelearn.co.uk

Oracle® 11g Database
Administration (DBA)

  • Teacher
  • Category
  • Course
    5 days,
  • Course Price
    £1100
Database Administrator
Book Now

This class will develop the key fundamental skills necessary to be an Oracle® DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class

Learning Objective

The overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification.

  • Create an Oracle Database using the Oracle Database Creation Assistant.
  • Manage an Oracle Database.
  • Configure various database structures.
  • Setup database and user security
  • Add and and administer users
  • Monitor and tune main server areas

Target Audience

  • Application developers
  • System administrators
  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers

Prerequisites

  • ORACLE DATABASE 11G SQL FUNDAMENTALS
  • ORACLE DATABASE 11G R2: PROGRAM WITH PL/SQL

Outline

INSTALLATION & UPGRADE VOLUME

  • CONFIGURING THE SERVER FOR INSTALLATION
  • ENTERPRISE EDITION INSTALLATION
  • VERIFY THE INSTALLATION
  • UPGRADE, DE-INSTALLATION & PATCHING

VOLUME A:

  • MANUALLY STARTING & STOPPING DATABASE SERVICES
  • EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL
  • EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
  • EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
  • ENABLING TRANSPARENT DATA ENCRYPTION
  • MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
  • MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
  • MANAGE DATABASE STORAGE STRUCTURES: DATA FILES & TEMP FILES
  • MANAGING UNDO DATA

VOLUME B:

  • NETWORK ENVIRONMENT: ORACLE NET SERVICES
  • NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
  • SECURITY: IMPLEMENTING DATABASE SECURITY
  • SECURITY: ADMINISTERING USER SECURITY
  • MOVING DATA: SQL LOADER
  • MOVING DATA: EXPORT & IMPORT
  • DATABASE MAINTENANCE & PERFORMANCE MONITORING
  • MANAGING CONCURRENCY & LOCKS
  • BACKUP & RECOVERY CONCEPTS & CONFIGURATION

Course Information

  • Class Start : Days: 23 Sep |21 Oct |18 Nov | 20 Jan
  • Course Duration : 5 days,
  • Student Capacity : Small classes
  • Class Schedule : Mon-Fri | Saturday
  • Class Time : 10:00-17:00
  • Course Price : £1100
  • Teacher Name :

Comments

Leave a Reply

Your e-mail address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

This website uses cookies to improve your experience. We’ll assume you are ok with this, but you can opt-out if you wish.