Oracle Database Administration:

Required Prerequisites:

Introduction to Oracle: SQL

Section 0: Review
Time Allocated - 6 ~ 9 hours

Basic Unix Knowledge
Vi Editor
Unix Access Control
Unix Environment Settings for Oracle Users
Frequently Used Unix Commands
Simple Korn Shell Scripting

Oracle SQL & PL/SQL
General statements (select, DML, DDL)
Procedures
Packages
Triggers
Oracle Supplied Packages
Oracle Error Facilities
Oracle Documentations
Oracle Software Overview

Oracle New features (SQL & PL/SQL)
SQL Enhancements Using Joins
SQL Enhancements on Constraints and LOB Migrations
Use the enhancements to LOBs and PL/SQL

PAGE1 pg2 pg3 pg 4 pg5 pg6 pg7 pg8 pg9 pg10 pg11 pg12 pg13 Next page >>