Course Introduction
Oracle 11g is a contemporary release of Oracle Database family of products.
Besides retaining core concepts of its predecessor Oracle 10g, it has introduced
certain new concepts and features to make it a most robust database system.
This course develops skills required to manage Oracle 11g Databases efficiently
with new functionality that makes many common operations tasks incredibly
fast and simple. The course starts from teaching Oracle Database 11g
fundamentals and moves on to the advanced level tasks a DBA has to exercise
to keep the system up and running.
Basic computer knowledge. Familiarity with data processing concepts and ‘Windows’ graphical user
interface (GUI).
- Database Administrators
- Database Designers
- Developer
- Support Engineer
- Technical Administrator
Common Goal: To get a job as an Oracle Database Administrator (Oracle DBA)
For New Graduates: To get a job as an Oracle Database Administrator (Oracle DBA)
For College Students: To understand the basics of Database and RDBMS concepts
For those with some IT experience: To get into Oracle Database Administration (Oracle DBA)
For Information Technology Managers: To understand the basics of RDBMS so that they efficiently manage a DBA team
For others: To understand the Database and RDBMS concepts
To understand the fundamentals of Oracle Database (including Oracle 12c and Oracle 11g)
Exploring the Oracle Database Architecture
Preparing the Database Environment
Creating an Oracle Database;
Managing the Oracle Instance; Managing Database Storage Structures
Managing Schema Objects; Managing Undo Data
Implementing Oracle Database Security;
Database Security and Principle of Least Privilege;
Work with Standard Database Auditing
Backup and Recovery Concepts
Performing Database Backups; Performing Database Recovery
Configuring Backup Specifications
Using Flashback Technology
Database Architecture and ASM
Managing Resources: Automating Tasks with the Scheduler: Globalization
Oracle Database administration certification
Oracle database administrator