Oracle Database 11g: Managing the Schema, Data, and Concurrency

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


Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency

Target Audience

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


A working knowledge of SQL

Expected Duration

120 min.

Course Objectives

Oracle Database 11g: Managing the Schema, Data, and Concurrency

  • recognize the features and functions of schemas and data types, and identify the steps for modifying a table.
  • recognize the steps for using constraints to maintain data integrity, viewing the contents of a table, and perform actions on the table.
  • recognize ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables.
  • create a table with columns and also create constraints and indexes, in a given scenario.
  • recognize ways for manipulating data with SQL commands and for administering PL/SQL objects.
  • recognize the steps for triggering events, and for monitoring and resolving locking conflicts.