Oracle Database Administration

     This hands-on course provides students with the fundamental skills to create, maintain and manage an Oracle 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 database architecture is discussed in great detail. This course provides the foundation of knowledge for new Oracle DBAs but does not cover database tuning.

Topics Covered

  • Introduction to the Oracle data dictionary
  • Oracle 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 database.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course

Length:

  • 5 Days

Price:

  • $2,475

Training Dates:

Sign Up