Oracle8
This series introduces users to the Oracle 8 relational database management system. It examines its main components and installation, and discusses concepts related to database design, creation, and management, including creating, modifying, and managing tablespaces. Management of files and user accounts is also examined, along with table views and indexes. Advanced topics covered in this series include Oracle processes, job queues, and security monitoring. Data backup and recovery and database replication are also discussed in detail.
This series is for anyone who is interested in learning about the Oracle8 relational database management system, its main components, and how to install it. This online course contains 7 lessons and should take approximately 30 hours to complete.
Installing Oracle
This course introduces users to Oracle administration and shows how to install Oracle8 and teaches you how to define the job of Oracle Administration, explain basic Oracle operation, list the factors that affect Oracle performance, prepare for Oracle installation, install Oracle, and identify the major components of Oracle.
Database Management
This course shows users how to manage the Oracle8 databases and servers and teaches you how to plan for database capacity and size, calculate the system requirements of a database and server, calculate the disk requirements of a database and server, manage a database, use Server Manager and Database Assistant, start and shut down instances of databases, and connect to and modify instances of databases.
Building Databases
This course shows users how to create and set up new Oracle databases and teaches you how to plan and design a database, prepare for a new database, create a new database and catalog, modify a database, create and modify tablespaces, and manage tablespaces.
Files, Data, and Users
This course shows users how to manage files, import and export data, and manage user accounts and teaches you how to use redo log files, describe control files and rollback segments, create user accounts, manage user accounts, and manage user roles.
Database Schema Objects
This course shows users how to manage tables and indexes and teaches you how to create tables, manage different table views and types, create indexes, and identify and use index types.
Processes and Security
This course explains server processes and discusses how to use Oracle security features and teaches you how to export and import data using Export/Import, load data using the SQL*Loader Utility, describe the types of Oracle processes, monitor Oracle processes, manage Oracle job queues, and use Oracle Auditing for security monitoring.
Backup and Recovery
This course shows users how to protect Oracle database data by creating and using backups It also shows them how to recover from hardware or software failure through various recovery and restoration processes and teaches you how to describe Oracle backups, configure systems for maximum protection of data, create backup and recovery strategies, back up databases, recover data from backups, and replicate databases.