Oracle11g Admin eLearning

Course Topics

 Oracle Database 11g: Database Architecture and Installation

• Main structural components of Oracle Database 11g
• Components of the Oracle Database 11g memory structures
• Functions of the Oracle Database 11 server and background processes
• How information is stored and structured within the Oracle Database 11g storage architecture
• Necessary tasks and essential tools required to administer an Oracle Database 11g database
• Planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI)
• Install Oracle Database 11g software in a given scenario

2. Oracle Database 11g: Database Creation, Instance Management, and Connectivity

• Creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA) and managing a database instance using various Oracle tools
• Scope and capabilities of Oracle Database 11g initialization parameters and the steps for maintaining them
• Configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance
• Using the Data Dictionary to find information about users, objects, constraints, and storage
• Create a database using the DBCA and manage instances using Enterprise Manager
• Ways of configuring and managing the Oracle network and the steps for creating a new Oracle Net Listener via Enterprise Manager
• Connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options and when to employ connection pooling
• Using and configuring Oracle Net Services in a given scenario

3. Oracle Database 11g: Storage Structures and User Security

• Purposes of table spaces and datafiles
• Creating a new tablespace
• How to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic
• Storage Management (ASM)
• View tablespace information and create a new tablespace
• Creating and authenticating database user accounts
• Granting and revoking privileges and creating and managing roles
• Creating and managing profiles, implementing password security, and assigning quotas

4. Oracle Database 11g: Managing the Schema, Data, and Concurrency

• Features and functions of schemas and data types and the steps for modifying a table
• Using constraints to maintain data integrity, view the contents of a table, and perform actions on the table
• Ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables
• Create a table with columns and also create constraints and indexes, in a given scenario
• Ways for manipulating data with SQL commands and for administering PL/SQL objects
• Triggering events and monitoring and resolving locking conflicts

5. Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance

• Managing undo operations in Oracle Database 11g to allow users to roll back transactions
• Requirements and best practices for implementing database security according to international and regional laws
• Enabling, specifying, maintaining, and reviewing database auditing
• Process for obtaining and applying Critical Patch Updates (CPUs)
• Configure an Oracle Database 11g database to support retention and implement database security in a given scenario
• Managing and gathering optimizer statistics
• Managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors
• Viewing and configuring automated tasks and setting alert thresholds

6. Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup

• Monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance
• Ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g
• Process used to configure an Oracle Database 11g database for instance recovery
• Features of different backup strategies you can employ in Oracle Database 11g
• Using RMAN to configure, schedule, manage, and view backup operations
• Resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario

7. Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database

• Tools required and steps performed in identifying whether a recovery is necessary
• Recovering various types of database files
• Features of the various options for moving data in Oracle Database 11g
• Importing, exporting, and moving data between Oracle databases using Oracle Data Pump
• Recover the database from a media failure and move data using the Data Pump Wizard in a given scenario
• Using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems
• Searching MetaLink for new critical patches and logging service requests
• Managing and applying patches in Oracle Database 11g

Supplemental Assets:

Lab Simulations: Task-based multipath scenarios provide realistic practice of technology subjects or applications, where applicable.

Pre and Post Courseware Assessments: Section-based assessments offer a range of practice and testing options within the section, including feedback and tracking.

Test Prep Exams: Practice tests will help you prepare for a certification exam. You can take a test prep exam in Study Mode (where you receive feedback after each question) or in Certification Mode (designed to mimic a certification exam) as many times as you want.

Mentoring: Mentors are available to help students with their studies for certification exam. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.