• Online, Self-Paced
Course Description

Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for loading data stored in compressed files, new parameters for simplified parallelism implementation, and new partitioning methods. It also covers the security and networking enhancements, including how to use Secure Files, the password file, default auditing, and tablespace encryption, as well as network support for IPv6 and configuring fine-grained access. This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Learning Objectives

Data Warehouse and Partitioning Enhancements

  • load data that is stored in compressed files
  • implement simplified parallelism
  • implement new partitioning methods


Security and Network Enhancements

  • recognize the features of Oracle Secure Files
  • use SQL and PL/SQL APIs to access Secure Files
  • implement the enhanced security features in Oracle Database 11g Release 2
  • encrypt a tablespace and control access to the network
  • identify how Oracle Net supports IPv6
  • apply Oracle Database 11g R2s partitioning features in a given scenario
  • employ Oracle Database 11g R2s enhanced security features


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Development
  • Vulnerability Assessment and Management