Course Catalog

Enterprise Manager Command Line Interface Webinar - This webinar will open the administrator up to the world of Enterprise Manager 12c's Command Line Interface. Discover advanced features that the EM CLI can manage, not just commands to manage/address the E12c environment, but custom scripts used in SQLPlus, shell and Perl which can also be utilized through this invaluable tool.
Advanced Oracle Troubleshooting v.2.1 - This seminar is concentrated entirely on Oracle troubleshooting – understanding what exactly is Oracle doing right now or what was it doing when the problem occurred. You will gain the skill to systematically work out the reasons for crashes, hangs, bad performance or other misbehavior.
Grid Infrastructure and Database High Availability Deep Dive - Providing a highly available database architecture fit for today's fast changing requirements can be a complex task. Many technologies are available to provide resilience, each with its own advantages and possible disadvantages. This seminar begins with an overview of available HA technologies (hard and soft partitioning of servers, cold failover clusters, RAC and RAC One Node) and complementary tools and techniques to provide recovery from site failure (Data Guard or storage replication).
Pro Oracle SQL Tuning
  • Tuning
  • This course focuses on SQL Execution Internals that are the foundation for all SQL tuning.
    Advanced Oracle SQL Tuning 2.0
  • Tuning
  • This seminar is entirely about making Oracle SQL execution run faster and more efficiently, understanding the root causes of SQL performance problems and Cost Based Optimizer misbehavior.
    Performance Diagnosis and Monitoring Outside the Box with EM12c
  • Tuning
  • This session will investigate how and when to use SQL Monitoring, Cluster Cache Coherency, ASH Analytics, Cloud Control SQL History, Emergency Monitoring, Compare Period ADDM, and Real-Time ADDM features of the EM12c. If you've had challenges identifying issues in database environments or just want to know more about these new, enhanced features from Enterprise Manager 12c, this is the session for you!
    Getting the Most Out of Oracle's Active Session History
  • Tuning
  • This 1-day seminar is for developers and DBAs who want to become more systematic in their performance diagnosis work - and can use Oracle's Active Session History (part of Diagnostics Pack) for that. It provides you a quick and efficient overview of the superb performance analysis capabilities of ASH in just a day.
    Enkitec's Course on Oracle Exadata Performance Optimization
  • Exadata
  • Tuning
  • 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.
    Advanced Exadata Performance
  • Exadata
  • Tuning
  • This advanced seminar is meant for DBAs and developers who already have at least the basic experience of working with Exadata and have seen some of the common performance problems that may occur in production or performance tests. In this class we will dive deep into details of how Exadata works internally and then how to systematically troubleshoot performance problems caused either by application, database, storage cell software or Exadata hardware issues. The demos and troubleshooting examples are shown on Enkitec’s in-house Exadata X2-2 and V2 machines and we will use both standard Oracle tools and advanced Exadata troubleshooting scripts written by Tanel.
    Introduction to Oracle Exadata Performance
  • Exadata
  • Tuning
  • This seminar introduces you to key Exadata performance fundamentals and the usual tools and techniques you would use when planning, migrating and monitoring your databases on Exadata. This seminar aims to provide a technical overview of Exadata’s architectural differences and performance advantages, plus give you an idea how the usual Oracle performance monitoring and troubleshooting tools can be used on Exadata.
    SQL/Exadata Performance Intensive
  • Exadata
  • Tuning
  • This course will give you all the knowledge and tools you need to optimize Oracle SQL on both non-Exadata and Exadata platforms. The specific Exadata optimization techniques learned in the second half of the course can be best understood and applied if you have a firm foundation of SQL execution internals. Prior to actually laying hands on Enkitec's in-house Exadata X2-2, students can collect or refresh their foundation knowledge with material covered during the detailed lecture and demos in the first half of the course. This knowledge is then utilized and techniques adjusted when necessary for specific Exadata optimization features. Students will learn and practice skills that will allow them to diagnose and correct SQL performance issues of all types and become comfortable with how to effectively attack SQL performance issues with confidence.
    E4 SQL/Exadata Performance Intensive
  • Exadata
  • Tuning
  • This three-day course will give you the knowledge and tools you need to optimize Oracle SQL on both non-Exadata and Exadata platforms. The specific Exadata optimization techniques learned in the second half of the course can be best understood and applied if you have a firm foundation of SQL execution internals. Prior to actually laying hands on Enkitec's in-house Exadata X2-2, students can collect or refresh their foundation knowledge with material covered during the detailed lecture and demos in the first half of the course. This knowledge is then utilized and techniques adjusted when necessary for specific Exadata optimization features. Students will learn and practice skills that will allow them to diagnose and correct SQL performance issues of all types and become comfortable with how to effectively attack SQL performance issues with confidence.
    Enkitec's Course on Oracle Exadata Administration
  • Exadata
  • 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.
    Enkitec's Workshop on Oracle Exadata
  • Exadata
  • Find out if Exadata is right for your business at our comprehensive workshop. Many companies have reduced overal IT costs with Exadata. You can, too. Through consolidation, you can manage more data on multiple compression tiers, improve the performance of all applications, and make better business decisions in real time with Exadata.
    Getting Ready for Oracle Exadata Implementation
  • Exadata
  • This seminar is put together based on the most common questions about the Exadata implementation and maintenance lifecycle. In addition to reviewing the hardware architecture differences and giving you an overview of the Exadata installation procedure, we will address the key topics of patching, monitoring, data migration, high availability and disaster recovery strategies.
    E4 2013- Virtual Attendance
  • Exadata
  • E4 presents a unique platform where many of the presentations demonstrate the hands-on experience gained over the past three years working with mission critical applications in production environments. The content for all sessions will be based on fact and experience as opposed to theory. Presenters will pass along real-world experiences to better illustrate how Exadata is actually being used in the field.
    E4 Exadata Administration
  • Exadata
  • 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.
    E4 2013- Live Attendance
  • Exadata
  • The Enkitec Extreme Exadata Expo (E4) is the only conference that focuses exclusively on the Exadata platform. Since Exadata is still a relatively young product and is being enhanced at a rapid pace, it is difficult to get quality information in one place. As during our inaugural E4 last year, we will bring together a team of world-renowned experts that have been selected to present their findings and experience on this new platform.
    APEX Installation and Administration
  • APEX
  • Learn what you need to understand about how to manage an instance of APEX. This course focuses on the administrative side of APEX - how to install, configure and properly maintain APEX in your environment. This course is intended for DBAs and System Administrators.
    Troubleshooting and Debugging APEX
  • APEX
  • This course discusses how to troubleshoot APEX applications from a number of points - APEX itself, PL/SQL, HTML, CSS, JavaScript and Ajax. It includes a review of a number of open-source or free 3rd party tools that assist in troubleshooting and debugging APEX.
    Secure APEX Development Best Practices
  • APEX
  • Secure APEX Development Best Practices discusses how to build an APEX application with security in mind from day one. It covers all facets of APEX security - from the application itself down to each individual report column.
    Advanced Oracle APEX
  • APEX
  • APEX provides a rapid way to develop very functional applications in a very short amount of time, but to truly make those applications enterprise ready you have to go beyond what the basic wizards can do. This class provides you with the knowledge necessary to move beyond the basics and into advanced areas necessary for enterprise level applications.
    Introduction to Oracle APEX I
  • APEX
  • This course covers the fundamentals of APEX development using APEX 4.2 and is designed for those who have had little or now interaction with APEX or who are looking to formalize their understanding.
    Introduction to Oracle APEX II
  • APEX
  • This course picks up where Intro to APEX I leaves off. It covers Ajax, using Dynamic Actions & Plugins, security, user interface design, performance tuning and developer tools. It also covers the new Team Development module.
    1 - 24
    Ready for APEX 4.2

    All of our APEX curriculum has been updated to reflect APEX 4.2. Should you need training on a prior release, please contact us.

    New Course Notification

    Want to be notified when a new course or session is added? Sign up here.