Oracle Courses Database Administration (Oracle DBA) includes the following topics:

Oracle Architectural Components

  • definition of the Oracle database, server and Oracle instance,
  • establishment of a connection and creation of a session,
  • overview of the physical structure,
  • overview of the memory structure,
  • overview of the process structure,
  • overview of the logic structure.

Getting Started with Oracle

  • Oracle administration tools,
  • properties of the Oracle Universal Installer
  • users of the system,
  • authentication through a password file,
  • SQL*Plus tools and Enterprise Manager.

Managing Oracle instance

  • creation, management and application of instance files: PFILE i SPFILE,
  • overview of different ways of starting the instance,
  • overview of different ways of stopping the instance,
  • alert file and TRC files.

Creating a database

  • creating a database during installation,
  • creating a database manually from the scripts.

Database dictionary

  • overview of the application and use of data dictionary,
  • obtain information on the basis of data from the data dictionary.

Control file

  • the use of control file,
  • the content of control file,
  • multiplying the control file,
  • obtaining the information about a control file.

Log files

  • overview of how the log files work and how to use them,
  • switching current log files and checkpoint operations,
  • management of current log files,
  • multiplying the current log files,
  • archiving the current log files,
  • obtaining the information about current and archived log files.

The management of table spaces and arrays of data files

  • overview of the hierarchy of disk storage,
  • System and non-system table spaces,
  • the creation and management of tables,
  • obtaining of the information on areas of data files and tables.

The elements of data storage

  • description of logical structures of the database (segments, extents, blocks,
  • types of segments and their applications,
  • overview of application extents, allocation and deallocation,
  • overview of the structure of the data block,
  • management of storage structures - manual management,
  • automatic segment management,
  • obtaining the information about the storage structures.

Management of withdrawal data

  • Automatic Undo Management and Manual Undo Managment,
  • the creation and management of UNDO tables,
  • obtaining the information about the withdrawal.

Tables and index management

  • creating tables,
  • redefining tables,
  • moving tables,
  • obtaining the information on tables,
  • overview of the types of indexes,
  • managing indices,
  • monitoring indexes,
  • obtaining information on indexes.

Integrity management

  • types of restrictions,
  • states of restrictions,
  • creating restrictions,
  • activation and deactivation of restrictions,
  • obtaining the information on restrictions.

Managing the password security and resources

  • password management by profiles,
  • blocking of the account,
  • the lifetime of a password,
  • password history,
  • verification function,
  • management by profiles,
  • obtaining the information on passwords configuration and limits of resources.

User Management

  • database user and a schema of the database,
  • creating user,
  • authentication by the database,
  • authentication by the operating system,
  • the limit on table spaces,
  • obtaining the information on users.

Management of privileges

  • system privileges,
  • SYSDBA and SYSOPER privileges,
  • object privileges,
  • obtaining information on privileges.

Managing roles

  • discussion of the use of roles,
  • creating roles,
  • predefined roles,
  • modifying roles,
  • application roles,
  • activation and termination of roles,
  • obtaining information on roles.