Oracle DBA (Solaris & AIX)

 




(Also teaching Oracle 12c)

Available now! Oracle Database 12c: New Features for Administrators

The Oracle DBA career track includes gaining knowledge and working experience in Oracle database running on UNIX Systems. The following modules make up the Famsoft's Oracle DBA career track:

The following modules make up the Famsoft's Oracle 11g DBA career track:

1. Introduction to Oracle 11g: SQL

2. Oracle 11g Database Administration Fundamentals I

3. Oracle 11g Database Administration Fundamentals II








Introduction to Oracle 11g: SQL | Hours: 40 | Sessions: 12

This course introduces students to Relational databases, data server technology, and explores the concepts of relational databases and the powerful SQL and iSQL* PLUS commands.


1. Data Modeling and Normalization

2. Queries against relational tables

3. DDL, DML and Select statements

4. Perfoming joins and grouping

5. Updating Tables

6. Enforcing business rules using declarative constraints

7. Building Reports with SQL*Plus


Course Pre-Requisite: None (Students are assumed to have basic computer knowledge)

Back to Top


Oracle 11g Database Administration Fundamentals I | Hours: 40 | Sessions: 12

Architecture and Administration is an introduction to the architecture of an Oracle Database Management System and the techniques used to manage and administer the database effectively. The course outline will provide you with practical experience administering an Oracle database:


1. Understanding Oracle Architecture

2. Managing Oracle Instances

3. Creating and populating a database

4. Starting up and shutting down a database

5. Maintaining Control Files

6. Managing tablespaces

7. Managing UNDO data

8. Monitoring space allocation

9. Creating user accounts with appropriate privileges and resources

10. Partitioning tables and indexes

11. Configuring the database for archive logging

Course Pre-Requisite: Introduction to Oracle 11g: SQL

Back to Top


Oracle 11g Database Administration Fundamentals II | Hours: 40 | Sessions: 12

This course includes Oracle Network Administration and Oracle Backup and Recovery. Network and Distributed Administration covers the tools and techniques used when configuring an Oracle Database Management System in a network environment. The backup and recovery portion includes students to the essential task of planning and implementing database backup and recovery strategies.


1. Server-side configuration using Oracle Net Manager

2. Client Side configuration using Oracle Net Configuration Assistant

3. Centralized naming concepts

4. Oracle Name usage and configuration

5. Shared server usage and configuration

6. Connection Manager usage and configuration

7. Troubleshooting the network environment

8. Security in the network environment

9. Backing up/ restoring Oracle Databases

10. Cloning databases

11. Recovering from disk failure

12. Recovering tablespaces and entire databases

13. Performing recovery in the absence of a control file

14. Configuring and Using Recovery Manager (RMAN)

15. Creating hot standby databases


Course Pre-Requisite: Oracle 11g Database Administration Fundamentals I

Back to Top