Oracle 9i Database Fundamentals 1Z1-031

Product type

Oracle 9i Database Fundamentals 1Z1-031

Elearn UK
Logo Elearn UK
Provider rating: starstarstarstarstar 10 Elearn UK has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Description

This series is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z1-031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.

Syllabus

ORACLE ARCHITECTURE AND TOOLS

Introduces users to the major components of an Oracle server.
  • Oracle Server Architecture
  • The Server Process
  • Connecting to Oracle Servers
  • Processing Queries
  • Processing DML Statements
  • Processing Commit Stat…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

This series is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z1-031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.

Syllabus

ORACLE ARCHITECTURE AND TOOLS

Introduces users to the major components of an Oracle server.
  • Oracle Server Architecture
  • The Server Process
  • Connecting to Oracle Servers
  • Processing Queries
  • Processing DML Statements
  • Processing Commit Statements
  • Common Database Administration Tools
  • Oracle Universal Installer
  • Installing Oracle9i Database
  • Optimal Flexible Architecture
  • Oracle Authentication
  • Using Operating System Authentication
  • Using Password File Authentication
  • Oracle Enterprise Manager Components

MANAGING INSTANCES AND CREATING DATABASES

Introduces users to managing an Oracle instance, creating a database, and using globalization parameters.
  • 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

MANAGING THE DATABASE STRUCTURE

Introduces users to data dictionaries, control files, and redo log files.
  • Constructing Data Dictionary Views
  • Tables and Views
  • Data Dictionary Contents
  • Querying the Data Dictionary
  • Using Control Files
  • Control File Contents
  • Using Oracle-Managed Files
  • Viewing Control File Information
  • Multiplexing Control Files
  • Redo Log Files
  • Controlling Log Switches and Checkpoints
  • Maintaining Redo Log Files
  • Using OMF to Manage Redo Log Files

MANAGING TABLESPACES AND DATAFILES

Introduces users to creating and managing tablespaces.
  • Oracle's Logical Structure
  • Understanding Tablespaces
  • Creating Tablespaces
  • Changing Tablespace Size
  • Using Temporary Segments
  • Managing Uniform Extent Sizing
  • Changing Tablespace Status
  • Changing Tablespace Storage Settings
  • Using OMF with Tablespaces

MANAGING STORAGE STRUCTURES AND UNDO DATA

Introduces users to the underlying storage structure of a database and to using undo segments.
  • Types of segments
  • Acquiring and managing segments and extents
  • Controlling block space usage
  • Obtaining information about storage structures
  • Using undo data
  • Implementing automatic undo Management
  • Creating, configuring, and maintaining undo Segments manually

MANAGING TABLES

Introduces users to creating and managing table structures.
  • Storing Data
  • Distinguishing Oracle Datatypes
  • Extended and Restricted ROWIDs
  • Row Structure
  • Creating Permanent and Temporary Tables
  • Managing Storage Structures
  • Managing Tables
  • Dropping Columns

MANAGING INDEXES AND DATA INTEGRITY

Introduces users to indexes and data integrity constraints.
  • Index Types
  • Function-Based and Descending Indexes
  • Creating B-Tree and Bitmap Indexes
  • Reorganizing Indexes
  • Dropping Indexes and Getting Index Information
  • Monitoring Use of Indexes
  • Implementing Data Integrity Constraints
  • Using Deferred Constraints
  • Maintaining Integrity Constraints
  • Obtaining Constraint Information

MANAGING USERS AND PROFILES

Introduces users to creating and managing users and to control resources using profiles.
  • Creating New Users
  • User Account Guidelines
  • Altering and Droping Existing Users
  • Monitoring User Information
  • Controlling Resource Use with Profiles
  • Administering Profiles
  • Administering Passwords Using Profiles
  • Obtaining Profile Information

MANAGING PRIVILEGES AND ROLES

Introduces users to system and object privileges and user roles.
  • System Privileges
  • Special and Object Privileges
  • Granting and Revoking Privileges
  • Granting Administrative Abilities
  • Identifying Audit Capablitities
  • Using the Audit Command
  • Managing Auditing
  • Creating and Modifying Roles
  • Controlling Availability of Roles
  • Using Predefined Roles
  • Displaying Role Information

EXAM PREPARATION

Allows users to practice answering questions in order to prepare for taking the exam.
  • This course covers all of the objectives for the certification exam

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.

There are no reviews yet.
  • View related products with reviews: Oracle.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.