Home > Training > Internet Database Operator

Oracle8i Internet Database Operator - NT

Duration:	32hrs
Price:	$750.00
Training Method:	Instructor-led Training
Class Schedule	Weekdays, Evenings & Weekends

Description:

This course is a Quickstart introduction to operating an Oracle database on a Windows NT platform. It introduces students to the essential tasks that confront database operators and support personnel who have to quickly set up and operate a production Oracle database in a Windows NT environment. The focus is on the database as opposed to specific operating system tasks. Students gain practical experience installing and operating an Oracle database to support departmental database applications. Using a variety of Oracle tools, students learn to anticipate and solve common problems associated with operating an Oracle database, perform common administration tasks, and set up the Oracle WebDB tool to monitor Web databases and applications.

The class consists of demonstrations and hands-on exercises for performing daily operator tasks. Throughout the course, the instructor demonstrates the tasks an operator would perform on the Oracle database. A strong emphasis is on using the Oracle Enterprise Manager tool. The target audience for this course is support personnel who do not need an in-depth understanding of the underlying Oracle architecture or require detailed database administration training but are often tasked with providing support for departmental Oracle databases that may also support end-user applications.

This course is designed to prepare you for the corresponding Oracle Certified Professional exam: Exam #1Z0-411.



Prerequisites:

Fundamental understanding of SQL for purposes of performing basic queries against the database

Course Objectives:

Create a new Oracle database
Describe the use of an Oracle database
Implement new applications in an Oracle database
Load non-Oracle data into an Oracle database
Perform administrative tasks using Oracle WebDB Administer
Perform periodic controls to anticipate well-known issues
Recover an Oracle database
Set up Oracle WebDB
Set up Oracle users and assure security access to the data
Upon completion of this course, students should be able to:
Give access to Oracle databases
Install the Oracle database software
Perform common administrative tasks using Oracle Enterprise Manager applications
Recognize Oracle databases running on a machine
Set up periodic backups of Oracle databases

Course Topics:

What is an Oracle Database?

Which Tools Are Used to Access an Oracle Database?

What Are the Duties of an Oracle Database Operator?

How to Install Oracle Database Software

How to Create an Oracle Database and Services

Where to Find Other Important Oracle Files

How to Detect if the Oracle Databases are Running

How to Administer Network, Server Services, and Oracle Enterprise Manager

How to Start an Oracle Database

How to Stop an Oracle Database

How to Implement the Logical and Physical Storage Structure for New Applications

How to Implement the Rollback Segments for New Applications

How to Set Up Users for a New Application

How to Create Objects to Store the Application Data

How to Secure Application Data Manipulation

How to Load Non-Oracle Data

Why and When to Back Up Databases

When and How to Recover a Crashed Database

How to Anticipate Issues

How to Set Up Oracle WebDB Software


Suggested Next Courses:

Oracle8i Database Architecture and Administration
Oracle8i Database Backup & Recovery