For registration instructions, please click here . Develop skills necessary to effectively interact with an Oracle 8i database. Demonstrations and hands- on practice reinforce the fundamental concepts. A continuation of the materials started in the Introduction to SQL course. Enforce business rules within the database and perform value based auditing.
Participants have the opportunity to gain practical hands-on experience.
Participants will learn the key tasks and functions required of a database administrator. After an introduction to the Oracle 8i Server architecture, participants will learn how to create and start up a database, add users, manage data, expand the size of the database, and implement basic security and data integrity measures. Participants will also learn how to manage logical and physical storage structures and manage access to data integrity measures. Introduction to the critical task of planning and implementing database backup and recovery strategies. Participants will examine various backup, failure, restore and recovery scenarios that apply to the Oracle 8i database environment.