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

Overview/Description recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators Prerequisites A working knowledge of SQL Expected Duration (hours) 2.4 Lesson ObjectivesOracle Database 11g: Managing Undo Data, Database Security, and Maintenance recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions....

Overview/Description identify the ways in which Oracle Database has enhanced security, including enhancements to Transparent Data Encryption and password security, and identify the steps for managing all aspects of security. Target Audience Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g Prerequisites The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator...

Overview/Description Oracle Label Security is a powerful tool for classifying data and mediating access to data based on its classification. It provides an easy-to-implement row-level security solution and is built on the fine-grained access control technology of the virtual private database (VPD). This course describes Oracle Label Security, including label concepts and access mediation, as well as when to use Oracle Label Security. It also explores creating policies, defining data labels, applying policies to tables, and setting up user authorizations. Data masking is the process of...