What's New

The Wait for Visual Studio 2008 is Over!

One may picture, too, the sudden shifting of the attention, the swiftly spreading coils and bellyings of that blackness advancing headlong,...

Oracle9i Database Administration Fundamentals I

Oracle9i DBA Fundamentals I
Course ID: D11321_TCC | Duration: 5 Days
Class times are from 9 A.M. to 5 P.M.
Description:
This course is designed to give the Oracle database administrator (DBA) a firm foundation in
basic database administrative tasks. Students gain a thorough conceptual understanding of the
Oracle database architecture, and how the architectural structures of an Oracle9i database work
and interact with one another. Students also learn how to create an operational database, and
properly manage the various structures in an effective and efficient manner in order to have a
well-designed logical and physical database. In addition to learning the various commands
needed to perform the DBA tasks, the course also provides students with instructions to perform
the same DBA tasks using the Oracle Enterprise Manager tool. The instructor-led lesson topics
are reinforced with structured hands-on practices.
Audience:
? Technical Support Professionals
? System Administrators
? Database Administrators
Required Prerequisites:
None
Suggested Prerequisites:
? Introduction to Oracle9i: SQL, Early Adopter
? Introduction to SQL (5 days)
Course Objectives:
? Create an operational database
? Start up and shut down an Oracle instance
? Manage Oracle physical database files
? Manage Oracle logical database structures
? Manage Oracle users, privileges, and resources
? Use Global Support features
? Outline the Oracle9i architecture
Course Topics:
Oracle Architectural Components
? Understanding the physical structure
? Understanding the memory structure
? Understanding the process structure
? Understanding the logical structure
? Outlining the stages of an SQL statement
Getting Started with the Oracle Server
? Identifying database administrative tools
? Identifying the features of the Universal Installer
Managing an Oracle Instance
? Managing PFILE and SPFILE initialization files
? Identifying the states of starting an instance
Creating a Database
? Using the Database Configuration Assistant to create a database
? Creating a database manually
Using the Data Dictionary
? Identifying the uses and contents of the data dictionary
? Using the data dictionary to obtain information about the database
Maintaining the Control File
? Explaining the uses of the control file
? Listing the contents of the control file
Maintaining Redo Log Files
? Explaining the use of online redo log files
? Explaining the structure of online redo log files
Managing Tablespaces and Data Files
? Outlining the database storage hierarchy
? Identifying the types of tablespaces
Storage Structure and Relationships
? Outlining the various segment types and their uses
? Outlining the storage clause precedence
?
Managing Undo Data
? Understanding the purpose of undo data
? Managing undo data
Managing Tables
? Outlining the various Oracle data types
? Explaining the two types of ROWID formats
??
Managing Indexes
? Classification of types and uses indexes
? Creating b-tree and bitmap indexes
Maintaining Data Integrity
? Identifying the various types and states of constraints
? Implementing data integrity constraints
?
Managing Password Security and Resources
? Managing passwords using profiles
? Administering profiles
Managing Users
? Defining database schema and objects
? Creating new database users
?
Managing Privileges and Roles
? Identifying system and object privileges
? Granting and revoking privileges
Using Globalization Support
? Choosing character set and national character set for a database
? Specifying the language -dependent behavior
?
Suggested Next Courses:
Please check with your Education Representative to determine the appropriate follow up
course.
Related Courses:
? Oracle 8i Database Administration:Manage an Instance
? Oracle 8i Database Administration: Create a Database
? Oracle 8i Database Administration: Manage Storage Structures
? Oracle 8i Database Administration: Manage Data Storage
? Oracle9i New Features: Database Administration

AttachmentSize
Oracle 9i DBA Fundamental I.pdf20.3 KB
Code: 
9i DBA1
Duration: 
5
Price: 
6000000
Schedule: 
Available Upon Request