Oracle Database Administrator Training Programs

Oracle Training Programs

Oracle Database Administrator

Home
     

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

SYS-ED’s Oracle training programs utilize the full complement of delivery medium - traditional, web-based, and technology driven classrooms.

The client organization selects the modules to comprise the training program which are then tailored to specific training needs and operational objectives. The Oracle courses which comprise a program do not have to be conduced on consecutive weeks and can be coordinated with project requirements. At the client's discretion, validation assessment and a final examination can be utilized.

Oracle Database Administrator
Module Duration


Oracle Web Server for Administrators and Developers Training Program

Traditional Classroom Training


Oracle Database Administrator Training Program

Blended Content Delivery
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
Module: Oracle: SQL - Introduction
Duration: 2 days
Audience: Database administrators - DBA, designers and application programmers
Prerequisites: Windows operating system
Topics:
1. SQL select statements 2. Data: restricting/sorting 3. Single-row functions
3. Multiple tables 5. Displaying data 6. Group functions
7. Subqueries 8. Readable output with ISQL*Plus 9. Data manipulation
10. Table: creation/management    
Module: Oracle: Database Administration
Duration: 3 days
Audience: Database administrators - DBA
Prerequisites: SQL
Topics:
1. Architecture and components 2. Oracle Server 3. Instance management
3. Database creation 5. Data dictionary 6. Control file maintenance
7. Redo log files 8. Tablespaces data files 9. Storage structure relationships
10. Table management 11. Index management 12. Data integrity
13. Password security 14. User management 15. Privilege management
16. Role management    
Module: Oracle: Database Administration - Advanced
Duration: 3 days
Audience: Database administrators - DBA
Prerequisites: Oracle administration
Topics:
1. Oracle .NET architecture 2. .NET server-side configuration 3. .NET services client-side configuration
3. Oracle shared server 5. Backup recovery 6. Instance media
7. Recovery structures 8. Database archiving mode configuration 9. Recovery Manager
10. User-managed backups 11. RMAN backups 12. User-managed complete recovery
13. RMAN 14. Recovery catalog 15. Transporting data between databases
16. Loading data into a database    
Module: Oracle: PL/SQL Programming
Duration: 4 days
Audience: Database administrators, designers, and application programmers
Prerequisites: SQL: Structured Query Language
Topics:
1. PL/SQL fundamentals 2. Data manipulation 3. DML statements
3. Retrieval of data with cursors 5. Well-structured and error free code 6. Error-handling using exceptions
7. PL/SQL blocks debugging 8. Maximum reusability 9. Stored procedures and functions
10. Package creation 11. Event-driven code as triggers 12. Complex datatypes
13. Record and object types 14. Collection types 15. Bulk binding for high performance
16. Native dynamic SQL 17. Dynamic SQL - types 18. Cursor variables
19. Cursor variables - passing to other programs 20. Package tips and techniques 21. Maintainable application design
22. Invoking PL/SQL from other programs    
Module: Oracle: Performance and Design
Duration: 4 days
Audience: Database administrators - DBA, designers and application programmers
Prerequisites: Database administration and SQL
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's technology exchange 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.

http://www.oracletrainingbysysed.us/commquests.htm
www.xmltrainingbysysed.us www.unixtrainingbysysed.us
www.msnetworkstrainingbysysed.us www.mqseriestrainingbysysed.us

www.javatrainingbysysed.us

 www.dotnettrainingbysysed.us

http://www.sysed.com/tech_assessments/leader/internet_programming.asp