Oracle Database 11g: Architecture, SQL Tuning, and Optimization
The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle ...
Oracle Database 11g: Basic User and Strong Authentication
A basic security requirement is that you must know your users. You must identify them before you can determine their privileges and access rights, so that you can audit their actions on the data. ...
Oracle Database 11g: Change Management Overview and SQL Plan Management
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change ...
Oracle Database 11g: Configure, Manage, and Use Services in RAC
A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing ...
Oracle Database 11g: Configuring for Backups
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for ...
Oracle Database 11g: Configuring for Recovery
To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery ...
Oracle Database 11g: Configuring OSB and Security
Oracle Secure Backup or OSB is centralized tape-management software that allows you to backup and restore data using a variety of machine architectures. This course covers how OSB complements the ...
Oracle Database 11g: Controlling User Access and Managing Objects
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
Oracle Database 11g: Controlling User Access and Managing Schema Objects
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one ...