Oracle Database Administrator Training Programs

Oracle Training Programs

Oracle Database Administrator

Oracle Training Sitemap

Oracle Database Administrator Training Program Advanced search

Technology Driven IT Training

Web-based Training Services

Why SYS-ED for Web-based Training

Definition of Service

Delivery Medium

Contact You

The Oracle Database Administrator training program is comprised of SQL fundamentals, database administration, PL/SQL, and performance design course modules; the standard duration is 16 days. A lesson plan based upon the standards of the New York State Department of Education will be provided as part of qualifying the subject matter, examples, exercises, and program duration.

  • The base program can be extended to include specialized course search engine subject matter and implement the Oracle database platform and address client project specifications: Big Data and cloud computing.

  • For experienced information technology professionals, the training program can be tailored to present the principles of a SOA: service oriented architecture for platform migration and repurposing applications from a IBM mainframe or hybrid computing environment to the Oracle database and development platform.

SYS-ED's training programs are taught using multiple delivery medium: distance-learning, classroom instruction, and blended learning. In order to accommodate employee workloads and staff in remote geographic locations, component courses can be scheduled over non consecutive weeks combining classroom instruction and distance-learning. At the client's discretion, a record of completed assignments, validation assessment, and final examination can be utilized.

Oracle Database Administrator Training Program
Base Program Duration
Distance-learning Service
Learning Path
Oracle Database Platform
Technology Updates
Oracle Database
Oracle SOA: Service Oriented Architecture
Oracle Fusion

Oracle Web Server for Administrators and Developers Training Program

Teaching Models

Why SYS-ED for Oracle Database Administrator Training


Oracle: SQL - Introduction 2 days
Oracle: Database Administration 3 days
Oracle: Database Administration - Advanced 3 days
Oracle: PL/SQL Programming 4 days
Oracle: Performance and Design 4 days

Base Program Duration

16 days

Module: Oracle: SQL - Introduction
Duration: 2 days
Major Topics:
1. TSQL select statements 2. Data: restricting/sorting 3. Single-row functions
4. Multiple tables 5. Displaying data 6. Group functions
7. Subqueries 8. Readable output with ISQL*Plus 9. Data manipulation
10. Table: creation and management    

Module: Oracle: Database Administration
Duration: 3 days
Major Topics:
1. Oracle featureset 2. Tasks of an Oracle database administrator 3. Managing the Oracle instance
4. Managing database storage structures 5. Administering user security 6. Managing schema objects
7. Managing data and concurrency 8. Managing undo data 9. Implementing Oracle database security
10. Database maintenance 11. Performance management 12. Backup and recovery
13. Performing database recovery    

Module: Oracle: Database Administration - Advanced
Duration: 3 days
Major Topics:
1. Database architecture 2. ASM: Automated Storage Management 3. Configuring for recoverability
4. Configuring backup specifications 5. Creating backups 6. Restoring and recovering
7. Performing tablespace point-in-time recovery 8. Flashback technology 9. Diagnosing the database
10. Managing memory 11. Managing database performance 12. Using the segment advisor
13. Managing resources 14. Automating tasks with the scheduler 15. Administering the scheduler
16. Globalization    

Module: Oracle: PL/SQL Programming
Duration: 4 days
Major Topics:
1. Elements of SQL 2. Data definition statements 3. Data manipulation and control statements
4. Common SQL elements 5. SQL functions 6. SQL *Plus
7. PL/SQL 8. SQL statement tuning 9. GROUP BY clause
10. Subprograms 11. Functions 12. Packages
13. Triggers    

Module: Oracle: Performance and Design
Duration: 4 days
Major Topics:
1. Performance tuning process 2. Diagnostic tuning tools 3. Shared pool sizing
3. Buffer cache sizing 5. Sizing other SGA structures 6. Configuration I/O issues
7. Sort operations 8. Latch contention 9. Tuning rollback segments
10. Lock contention 11. Tuning Oracle 12. Shared server application
13. Tuning SQL statements 14. Tuning the operating system  

Technology Exchange Websites
SYS-ED websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer in a variety of delivery formats: web-based training, classroom instruction, technology updates, courseware, training aids, learning paths, and validation assessment.