Enkitec Extreme Exadata Expo 2012
Powered by
Enkitec
Sponsored by
Oracle
Sponsored by
Intel

Training Days

What: Choice of one one Exadata course - Exadata Administration or Exadata Performance Optimization

When: August 15 - 17, 2012

Where: Four Seasons Hotel & Resort, Irving, Texas (or virtual)

Time: 9:00 a.m. - 4:00 p.m. CT each day

Exadata Administration

Abstract

This three-day course focuses on performing day-to-day administration of the Oracle Exadata platform. Students will learn about the architecture of the Exadata machine and what to expect when asked to administer Oracle’s premier engineered system. Important tasks will be highlighted through hands-on labs. Students will learn how to successfully perform one of the most difficult aspects of Exadata administration – patching, as well as how to handle hardware failures and ensure that the system stays online. Students will learn from the Enkitec’s experience of owning and administering their own Exadatas, plus the numerous Exadata implementations performed by Enkitec.

What Students Will Learn

  • Exadata configurations and components
  • How Exadata storage servers are configured
  • How to administer ASM diskgroups on Exadata
  • How to troubleshoot hardware failures
  • How to configure Exadata
  • How to patch Exadata storage servers
  • How to back up and recover Exadata systems including storage servers

Course Prerequisites

Basic knowledge of Unix/Linux and networking

Course Overview

  • Exadata Architecture
  • Exadata Security
  • Storage Maintenance
  • Cluster Administration
  • Hardware Management
  • Exadata Patching
  • Exadata Backup and Recovery

Exadata Course Differentiators

The key differentiators between Enkitec’s Exadata Course and other curriculums:

Our course provides a deep view of Exadata, applying first-hand experience using the platform. The curriculum and courseware are packed with relevant, applicable client success stories. We’ve based the course on multiple implementations as opposed to listing a feature set.

We’re hands-on experts in Exadata. The collective experience of Enkitec’s 80+ Exadata implementations is condensed into an educational offering that can’t be matched by other curriculums.

The Enkitec Exadata course goes beyond just providing slides to read. We teach the fundamentals of how to manage Exadata through hands-on labs, thus substantially increasing retention of the concepts. Through this training, administrators will feel confident that they can perform day-to-day administration on Exadata without issue.

Why is there a course specifically for administering Exadata? Exadata is a unique combination of hardware and software provided from one vendor. At many customer sites, it is treated like a “black box” that isn’t to be touched. Like any other system, Exadata has complex requirements for a successful deployment. Exadata storage servers utilize a customized installation of Oracle Enterprise Linux along with an up and coming networking technology – Infiniband – for the backend storage and cluster interconnect. Due to the specialized nature of Exadata, administrators should be prepared to handle a broad range of areas including network, operating system, hardware and Oracle software. This class aims to cover the most relevant topics in each of these areas.


Exadata Performance Optimization

Abstract

This three-day course focuses on optimizing the performance of the Oracle Exadata platform. Students will gain an understanding of the physical characteristics of the Exadata machine and what makes it different from a traditional Oracle environment. Key features of the Exadata machine will be illustrated via many hands-on labs. Students will learn how to monitor the database to determine if key Exadata specific optimizations are being utilized and how to encourage the database to use them when necessary. To ensure that students experience production-like activity, this course will be delivered using Enkitec’s in-house Exadata X2-2 environment with multi-terabyte databases.

What Students Will Learn

  • Exadata configurations and components
  • How to find SQL statements which require optimization
  • How to read SQL Execution Plans
  • How to determine which Exadata features are being used (or not)
  • How to reduce data volumes using Hybrid Columnar Compression
  • How to use Exadata Smart Scan features
  • How to use parallelism effectively
  • How to use Exadata’s Smart Flash Cache

Course Prerequisites

Basic knowledge of Oracle SQL

Course Overview

  • What is Exadata / Why is it different?
  • Smart Scan feature overview
  • Reading SQL execution plans
  • Using Hybrid Columnar Compression
  • Partitioning on Exadata
  • Using parallelism effectively on Exadata
  • Using Exadata Smart Flash Cache
  • Staging and loading data

Exadata Course Differentiators

The key differentiators between Enkitec’s Exadata Course and other curriculums:

Our course provides a deep view of Exadata, applying first-hand experience using the platform. The curriculum and courseware are packed with relevant, applicable client success stories. We’ve based the course on multiple implementations as opposed to listing a feature set.

We’re hands-on experts in Exadata. The collective experience of Enkitec’s 60+ Exadata implementations is condensed into an educational offering that can’t be matched by other curriculums.

The Enkitec Exadata course goes beyond just providing scripts to run. We teach the fundamentals of how to build Exadata-specific code, thus substantially increasing retention of the concepts.

Other teaching models offer mostly lectures and PowerPoint presentations supplemented with minimal lab time using a simulation. Enkitec offers an intensive, collaborative hands-on experience using a real Exadata machine that is dedicated to the class. Through our collaborative process, students will come away knowing how to trouble-shoot SQL performance issues, whether on Exadata or not.

Why do we focus on writing and trouble-shooting SQL code? The main features of the Exadata platform are enabled and disabled based on SQL code. Using the Exadata without training, you’ll see a 2X to 4X improvement rate – a fraction of Exadata’s power – without knowing how to fully exploit its unique features. As a result, you’ll forego the tremendous performance improvement potential. During the course, you’ll learn to fully utilize Exadata’s features and see how you can achieve a 10X – 100X performance improvement.