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