Oracle Database 11g: Managing Time Zones and Datetime Functions
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
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.
Oracle Database 11g: Manipulating Queries and Data
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data ...
Oracle Database 11g: New Security Features
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 ...
Oracle Database 11g: Optimizer Statistics, Hints, and Cursor Sharing
Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course ...
Oracle Database 11g: Oracle Label Security and the Data Masking Pack
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 ...
Oracle Database 11g: Oracle Net Services and Listener Security
When considering Oracle security, you must also consider the security of the listener, which is the gateway to the network and the network itself. This course describes the items on the client, ...
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
Oracle Database 11g: Partitioning and Storage-Related Enhancements
identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.