Oracle Database 11g Release 2: Database Creation and Instance Management

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
120 minutes

Description
As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup strategy. It is also important to manage the database instance after the installation to ensure that it runs properly, and is started and shut down correctly to avoid problems. This course describes the DBA tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It demonstrates how to manage the instance, including setting initialization parameters, accessing the database and Enterprise Manager, viewing information about the instance, startup and shutdown stages, and viewing the alert log to ensure that there are no issues with the instance. This course also demonstrates how to use Oracle Restart to manage components.
This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).

Objective

Database Creation and Access

  • plan a database
  • choose the character set for the database
  • configure a database using the DBCA
  • access a database instance using various Oracle tools

Database Management

  • recognize the scope and capabilities of database initialization parameters
  • modify database initialization parameters
  • configure database startup and shutdown options
  • assess database performance and metadata information
  • use Oracle Restart to manage components
  • create a new database
  • stop and start the database

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.