1, Introduction to Oracle9i: SQL (course number: 1Z0_007) The course has been widely introduced to access database server technology. In this course, the concept of relational database and object relational database is described in detail, and the SQL program language is described in multiple chapters. Here, everyone will learn more than 8i SQL, in addition to how to create, maintain database objects, how to store, retrieve, manipulate data, in 9i SQL, such as Rollup, Cube, Set operation, and Hierarchical Retrieval, and how to generate report output using the 9i new tool isql * plus. 2, Oracle9i DBA Fundamentals I (Course Number: 1Z0_031) This course is a basic course specializing in the database administrator. This course is to let Oracle database administrators to make a solid foundation for performing basic management tasks and provides the required Techniques and techniques are set, maintaining the operation of the database and resolving the Oracle9i database failure. Students will learn to use management tools to start, turn off databases, create databases, manage files, and data storage, and manage users and their privileges, and students will also learn to organize databases, migrate data between different databases. Hand practicing activities will help students to strengthen the understanding of key concepts, while students will get the opportunity to practice solve the problem that Oracle WorldWide Support is often encountered, so that problems in actual work. 3, Oracle9i DBA Fundamentals II (Course Number: 1Z0_032) This course describes how to implement database backup and recovery policies, information about NET Manager components, and learn how to configure simple to more complex Net Manager environments. Potential network security risks and Oracle optional security solutions for these issues will be displayed. The presentation will also include the interpretation of NET Manager debugging tools and debugging information. Most public errors and how to solve the contents of the Oracle network environment. This course will also take backup and recovery skills and will test various backups, faults, and recovery. In actual hands-on activities, students will test backup methods based on key companies, using multiple strategies and Oracle's various tools, and Recover Manager (Recovery Manager) to back up, restore, and resume operations. In this version of 9i, Oracle has greatly enhanced the functionality of Recover Manager. Students will have some more advanced technologies, such as developing the automatic expiration of Recover Manager and automatic delete strategies. In addition to teaching and practical learning methods, this course will also teach methods to solve the common problems of backup and recovery of Oracle Global Support. 4, Oracle9i Database Performance Tuning (course number: 1Z0_033) This course will introduce a series of steps for improving Oracle9i performance. Database performance adjustment mainly includes memory structure, background process and data storage three parts, and Oracle9i adds a lot of automatic management, such as automatic management of the back segment, and Oracle management data files, control files. The log files are different from 8i in the adjustment method. The focus of this course will be placed on the database, rather than special operating system performance, and the students will get practical database adjustment experience. Use various tools. Students will also learn how to identify, eliminate faults and resolve issues when managing databases, including problem diagnosis and performance enhancement.
