The eLearning Center for Gatlin Education Services

Oracle9i: Database Fundamentals I

Course Type: Self-paced Courses
Estimated Time of Completion: 17 hour(s) 14 minutes
CEU Credits:
Language: English

Description: The Oracle9i Database Fundamentals I course will enable you to describe the basic Oracle9i architecture and how objects are stored in the database. This course will also enable you to manage several aspects such as an Oracle instance, datafiles, tables, and users. Your can maintain the online redo log and the control files. You will also be able to describe globalization support.
Objectives:

  · In this course, you will be introduced to the responsibilities of an Oracle® database administrator (DBA). You will explore the underlying architecture of the Oracle database server and the essential tasks required to manage database installations such as how to start up and shut down an Oracle instance. You will also explore the components that comprise a database, practice creating a database, manage database objects, reorganize data, and implement security measures. Finally, you will explore how to troubleshoot real-life scenarios that could occur.

Hardware and Software Required:

  · Browser Netscape Communicator 4.0
  · Browser Other: AOL 4.0
  · Operating System MacOS 8.5
  · Browser Microsoft Internet Explorer 4.0
  · Operating System MS-Windows 95

Content Outline:

Course Introduction
Course Introduction

Overview Of Oracle9i Architecture
Lesson Introduction
Database Architecture
User Processes
Resources for the DBA
Lesson Lab Reviewing Overview of Oracle9i Architecture
Lesson Followup

Understanding the Oracle Instance
Lesson Introduction
Overview of Database Creation
Creating a Database with the Database Configuration Assistant
Logical and Physical Structures
Database Objects and Their Storage
Managing the Database Instance
Obtaining Instance Information
Lesson Lab Reviewing How to Understand the Oracle Instance
Lesson Followup

Managing Tablespaces and Datafiles
Lesson Introduction
Managing Tablespaces
Resizing and Moving Tablespaces
Overview of Oracle Managed Files
Lesson Lab Reviewing How to Manage Tablespaces and Datafiles
Lesson Followup

Managing Tables and Indexes
Lesson Introduction
Creating and Managing Tables and Their Physical Storage Characteristics
Querying the Data Dictionary
Indexes and Their Uses
Creating and Maintaining Indexes
Implementing Integrity Constraints
Enabling and Disabling Constraints
Lesson Lab Reviewing How to Manage Tables and Indexes
Lesson Followup

Managing Undo Data
Lesson introduction
Overview of Rollback Segments
Implementing Automatic Undo Management
Lesson Lab Reviewing How to Manage Undo Data
Lesson Followup

Managing the Online Redo Log and the Control File
Lesson Introduction
Overview of the Online Redo Log
Planning and Configuring the Online Redo Log
Managing and Maintaining the Control File
Lesson Lab Reviewing How to Manage the Online Redo Log and the Control File
Lesson Followup

Managing Users and Security
Lesson Introduction
Managing Users
Managing Privileges and Roles
Managing Passwords and Profiles
Lesson Lab Reviewing How to Manage Users and Security
Lesson Followup

Globalization Support
Lesson introduction
Overview of Globalization Support
NLS Parameters
Lesson Lab Reviewing Globalization Support
Lesson Followup

Course Follow Up
Course Follow Up