Oracle9i Database Fundamentals 1Z1-031:Managing Instances and Creating Databases
Product Code: OR3102 Time: 3 Hour(s) CEUs: .30

Summary:

This course introduces users to managing an Oracle instance, creating a database, and using globalization parameters.

Objectives:

After completing this course, students will be able to:
  • Create and manage an initialization parameter file
  • Configure Oracle-managed files
  • Use the startup command
  • List the different options available for starting Oracle
  • Shut down an Oracle instance
  • Describe the two types of diagnostic files used in Oracle
  • List the prerequisites necessary for database creation
  • List values that must be set in the parameter file
  • Use the Database Configuration Assistant
  • Create a database with the create database command
  • Define a character set for your database
  • Configure language-dependent behavior for the your database
  • Retrieve NLS information from the your database

Outline:

  • Creating an Initialization Parameter File
  • Configuring Oracle-Managed Files
  • Starting an Instance using SQL*Plus
  • Startup Methods and Options
  • Shutting Down an Instance
  • Using Diagnostic Files
  • Planning for Database Creation
  • Preparing the Parameter File
  • Using the Database Configuration Assistant
  • Creating a Database Manually
  • Choosing a Character Set
  • Specifying Language-Dependent Behavior
  • Viewing Globalization Support Information

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Activities that allow users to apply course concepts in an interactive questioning environment
  • A glossary
  • A Skill Assessment

Applicability:

This course is for anyone preparing for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Prerequisites:

Experience working with relational database systemsCourses on SQL or equivalent experienceGeneral knowledge of networkingOracle9i Database Fundamentals 1Z1-031: Oracle Architecture and Tools

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Oracle® and Oracle9i™ are trademarks of Oracle Corporation.

Terms of Use:

None

Copyright © 2004 eLearningDepot.com. All rights reserved.