This 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.

Key Learning Objectives:

• 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 use Exadata Smart Scan features
• How to reduce data volumes using Hybrid Columnar Compression
• How to use parallelism effectively
• How to use Exadata’s Smart Flash Cache

Key differentiators between Enkitec's Oracle Exadata Course and other curriculums:

Our course provides a deep view of Exadata, applying first-hand experience using the platform. The curriculum and courseware use 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 100+ 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.