Administration Workshop I – Institute of Software Technologies

Administration Workshop I

Administration Workshop I

This Database 11g Administration training gives you a firm foundation in basic database administration, including how to install and maintain an Oracle database. Learn about architecture and how the database components that will prepare you for the corresponding Oracle Certified Associate exam.

This course covers the following;

• Exploring the Oracle Database Architecture
• Installing your Oracle Software
• Creating an Oracle Database
• Managing the Oracle Database Instance
• Manage the ASM Instance
• Configuring the Oracle Network Environment
• Managing Database Storage Structures
• Administering User Security
• Managing Data Concurrency
• Managing Undo Data
• Implementing Oracle Database Auditing
• Database Maintenance
• Performance Management
• Backup and Recovery Concepts
• Performing Database Backups
• Performing Database Recovery
• Moving Data
• Working with Support

Required prerequisites;

• Taken Oracle Introduction to SQL course or equivalent experience
• Taken Oracle PL/SQL course or equivalent experience

You will learn how to:
• Install Oracle Grid Infrastructure

• Install and configure Oracle Database 11g

• Configure Oracle Net services

• Monitor and administer undo data

• Manage the database storage structures

• Create and administer user accounts

• Perform basic backup and recovery of a database

• Manage data concurrency

• Monitor performance

• Describe Oracle Database Architecture

This course prepares you for the following certifications:
• Oracle Certified Associate (OCA) – (Database Admin)

How you will be assessed?

Theory
90%
Practical
90%
Exam
90%

Deadline

7th Feb 2020

Deadline

7th March 2020

Deadline

7th Sept 2020