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.

Topic Covered

  • 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

Audience:

     Before beginning this course, students should have a working knowledge of both SQL and PL/SQL.

Prerequisites:

     Before beginning this course, students should have a working knowledge of both SQL and PL/SQL.

Benefits:

     Students will learn how to create and manage an Oracle 10g database.

Furnished Materials:

Recommended Follow-On Course

Length:

  • 5 Days

Price:

  • $2,475

Sign Up