Getting Started with Database Administration

To get started with database administration, you must understand basic database concepts, such as the types of database users, database security, and privileges. You must also be able to complete basic tasks, such as submitting commands and SQL to the database and creating a password file.

ibm infosphere datastage training courses malaysia

• Types of Oracle Database Users
  The types of users and their roles and responsibilities depend on the database site. A small site can have one database administrator who administers the database for application developers and users. A very large site can find it necessary to divide the duties of a database administrator among several people and among several areas of specialization.

ibm informix training courses malaysia

• Tasks of a Database Administrator
  You must complete several specific tasks to design, implement, and maintain an Oracle Database.
• SQL Statements
  The primary means of communicating with Oracle Database is by submitting SQL statements.
• Identifying Your Oracle Database Software Release
  As many as five numbers may be required to fully identify a release.
• About Database Administrator Security and Privileges
  To perform the administrative tasks of an Oracle Database DBA, you need specific privileges within the database and possibly in the operating system of the server on which the database runs. Ensure that access to a database administrator’s account is tightly controlled.

ibm cognos bi training courses malaysia

• Database Administrator Authentication
  As a DBA, you often perform special operations such as shutting down or starting up a database. Because only a DBA should perform these operations, the database administrator user names require a secure authentication scheme.
• Creating and Maintaining a Database Password File
  You can create a database password file using the password file creation utility, ORAPWD. For some operating systems, you can create this file as part of your standard installation.
• Data Utilities
  Oracle utilities are available to help you maintain the data in your Oracle Database.

ibm aix system i training courses malaysia