Oracle Expert Seminar

Our Selection of Live Virtual Classes for you:


divline
About
Oracle University
Expert Seminars:


Oracle University Expert Seminars are exclusive events delivered by top Oracle experts with years of experience in working with Oracle products.
divline
fbVisit our Facebook page
twitterFollow us on Twitter
linkedinJoin our LinkedIN Group
google+Find us on Google+
divline
Dan Hotka

Dan Hotka

Dan Hotka is a training specialist and an internationally recognized Oracle expert. He has over 31 years experience in the computer industry - over 26 years of them working with Oracle products. Dan is frequently published in Oracle trade journals and regularly speaks at Oracle conferences and user groups around the world. Check Dan's website.

Jonathan Lewis

Jonathan Lewis

Jonathan Lewis is an expert and well-known figure in the Oracle world with more than 25 years experience, who specializes in design, troubleshooting and advanced training in best use of the Oracle database engine. He is a regular contributor to various Oracle-related magazines, and also publishes technical articles on his blog.

Pete Finnigan

Pete Finnigan

Pete Finnigan is a leading authority in the security of Oracle Database. An early adopter of security for Oracle databases, he has been active in promoting the importance of security and has worked on many advances within the field.

Uwe Hesse

Uwe Hesse

Uwe Hesse has been active in the IT industry for the last 20 years and is one of the leading Oracle EMEA Subject Matter Experts on Database Core Technologies. He is specialized in Database Performance Tuning, Backup & Recovery, Data Guard and Real Application Clusters. Check Uwe's blog.

Arup Nanda

Arup Nanda

Arup Nanda has been an Oracle DBA for more than 14 years working on all aspects of Oracle Database from modelling, performance tuning, backup, disaster recovery to security. Check Arup's blog.

Expert Seminar - Oracle Database

Advanced SQL Tuning Tips and Techniques with Dan Hotka

Oracle University invites you to register for a seminar delivered by our SQL expert, Dan Hotka. You will be looking at execution with an Explain Plan, which shows how a relational database accesses data, and at how to retrieve the right data from your Oracle Database.

Why should you attend this seminar?
  • Understand the role of indexes - and the Oracle decision process in deciding whether to use indexes or not
  • Discover how to tell which indexes are being used, and when
  • Learn about free tuning aids such as the Oracle Trace Facility, Stats Pack, and the newer Trace Analyzer
  • Discuss the issues in finding problem SQL using scripts and additional information in the V$ and X$ dictionary views
20-21 March 2014
11:00-19:00 CET
Online

 
1
Register Now
1

 

Beating the Optimizer with Jonathan Lewis

This is a follow-on from the course “Designing Optimal SQL”, and focuses on writing SQL to emulate transformations that are currently not available to the Oracle Optimizer.

In this session you will examine a very simple join and note a fundamental limitation in the optimizer’s ability to find the best strategy for joining two tables. You will see how you can overcome this limitation – at a cost of more complex SQL – and look at the way you need to think about joins to minimize the work you do, noting that the possible benefit isn’t always as great as you might first think.

Course topics:
  • Single table access paths
  • The two-table join
  • Complex Joins
  • Structures and Features
07 March 2014
10:00 - 18:00 CET
Online

 
29-30 April 2014
10:00 - 15:00 CEST
Online

 

1
Register Now
1

 

PLSQL Secure Coding with Pete Finnigan

PLSQL Secure Coding with Pete Finnigan is a one day seminar, that teaches you about the common security issues often located in PL/SQL code and created by developers without an experience of database security.

It first places PL/SQL into the context of the problem of securing data and then looks at all of the common types of issues that make PL/SQL code vulnerable.

Why should you attend this seminar?
  • Each type of PL/SQL coding issue will be demonstrated so that the delegates can appreciate what vulnerable code looks like
  • Sample exploitations are demonstrated to show how the code is actually exploited by an attacker
  • For each example the code is re‐written to show how it can be made secure
  • Learn also about other issues such as encryption, leakage of critical data, dangerous functions and use of incorrect privileges
13 March 2014
11:00 - 19:00 CET
Online

 
1
Register Now
1

 

Minimize Downtime with Rolling Upgrade using Data Guard with Uwe Hesse

Starting with 10g, Logical Standby Databases offer a method to minimize the downtime related to a Database Upgrade to the time it takes to do a switchover.

This Seminar covers Rolling Upgrades with Logical Standby - in place already or created for that purpose – as well as Rolling Upgrade with a present Physical Standby. Rolling Upgrade procedures, processes and its restrictions are explained. All system requirements will be covered, as well as backup and fallback procedure.

Why should you attend this seminar?
  • Learn about Rolling Upgrade processes and procedures
  • Understand the requirements and restrictions for Rolling Upgrades
  • Get a brief Introduction into Logical Standby Databases
30 April 2014
11:00 - 19:00 CET
Online

 
1
Register Now
1

 

Advanced RMAN On-Line with Arup Nanda

The “Advanced RMAN” seminar is spread over 4 modules of total 8 hours, covering advanced concepts in RMAN – how to use in specialized cases and situations to watch out for. 11g R2 additions will also be covered.

Why should you attend this seminar?
  • Learn how to use image copies and merge backup to reduce the recovery time
  • Know how to validate that the backups is fine without actually performing a recovery
  • Know how to compress and encrypt the backups
  • Learn how to enhance the performance of RMAN jobs
  • Learn how to handle special cases such as large databases and script for automated processing
02 May 2014
11:00 - 19:00 CET
Online

 
1
Register Now
1

 


 

Study the Oracle Database at your own pace with Training On Demand
Oracle Database 12c: New Features for Administrators NEWPreview
Oracle Database 11g: RAC Administration Release 2Preview
Oracle Database 11g: New Features for Administrators DBA Release 2Preview

For a full list of Oracle Expert Seminars near you or on line click here.

For assistance contact your local Oracle University Service Desk.
Hardware and Software, Engineered to Work TogetherOracle University
Copyright © 2014, Oracle and/or its affiliates.
All rights reserved.
Contact Us | Legal Notices | Privacy
SEV100262683