Oracle course description

Introduction to Oracle: SQL and PL/SQL Using Procedure Builder:

This course will help students learn how to use Oracle tools and methods to meet actual enterprise information requirements. The hands-on exercises will allow students to learn how to design and build database structures, to save, retrieve, update, and display data in a relational database. The students will also learn how to compile PL/SQL blocks. (These PL/SQL blocks can be shared by FormsReports and data management applications) and the Oracle Procedure Builder tool is used to develop and debug PL/SQL programs.

Intended audience:

Oracle Database AdministratorApplication Administrator System Designer Web Application Developer

-----------------------------------

Oracle8i Database Administration:

This course will allow Oracle Database Administrators (DBAs) to lay a solid foundation for basic management tasks. Through instructor-guided, systematic practical practice and challenging lab, DBA will acquire the necessary knowledge and skills to set up, maintain and solve Oracle7 or Oracle8 database faults.

Intended audience:

Database administrators, application developers, technical support professionals, network administrators, and System Administrators

-----------------------------------

Oracle8i Backup and Recovery Workshop:

This course describes the key tasks for planning and implementing database backup and recovery policies. This course describes backup and recovery techniques and tests various backup, fault, recovery and recovery solutions. Backup, Recovery, and Recovery operations for the Oracle7 and Oracle8 database environments, as well as the Oracle8 Recovery Manager ). Through actual operations, students will practice the backup method based on the requirements of key tasks for enterprise businesses. Students will use a variety of policies and Oracle tools such as the recovery manager for backup, recovery, and recovery operations. This course also includes a one-day interactive lab exercise that gives students the opportunity to perform multiple practical backup, recovery, and recovery cases.

Intended audience:

System Administrator, Network Administrator, database administrator, application developer, technical support professional, designer/Developer

----------------------------------

Oracle8i Performance Tuning Workshop:

This course will explain a series of steps for improving the performance of Oracle8 servers. This course focuses on the Performance of databases rather than specific operating systems. By combining demos, presentations, online lab exercises, and slides, the students will gain hands-on experience in debugging the Oracle8 database. The students will also learn how to confirm, exclude, and solve common performance-related problems in managing Oracle8 databases.

Intended audience:

Network administrators, database administrators, application developers, system administrators, technical support professionals, designers/developers, and managers

----------------------------------

Oracle8i Network Administator:

Course description this course describes development trends and issues related to the business network and NET8 architecture. Trainees will learn how to identify network faults and how to develop solutions. In addition, you also need to learn how to use the naming method to establish the basic connection between the client and the server node. The student will configure and simulate a middle-layer system, such as Names Server and Connection Manager, and learn how to establish connections between peer-to-peer layers. You also need to learn how to configure the Intelligent Agent and Oracle8 server. Finally, this course will introduce security risks and describe and demonstrate utilities such as logging, tracing, and Trace Assistant. In addition, this course will often discuss network-related issues mentioned in Oracle Worldwide Support.

Intended audience:

Oracle8i Database Administrator