| Oracle Database Administration |
| |
| This hands-on course provides students with the fundamental skills to create, maintain and manage an Oracle 10g 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 10g database architecture is discussed in great detail. This course provides the foundation of knowledge for new Oracle DBAs but does not cover database tuning. |
|
| Covered Topics: |
- Introduction to the Oracle data dictionary
- Oracle 10g 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: |
|
Before beginning this course, students should have a working knowledge of both SQL and PL/SQL. |
|
| |
| Course Benefits: |
| Students will learn how to create and manage an Oracle 10g database. |
| Materials Furnished: |
|
| Recommended Follow-On Course: |
- Oracle 10g PL/SQL Fundamentals
- Oracle 10g Advanced SQL
|
|
|
|
|
|
