Oracle course introduction: 1Z0-001 Introduction to Oracle: SQL & PL/SQL Using Procedure Builder Learn how to design and establish a database structure 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 Forms, Reports, and data management applications.) use Oracle Procedure Builder to develop and debug PL/SQL programs. 1Z0-013 Oracle Database Administration Acquire the necessary knowledge and skills to set, maintain, and resolve Oracle7 or Oracle8 database faults. 1Z0-015 Oracle Backup and Recovery Workshop 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 ). 1Z0-014 Oracle Performance Tuning Workshop Explain a series of steps that can be used to improve the performance of Oracle8 servers. This course focuses on the Performance of databases rather than specific operating systems. Through the demo, the students will gain practical experience in debugging the Oracle database. The students will also learn how to confirm, exclude, and resolve common performance-related issues in managing Oracle databases. 1Z0-016 Oracle Network Administrator 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. 1Z0-101 Develop PL/SQL Program Units Learn how to write PL/SQL, functions, and packages. In the Procedure Builder and SQL Plus environments, learn how to create and manage PL/SQL program units and database triggers. You also need to learn how to use some packages provided by Oracle. 1Z0-123 Developer/2000: Build reports Learn how to use Developer/2000 Reports in a client/server environment to create a variety of standard and Custom Reports. The exercises in the course give students an idea of how to query, display, and format data in different report styles (such as tables, disconnections, primary/secondary tables, columns, and letter reports. 1Z0-121 Developer/2000: Build Forms I Create and test an interactive application consisting of one or more Developer/2000 Forms modules. In a graphical user interface (GUI) development environment, students can use Developer/2000 to create a complete Forms application. How to adjust Forms containing graphical user input items. 1Z0-122 Developer/2000: Build Forms I Improve your skills in using Developer/2000 Forms. Students will learn complex concepts and practice how to use programming function keys, timers and record groups, and how to use programming controls to manage the behavior and display of runtime windows. 1Z0-401 Oracle Database Operator Learn about Oracle 8 Database Management Based on Windows NT. Master the usage and operation of Oracle databases, create databases, create user and role permissions, back up and restore Oracle databases, and perform basic management work using Oracle Enterprise Manager, load data from a non-Oracle database. |