Oracle 9i Database Fundamentals 1Z1-031
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 TOOLSIntroduces 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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Syllabus
ORACLE ARCHITECTURE AND TOOLSIntroduces 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.
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.