This hands-on course provides students with the fundamental skills to create, maintain and manage an Oracle 9i database. The class will focus on day-to-day duties of an Oracle DBA, such as managing users and security, space management, creating database objects (tablespaces, tables, indexes) and backup and recovery. The Oracle 9i database architecture is discussed in great detail. This course provides the foundation of knowledge for new Oracle DBAs but does not cover database tuning.
|
Class Agenda:
- Introduction to the Oracle data dictionary
- Oracle 9i Database architecture
- Creating administrative users
- Starting and shutting down an Oracle instance
- Initialization parameter files
- Creating and managing users
- Introduction to auditing
- Managing security
- Creating and managing Tablespaces
- Creating and managing Tables
- Creating and managing Constraints
- Creating and managing Indexes
- Managing Undo Space
- Managing Redo Logs
- Managing Control Files
- Introduction to Backup and Recovery
- Introduction to Oracle Utilities
- Introduction to Oracle Networking
- Creating a new database
|
Prerequisites:
- Before beginning this course, students should have a working knowledge of both SQL and PL/SQL.
Audience:
- Database and System Administrators.
Course Benefits:
- Students will learn how to create and manage an Oracle 9i database.
Materials Furnished:
Recommended Follow-on Courses:
- Oracle 9i PL/SQL Fundamentals
- Oracle 9i Advanced SQL
Course Length:
List Price: $2475 |
