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.
SYS-ED's
training programs utilize the
full complement of delivery medium: distance-learning, web-based, and
technology driven classrooms. As part of conducting a training program, courseware is organized for utilization in courseware as a learning center. In order to accommodate employee workloads and staff in remote geographic locations, component courses can be scheduled over non-consecutive weeks utilizing a combination of classroom training and
distance-learning. At the client's discretion, checklist of completed tasks,
validation assessment, and a final examination can be utilized.
|
Module: |
Oracle: SQL - Introduction |
|
Duration: |
2 days |
|
Major Topics: |
| 1. TSQL 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 and management |
|
|
|
|
Module: |
Oracle
11g: Database Administration |
|
Duration: |
3 days |
|
Major Topics: |
| 1. Oracle featureset |
2. Tasks of an Oracle database administrator |
3. Managing the Oracle instance |
| 3. 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 |
6. 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 |
| 3. 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
11i: 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 |
|
|
Review Additional Content
The
course search engine can be utilized for researching hybrid implementations of Java with commercial and free open source combinations of software: operating systems, web servers, development platforms, and
databases.
The audience, duration, and content can be
used to review and augment an integrated training program and evaluate alternative fast-track courses.
|
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. |
|
http://www.oracletrainingbysysed.us/commquests.htm |