
Exadata Online Training
QTEC provides real-time and placement oriented Exadata training online training. Our Exadata training course includes basic to advanced level and our Exadata course are designed to get the placement in major MNC companies online training as soon as you complete the Exadata training online training from the best institute.
Our Exadata trainers are certified in Exadata technology and are experienced working professionals with hands on real time Exadata project exposure. We have designed our Exadata course content and syllabus based on students requirement to achieve everyone's career goal. In our Exadata training program, you will learn all the advanced concepts based on real-time scenarios we provide job oriented Exadata placement training.
QTEC offers Exadata training with choice of multiple training locations across Bangalore. Our Exadata training centres are well equipped with advanced lab facilities and excellent infrastructure. We also provide Exadata certification training. Through our associated Exadata training centres, we have trained more than 500+ students and provided placement. Our Exadata training course fee is value for money and tailor-made course fee based on the each student's training requirements. Exadata training course online training are flexible to meet students’ needs and conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.
QTEC provides real-time Exadata Online Training. We Provide 100% Placement Assistance and ensures that each and every student gets all kind of support from us.
Exadata Online Training Course Content
Prathima InfoTech Oracle Exadata Course Content
Course Objective
What are objectives and learning outcomes of Oracle Exadata
12c course?
Oracle Exadata Training provides you with the complete list
of courses needed to
understand the fundamentals of SQL, Database 11g
Administration, RAC and Grid
infrastructure and Exadata and Database Machine
administration. With this course, you will
attain knowledge on hosting oracle database and improve its
performance to the best
available levels.
Here are the course objectives of Oracle Exadata:
ï‚· Understanding of various Exadata database machine features
and
configurations
ï‚· Learn the unique capabilities delivered by exadata storage
server
ï‚· Get the knowledge on migration of database to exadata
database machines
ï‚· Recommended practices for enhancing database performance
ï‚· You should execute a real-time project based on the
comprehensive course
curriculum
ï‚· You will get to know the related jobs and job trends in
the industry
Who should opt for Oracle Exadata online course?
Oracle Exadata Certified Professionals are earning very high
salaries when compared with
other technologies. As such, there are no prerequisites for
learning Exadata. With a number
of job opportunities in Exadata, the following job roles
will get benefited from this course
ï‚· People having knowledge in Unix basics
ï‚· People having knowledge in SQL fundamentals
ï‚· People having knowledge in Oracle Core DBA
ï‚· People having knowledge in Oracle RAC DBA
ï‚· People having DBA experience in any OLTP/OLAP environments
is an added
advantage
Course content
Session 1 Introduction
Course Objectives
Audience and Prerequisites
Course Contents
Terminology
Additional Resources
Introducing the Laboratory Environment
Session 2 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
Session 3 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.
Session 4 Key capabilities of Exadata DB 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
Session 5 Exadata DB 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
Session 6 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
Session 7 I/O Resource management
I/O Resource Management: Overview
IORM Architecture
Getting Started with IORM
Enabling Intra 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
Session 8 Recommendations for Optimizing DB performance
Optimizing Performance
Flash Memory Usage
Compression Usage
Index Usage
ASM Allocation Unit Size
Minimum Extent Size
Optimizing Database Performance with Exadata
Session 9 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
Smart Scan real time usage
Session 10 Consolidations 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
Session 11 Migrating Databases to Exadata DB 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
Session 12 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
Session 13 Exadata DB 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
Session 14 Configuring Enterprise Manager Grid Control
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
Session 15 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
Session 16 Monitoring Exadata DB Machine DB servers
Monitoring Database Servers: Overview
Monitoring Hardware
Monitoring the Operating System
Monitoring Oracle Grid Infrastructure
Monitoring Oracle Database
Monitoring Oracle Management Agent
Session 17 Monitoring InfiniBand N/W
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
Session 18 Monitoring Other Exadata DB components
Monitoring the Cisco Catalyst Ethernet Switch
Monitoring the Sun Power Distribution Units
Monitoring the Avocent MergePoint Unity KVM Switch
Session 19 Other Monitoring Tools
Exachk: Overview
Running Exachk
Exachk Output
DiagTools: Overview
Using ADRCI on Exadata Storage Servers
Imageinfo: Overview
Imagehistory: Overview
OSWatcher: Overview
Session 20 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
Session 21 Exadata DB 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
Session 22Practice sessions & Interview tips
Brief on all sessions
Interview tips
Resume correction