Database Creation and Architecture is designed to give students a firm foundation in basic Oracle8 database administrative tasks. Students will gain the necessary knowledge and skills to set up, maintain, and troubleshoot an Oracle8 database. Managing Users and Connectivity provides students with the skills they need to manage Oracle database users and their database access. Course Syllabus 3. Managing Database Objects focuses on the database structures within an Oracle database.
Topics covered include management of space, tables, and constraints, and the use of indexes.
Students will also learn how to manage object privileges, use roles to simplify security, and create and manage stored code. Course Syllabus 4. Administrative Tasks teaches students how to monitor a database, manage its physical structure, and use the import, export, and loader utilities. Students will also learn to manage the physical aspects of an Oracle database and gain an understanding of the most critical performance metrics that should be monitored. Course Syllabus 5.