Oracle Exadata Database Machine: Implementation and Administration Course Overview

To successfully undertake the Oracle Exadata Database Machine: Implementation and Administration course, participants should have the following minimum required knowledge:

• Basic understanding of Oracle Database concepts, including database management and SQL (Structured Query Language).
• Familiarity with Oracle Database architecture and an understanding of how its different components work together.
• Experience with Oracle Grid Infrastructure, including Oracle Automatic Storage Management (ASM) and Oracle Real Application Clusters (RAC).
• Knowledge of database administration tasks such as backup and recovery, performance tuning, and user security.
• Basic understanding of Linux operating system commands and utilities, as Exadata systems typically run on Linux.
• Awareness of networking principles, which will aid in understanding the InfiniBand network technology used in Exadata.

These prerequisites are designed to provide a foundation upon which the course material will build. They are not meant to deter any potential learners but to ensure that participants can make the most out of the course by having a suitable background to grasp the complex concepts taught in the training.

Target Audience for Oracle Exadata Database Machine: Implementation and Administration

The Oracle Exadata Database Machine course is designed for professionals aiming to master implementation and administration.

• Database Administrators
• System Administrators
• Data Center Managers
• IT Infrastructure Engineers
• Oracle Consultants
• Technical Support Engineers
• Storage Administrators
• Network Administrators
• Data Architects
• Data Scientists involved in data management infrastructure
• Performance Engineers and Analysts
• Cloud Technology Specialists
• IT Professionals involved in Oracle database management and optimization
• Professionals seeking to upgrade their skills to include Exadata capabilities
• Solutions Architects designing infrastructure for Oracle Databases
• Technical Project Managers overseeing database solutions

Learning Objectives - What you will Learn in this Oracle Exadata Database Machine: Implementation and Administration?

Introduction to Learning Outcomes

Gain comprehensive knowledge on implementing and administering Oracle Exadata Database Machine, focusing on its architecture, performance optimization, monitoring, and maintenance strategies.

Learning Objectives and Outcomes

• Understand the architecture and components of Oracle Exadata Database Machine, including storage servers and InfiniBand network.
• Learn how to conduct initial configuration and prepare the Database Machine environment using Oracle Exadata Deployment Assistant.
• Master the administration and configuration of Exadata Storage Server and implement security measures.
• Explore I/O Resource Management (IORM) concepts and configure IORM to manage database workloads effectively.
• Gain insights into optimizing database performance using Exadata features like Smart Flash Cache, Smart Scan, and Hybrid Columnar Compression.
• Understand consolidation strategies for deploying multiple databases on Exadata and best practices for isolation and maintenance.
• Acquire the skills to migrate databases to Exadata using different methods including logical and physical approaches.
• Learn to perform bulk data loading operations using Oracle Database File System (DBFS).
• Develop monitoring skills for all components of the Exadata Database Machine using tools such as Enterprise Manager Cloud Control 12c and other useful monitoring utilities.
• Understand backup and recovery strategies tailored for Exadata, including the use of RMAN and the considerations for disk-based and tape-based backups.
• Gain knowledge on routine maintenance tasks and patching processes required to manage and update the Exadata Database Machine.