Oracle Database 11g: Database Creation, Instance Management, and Connectivity

This course is included in our On-demand training solution.

Overview

Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity.

Target Audience

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

Prerequisites

A working knowledge of SQL

Expected Duration

150 min.

Course Objectives

Oracle Database 11g: Database Creation, Instance Management, and Connectivity

  • recognize the steps for creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA), and also for managing a database instance using various Oracle tools.
  • recognize the scope and capabilities of Oracle Database 11g initialization parameters and identify the steps for maintaining them.
  • recognize the steps for configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance.
  • recognize the steps for using the Data Dictionary to find information about users, objects, constraints, and storage.
  • create a database using the DBCA and manage instances using Enterprise Manager.
  • recognize ways of configuring and managing the Oracle network, and identify the steps for creating a new Oracle Net Listener via Enterprise Manager.
  • identify the steps for connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options, and identify when to employ connection pooling.
  • identify the steps for using and configuring Oracle Net Services in a given scenario.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?