Professional Oracle Administration
(ORAADMCP, 5 days)


Description

This intensive SETC certified course provides a comprehensive and detailed exploration of Oracle database administration. Starting with the basic tools of the trade, the course quickly accelerates to coverage of installation, configuration, databases, tablespaces, files and more. This is followed by modules covering enterprise manager, fault tolerance, high availability, security, partitioning, and flashback management amongst others. And no course on Oracle administration course would be complete in the absence of indexing. So we do that too. Fine tune your Oracle database administration skills with this exceptionally effective SETC certified course.

Dates and Pricing


Nov 20 to Nov 24, 2017$2,775/person Jan 15 to Jan 19, 2018$2,775/person Feb 12 to Feb 16, 2018$2,775/person Mar 12 to Mar 16, 2018$2,775/person

Outline

Oracle 11g Server Overview
Learning Objectives
DBA Roles and Responsibilities
The Oracle RDBMS
Oracle Server Product Overview
Oracle Architecture
Overview of PL/SQL
Objectives Covered
Installing an Oracle 11g Server
Learning Objectives
Preparing for an Oracle 11g Installation
Installing an Oracle 11g Server
Product Specific Prerequisite Checks
Database Configuration
Database Content: Sample Schemas
Recovery Configuration
Memory Parameters
Database Connection Mode
Security Settings
Creation Options
Objectives Covered
Creating and Configuring Databases
Learning Objectives
Oracle Database Server: Core Services
Tablespaces, Datafiles and Control Files
Converting Text-based to Server Parameter files
Overview of Memory Allocation and Memory Targets
Simplifying Memory Allocation and Memory Targets
Using the SQL *PLUS Utility
Configuring Oracle Databases
Overview of SYSDBA Privilege
Authenticating Connections having SYSDBA Privilege
Automating Database Management
Objectives Covered
Administering an Oracle 11g Server
Learning Objectives
Administering Oracle Databases
Using the Oracle Administration Assistant
Administering User Roles
Overview of Sophisticated Password
Authenticating Users with Sophisticated Password Checking
Ensuring Database Availability
Objectives Covered
Managing Tables and Files
Learning Objectives
Overview of Profiles
Limiting Resources Usage Through Profiles
Overview of Read Only Tables
Preventing Changes to Read Only Tables
Comparing Traditional managed and Oracle Managed Files
Configuring Storage Patterns for Database Objects
Structuring Data and Index Segments
Overview of Extents and Block Occupancy
Sizing Database Objects by defining Extents and Block Occupancy
Overview of PCTFree and Data Pump
Eliminating Row Mitigation with PCTFree and Data Pump
Compressing Table Data to Conserve Storage
Shrinking Tables and Indexes Online to Regain Space
Objectives Covered
Oracle Database Processes and Features
Learning Objectives
Processing Transactions with the Server
Overview of Processes and Memory Structures
Identifying types of Oracle 11g Processes and Memory Structures
Understanding Database File Structures
Archiving the Redo Log
Overview of the Result Cache
Sizing the Result Cache for Optimizing Repeated Queries
Objectives Covered
Oracle 11g Networking
Learning Objectives
Oracle Net Configuration Assistant
Listener Configuration
Naming Methods Configuration
Local Net Service Configuration
Directory Usage Configuration
Oracle Net Manager
General Tracing Settings
Oracle Advanced Security
Service Identification
Configuring Listeners
Naming Methods
Objectives Covered
Oracle Enterprise Manager
Learning Objectives
Oracle Enterprise Manager
Database Performance Page
Database Availability Page
Database Server Page
Database Schema Page
Database Data Movement
Database Software and Support
Configuring Enterprise Manager
Configuring Administrators
Oracle Notification Methods
Metalink and Patching Settings
Offline Patching Settings
Linux Server Staging Setup
Blackouts
Management Pack Access
Monitoring Templates
Corrective Actions Library
Data Exchange Hub
Management Services and Repository
Agents
Objectives Covered
Administering with Database Control
Learning Objectives
Comparing Command-Line and Graphical Interfaces
Overview of Database Control
Administering with Database Control
Equipping Database Control to Manage Additional Databases
Objectives Covered
Thresholds and Alerts
Learning Objectives
Overview of Thresholds and Alerts
Setting Thresholds and Generating Alerts
Verifying Changes in the Data Dictionary
Overview of Privilege Management
Performing Privilege Management
Objectives Covered
Flashback Management
Learning Objectives
Performing Flashback Management
Managing Space for Rollback and Read Consistency
Monitoring Expansion of Rollback Segments
Swapping to an alternative Undo Tablespace
Resetting Data to Recent Points in Time with Flashback
Tracking Changes to Data Values with Row History
Overview of Transaction History
Obtaining Transaction History with Flashback Transaction
Overview of Flashback Table
Performing efficient Recovery of Data with Flashback Table
Overview of the Recycle Bin
Retrieving Dropped Tables and Dependent Objects from the Recycle Bin
Objectives Covered
Partitioning
Learning Objectives
Overview of Partitioning
Partitioning to Support Administration and Availability
Overview of Table Partitions Recommendations
Creating Table Partitions and Sub-Partitions
Choosing Partitioning Methods - range, list, hash, intervals
Partitioning Tables based on Virtual Columns
Setting up Automatic Partition Allocation
Administering Partitions with merge, split, add and drop
Objectives Covered
Indexes
Learning Objectives
Overview of Partition Indexes
Maintaining Partition Indexes
Maximizing Performance with Local and Global Indexes
Monitoring Index Partition Usage
Overview of Unusable Indexes
Rebuilding Unusable Indexes
Objectives Covered