|
Installing and Managing Oracle 10g CBT Training
Product Code:MC-Oracle10gfs
Price : $745.00
Sale Price : $595.00
Product Options
- Single User License
- MultiUser Site License Add $595.00
Detailed Description
Installing and Managing Oracle 10g - This course teaches the fundamental skills for managing an Oracle database environment. Students will learn now to install Oracle software, setup a new database, manage users, manage storage, manage security, add software patches and the management of data. The emphasis is on teaching someone new to an Oracle environment how to successfully manage an Oracle database. The Oracle Installer and Oracle Enterprise Manager (OEM) wizards and graphical user interfaces will be used to simply the introduction to an Oracle environment. By the end of class attendees will have gone through the main tasks required to manage an Oracle database environment.
Included in this Program
- 6 course CDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Oracle 10g Installation review questions
- Printable Courseware in PDF format
- Certification of Completion
Course Outline
Lesson 1
Installing an Oracle Database
The Oracle Universal Installer
Oracle10g Standard Edition
Following Best Practices
Optimal Flexible Architecture (OFA)
Installation Options
Steps for Creating an Oracle Database
The Database Creation Assistant (DBCA)
Defining Installation Options
The Installation Process
Creating the Oracle Database
Validating the Installation
Level 2
Understanding the Oracle Environment
Introduction to Oracle Enterprise Manager (OEM)
Using OEM to Manage Your Oracle Environment
Features of OEM
Main Components of OEM
The OEM Central Console
The Main Components of an Oracle Instance
Managing Oracle Memory
Oracle Database Files
Different Database Files
Oracle Storage Options
Understanding How Oracle Works
Oracle Concepts & Terminology
Oracle Networking Software
Overview of Oracle Products & Tools
SQL *Plus
SQL Worksheet
SQL Scratchpad
The OEM Web Site
Level 3
Using OEM for Database Management
Starting Up an Oracle Instance & Database
Shutting Down an Oracle Instance & Database
Creating Database User Accounts
Managing Database User Accounts
Managing Default User Accounts
Implementing Password Management
Understanding Oracle Security
System and Object Privileges
Granting & Revoking Privileges
Working With Roles
Creating a Simple Backup
Lesson 4
Managing Memory & the Oracle Instance
Using OEM to Manage Oracle Memory
Initialization Files
Using an SPFILE
Using an init.ora File
SPFILE or init.ora File
Oracle Network Services
Changing Oracle Memory & Configurations
Using an Oracle Dedicated Server
Using an Oracle Shared Server
Performing Normal Maintenance on an Oracle Instance
Oracle Network Services
Setting up Oracle Networking
Using Oracle Net Manager to Manage Listeners
Testing Oracle Networks
Customizing the Library |
Lesson 5
Managing & Configuring the Oracle Database
Understanding an Oracle Database
Database Configuration Options
Setting Up Data Files
Setting Up Control Files
Creating Redo Log Groups
Managing Redo Log Groups
Creating Redo Log Members
Managing Redo Log Members
Mirroring Redo Log Members
Setting Up Control Files
Mirroring Control Files
Adding Data Files
Modifying Data Files
Moving Database Files
Removing Control Files
Removing Redo Log Groups
Removing Redo Log Files
Lesson 6
Managing Storage & Schemas
Data Fuiles Versus Tablespaces
Setting Up Storage for Applications
The System Tablespace
Data Tablespaces
Index Tablespaces
Undo Tablespaces
Temporary Tablespaces
Additional Tablespaces
Adding Database Storage
Modifying Database Storage
Adding Data Files
Modifying Data Files
Adding/Removing Control Files
Adding/Removing Redo Log Groups
Adding/Removing Redo Log Files
Working With Tables
Table Maintenance
Working With Indexes
Index Maintenance
Managing Schema Objects
|
|
