Oracle Database 11g: Controlling User Access and Managing Objects

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

Overview

To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.

Target Audience

Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites

Familiarity with data processing concepts and techniques

Expected Duration

110 min.

Course Objectives

Oracle Database 11g: Controlling User Access and Managing Objects

  • identify the steps for granting and revoking system and object privileges.
  • grant privileges to users in a given scenario.
  • recognize the steps for altering a table by adding, modifying and dropping columns.
  • recognize the steps for adding and manipulating constraints and for creating indexes.
  • identify the steps for recovering your database using flashback, and for manipulating external data.
  • alter a table by dropping columns and adding constraints and indexes.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?