Oracle9i: Database Fundamentals

ExecuTrain
Alpharetta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course 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 AOL 4.0
Operating System MacOS 8.5
Browser Microsoft Internet Explorer 4.0
Operating System MS-Windows 95

Table of Contents:

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


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Perl/CGI
PHP 4
Domino R5 Application Development
Domino R5 System Administration
VBScript
Understanding DB2
Visual Basic .NET
Visual C# .NET
XML
XML: XSL Transformation
Oracle Database 10g: Data Management and Security Enhancements
Adobe Atmosphere
Adobe FrameMaker 8.0
Adobe Fireworks CS3
Contribute CS3
Adobe InDesign CS2
Adobe Illustrator CS3
Adobe Indesign CS3
Adobe Premiere Pro CS3: Basic Video Editing

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.