Oracle Database 11g: Managing the Schema, Data, and Concurrency
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
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
A working knowledge of SQL
Expected Duration (hours)
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.