Oracle Database 11g: Performance Enhancements
identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.
Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance ...
Oracle Database 11g: PL/SQL Code and Dependency Management
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and ...
Oracle Database 11g: Privileges, Roles, and Application Contexts
Authorization is the process that determines the privileges that the user is allowed to exercise. In the Oracle database, authorization is determined by the grant of system and object privileges. ...
Oracle Database 11g: Querying a Database with SQL
To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and ...
Oracle Database 11g: RAC Database and Oracle Clusterware Administration
Oracle Database 11g has many tools available for administering a RAC Database and Oracle Clusterware, including Oracle Enterprise Manager. This course explains how to use Enterprise Manager cluster ...
Oracle Database 11g: RAC Performance Tuning
Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. ...
Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.
Oracle Database 11g: RMAN and Oracle Secure Backup
RMAN manages the disk space in the Flash Recovery Area, and by putting RMAN in control of your backup and restore operations, you simplify your availability-related processes. This course describes ...