The goal of this course is to cover oracle architecture and internal mechanisms such that participants are able to perform basic DBa tasks such as database creation, start up and shutdown, and database management. The course also covers oracle networking basics and the oracle utility programmes.
WHO SHOULD ATTEND?
The course is designed to provide oracle professionals with an in-depth understanding of the features of oracle including sql fundamentals, object-orientation, partitioning and advanced oracle features for the internet.
HOW PARTICIPANTS WILL BENEFIT
At the end of the course, participants will be able to
• Explain the roles and duties involved in oracle database management and administration;
• Perform oracle dba tasks.
Sql fundamentals; architecture & configuration; instance architecture; oracle instance internals; using sql for dba management; control file; undo and redo management; user and privilege
management; oracle database management; initialization file managemen; oracle*net configuration, data buffer configuration & sizing, oracle object management; oracle indexes; oracle constraints; schema; file & table space management; database maintenance, oracle dba utilities; monitoring oracle; dictionary and v$ views, table & index monitoring; workload & trend monitoring; instance monitoring; oracle environment monitoring; statspack and awr performance management; performance management; bottleneck performance analysis; instance tuning; sql and cbo behavior; tracing sql execution; sql execution internals; sql tuning; oracle high availability tools, backup & recovery.