| Oracle
8i DBA - Introducing Procedure Builder
This course aims to introduce you to the various components of
Procedure Builder. It explains the features of the Procedure Builder
components, such as the Object Navigator, the PL/SQL Interpreter,
the Program Unit Editor, the Stored Program Unit Editor, and the
Database Trigger Editor. It describes how you can use the components
of Procedure Builder to create, debug, and execute program units.
Introducing Procedure Builder training covers such topics as:
Procedure Builder Fundamentals
Subprograms
Debugging Program Units Oracle 8i DBA - Oracle Server and Database Architecture
This course familiarizes you with the basics of Oracle 8i Architecture
and Oracle Enterprise Manager. This course will introduce you to
Oracle instances and SGA components. You will learn to identify
the memory structures and processes involved with an Oracle instance.
You will be introduced to the Oracle Universal Installer and be
able to explain the Optimal Flexible Architecture. You will be
able to implement a database server, with user validations and
user database accounts. You will become familiar with the components
of the Oracle Enterprise Manager, the Configuration Assistant,
and the tools of the DBA management pack. You will learn how to
connect to an Oracle database and to identify the different stages
of the SELECT query, DML, and COMMIT statements.
Oracle Server and Database Architecture training covers such topics
as:
Oracle Architecture
Implementing the Database Server
Oracle Enterprise Manager
Interacting with the Database
Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure
The course familiarizes you with the Oracle instance. It teaches
you about the startup and shutdown processes and the different
stages of startup and shutdown. The course also provides a list
of data dictionary views that help in performing administrative
tasks. The course initiates the learner into hands-on learning
by helping you type in the commands used to perform administrative
tasks.
Oracle Instance, the Start-up and Shutdown Procedure training
covers such topics as:
Oracle Instances
Controlling Oracle at Runtime
Creating Databases The course addresses the training needs of IT Professionals who
use Oracle 8i. This course also addresses the needs of IT professionals
who want to become
certified under the Oracle8i Certified Database Administrator (DBA) Track.
Completion of this course and the other course titles from this
curriculum prepares the learner for Oracle Exam #1Z0-001: Introduction
to Oracle: SQL and PL/SQL |