▷ Oracle Exadata Training & Certification

Key Highlights

Preview

Course Video

16 Hrs Instructor Led Training

Self-paced Videos

14 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

Curriculum

A complete index of
job-ready skills curated
to meet the industrial need.
Explore.

Introduction

Course Objectives
Audience and Prerequisites
Course Contents
Terminology
Additional Resources
Introducing the Laboratory Environment

Exadata Database Machine Overview

Introducing Database Machine
Introducing Exadata Storage Server
Exadata Storage Server Architecture: Overview
Exadata Storage Server Features: Overview
Database Machine Capacity
Exadata Storage Expansion Racks
InfiniBand Network
Database Machine Support: Overview

Exadata Database Machine Architecture

Database Machine Architecture: Overview
Database Machine Network Architecture
InfiniBand Network Architecture
X2-2 Full Rack Leaf Switch Topology
Spine and Leaf Topology
Scale Performance and Capacity
Database Machine Software Architecture: Overview
Disk Storage Entities and Relationships.

Key Capabilities of Exadata Database Machine

Classic Database I/O and SQL Processing Model
Exadata Smart Scan Model
Exadata Smart Storage Capabilities
Exadata Hybrid Columnar Compression Data Organization
Exadata Smart Flash Cache Intelligent Caching
Storage Index with Partitions
Database File System
I/O Resource Management: Overview

Exadata Database Machine Initial Configuration

Database Machine Implementation: Overview
General Configuration
Choosing the Right Protection Level
Oracle Enterprise Manager Grid Control Configuration
Database Machine Hardware Installation: Overview
Configuring Oracle Exadata Database Machine: Overview
Selecting the Database Server Operating System
Deploying Solaris on the Database Servers

Exadata Storage Server Configuration

Exadata Storage Server Administration: Overview
Testing Storage Server Performance Using CALIBRATE
Configuring the Exadata Cell Server Software
Creating Flash-Based Grid Disks
Creating Smart Flash Log
Configuring ASM and Database Instances to Access Exadata Cells
Exadata Storage Security: Overview
Exadata Storage Security Implementation

I/O Resource Management

I/O Resource Management: Overview
IORM Architecture
Getting Started with IORM
Enabling Inter database Resource Management
Setting Database I/O Utilization Limits
Inter database Plans and Database Roles
Using Database I/O Metrics
IORM and Exadata Storage Server Flash Memory

Recommendations for Optimizing Database Performance

Optimizing Performance
Flash Memory Usage
Compression Usage
Index Usage
ASM Allocation Unit Size
Minimum Extent Size
Optimizing Database Performance with Exadata

Using Smart Scan

Exadata Smart Scan: Overview
Smart Scan Requirements
Monitoring Smart Scan in SQL Execution Plans
Smart Scan Join Processing with Bloom Filters
Other Situations Affecting Smart Scan
Exadata Storage Server Statistics: Overview
Exadata Storage Server Wait Events: Overview
Using Smart Scan

Consolidation Options and Recommendations

Consolidation: Overview
Different Consolidation Types
Recommended Storage Configuration for Consolidation
Alternative Storage Configurations
Cluster Configuration Options
Isolating Management Roles
Schema Consolidation Recommendations
Maintenance Considerations

Migrating Databases to Exadata Database Machine

Migration Best Practices: Overview
Performing Capacity Planning
Database Machine Migration Considerations
Choosing the Right Migration Path
Logical Migration Approaches
Physical Migration Approaches
Post-Migration Best Practices
Migrating to Databases Machine Using Transportable

Bulk Data Loading using Oracle DBFS

Bulk Data Loading Using Oracle DBFS: Overview
Preparing the Data Files
Staging the Data Files
Configuring the Staging Area
Configuring the Target Database
Loading the Target Database
Bulk Data Loading Using Oracle DBFS

Exadata Database Machine Platform Monitoring Introduction

Monitoring Technologies and Standards
Simple Network Management Protocol (SNMP)
Intelligent Platform Management Interface (IPMI)
Integrated Lights Out Manager (ILOM)
Exadata Storage Server Metrics
Thresholds and Alerts
Automatic Diagnostic Repository (ADR)
Enterprise Manager Grid Control
Enterprise Manager Database Control

Configuring Enterprise Manager Grid Control 11g to Monitor Exadata Database Machine

Enterprise Manager Grid Control Architecture: Overview
Grid Control Monitoring Architecture for Exadata Database Machine
Configuring Grid Control to Monitor Exadata Database Machine
Deploying the Oracle Management Agent
Configuring ASM and Oracle Database Targets
Deployment Overview for System Monitoring Plug-ins
Recommended Plug-in Deployment Strategy
Switch

Monitoring Exadata Storage Servers

Exadata Metrics and Alerts Architecture
Monitoring Exadata Storage Server with Metrics
Monitoring Exadata Storage Server with Alerts
Monitoring Exadata with Active Requests
Monitoring Exadata Storage Server with Grid Control: Overview
Monitoring Hardware Failure and Sensor State
Monitoring Exadata Storage Server Availability
Comparing Metrics Across Multiple Storage Servers

Monitoring Exadata Database Machine Database Servers

Monitoring Database Servers: Overview
Monitoring Hardware
Monitoring the Operating System
Monitoring Oracle Grid Infrastructure
Monitoring Oracle Database
Monitoring Oracle Management Agent

Monitoring the InfiniBand Network

InfiniBand Network Monitoring: Overview
Manually Monitoring the InfiniBand Switches
Monitoring the InfiniBand Switches with Grid Control
Monitoring the InfiniBand Switch Ports
Monitoring the InfiniBand Ports on Database Machine Servers
Monitoring the InfiniBand Fabric: Subnet Manager Master Location
Monitoring the InfiniBand Fabric: Network Topology and Link Status

Monitoring Other Exadata Database Machine Components

Monitoring the Cisco Catalyst Ethernet Switch
Monitoring the Sun Power Distribution Units
Monitoring the Avocent MergePoint Unity KVM Switch

Other Useful Monitoring Tools

Exachk: Overview
Running Exachk
Exachk Output
DiagTools: Overview
Using ADRCI on Exadata Storage Servers
Imageinfo: Overview
Image history: Overview
OSWatcher: Overview

Backup and Recovery

Using RMAN with Database Machine
General Recommendations for RMAN
Disk-Based Backup Strategy
Disk-Based Backup Recommendations
Tape-Based Backup Strategy
Tape-Based Backup Architecture
Connecting the Media Server Using Ethernet
Backup and Recovery of Database Machine Software

Exadata Database Machine Maintenance Tasks

Database Machine Maintenance: Overview
Powering Database Machine Off and On
Safely Shutting Down a Single Exadata Storage Server
Replacing a Damaged Physical Disk
Replacing a Damaged Flash Card
Moving All Disks from One Cell to Another
Using the Exadata Cell Software Rescue Procedure

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

Project Details

We bring you the best learning experience by delivering all our training sessions practical. Following are the few use cases we shall discuss during the training.

Oracle Exadata Training Objectives

1. What are the Oracle Exadata course objectives?

By the end of the Oracle Exadata training at Tekslate, our course participants will be able to acquire all the skills required for the job descriptions posted by companies for Oracle Exadata DBAs.

Our course objectives include:

Getting an overview of Oracle Exadata architecture.
Understanding Oracle Exadata database machine features and its configurations.
Understanding concepts of bulk loading and migration.
Gain knowledge on concepts of backup & recovery
Understanding storage concepts.

2. Why should you learn Oracle Exadata?

Many top multinational companies are using Oracle Exadata.
Oracle Exadata Certified professionals are earning high salaries compared to professionals of other technologies.
Due to high demand for Oracle Exadata professionals, there are numerous job opportunities available around the world.
On an average, an Oracle Exadata professional earns $114,783 USD per year.

3. Who should attend Oracle Exadata training?

Freshers/students who want to start their career in Oracle Exadata.
Database administrators
Software professionals
Professionals who want to update their skill-set with advanced technologies.

4. What are the prerequisites for learning Oracle Exadata?

Should have basic knowledge on Unix and SQL.
Should have knowledge on Oracle cloud-DBaas, and Oracle RAC.
Should be familiar with Oracle 11g and Oracle 12c.

5. What projects are included in this Oracle Exadata training course?

We will provide two real-time projects under the guidance of a professional trainer, who will explain you on how to acquire in-depth knowledge on all the concepts involved in these projects.

+1 930 200 4823

( Toll Free )

Training Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

Duration

One-on-one Session

Support

Resources

Time

Fee

Live Online.

16 Hours

Yes

24x7

Additional tips from the trainer

30 July 2024, 07:00 AM

03 August 2024, 08:00 AM

Self-Paced

16 Hours

Weekdays & Working Hours

Accessible through LMS

At your convenience

Oracle Exadata Training Upcoming Batches

Weekday

30 July 2024 to 30 August 2024

07:00 AM

Weekend

03 August 2024 to 03 September 2024

08:00 AM

Weekday

06 August 2024 to 06 September 2024

07:00 AM

Weekend

10 August 2024 to 10 September 2024

07:30 AM

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

I’m totally satisfied by the Oracle Exadata training from tekslate, because trainer is very talented and knowledgeable and explains every topic in-detail which helped me to grasp the skills quickly.

Naresh Kumar

It was very helpful with recorded videos to grasp course content quickly after the completion of training. Thank you tekslate.

Johnson

The support system is very effective in clearing the server issues during sessions. Trainer explains every topic with real-time scenarios which are very helpful.

Isabella