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

Overview/Description
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

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.0

Lesson 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.