Pre-April 2013: Training

In 2013 NYOUG redesigned its web site. To keep the older training information they were grouped together and posted as one post. The following is all the training information that occurred prior to April 2013.

 

October 2013

Josh Millinger

Advanced APEX

This session will describe many advanced features of Application Express 4.2 to attendees. Users are expected to have a basic knowledge of APEX. During the session, users will create an application using the SQL Workshop and Application Builder. Users will create dynamic forms and reports to track projects and the employees working on the projects. The application will include charts, maps, collections, trees, tabular forms and other more advanced widgets that APEX provides. In addition,

users will implement the necessary security on the data to ensure data is locked down to appropriate users. Other features discussed are Web Services, JavaScript, CSS, and Team Development.

 

Josh Millinger has been working with ApEx since before it was even a product. During his 11-year tenure at Oracle Corporation he built countless Apex applications which helped track everything from class registrations in the Partner Technology Center, a training facility he founded, to Oracle Partners, to data center hardware. He left Oracle in 2006 to form his own company, Niantic Systems, which focuses on Apex development. He is a frequent speaker at NYOUG meetings and also presents at ODTUG, IOUG, and OracleWorld.

 

 

April 2013

Tanel Poder

Getting the Most Out of Oracle’s Active Session History, Time Model, and Wait Events

 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 a quick and efficient overview of the superb performance analysis capabilities of ASH in just a day. In addition to the slides, demos and Q&A, you will see Tanel’s ASH scripts and troubleshooting techniques in action and will learn how the ASH data can provide the answer to most of the common performance diagnosis questions out there.

 

October 2012

Josh Millinger

APEX for Beginners

This session is designed as an introduction to Application Express.  Attendees will learn the basics of ApEx which include working with the SQL Workshop and Application Builder. The former allows users to navigate through database schemas and do basic DBA operations. The latter is where the “magic” of ApEx happens. Attendees will learn to create an application and add content such as forms, reports, graphs, lists, buttons, and other display items. In addition, attendees will understand how to add their own code to enhance the out-of-the-box abilities of ApEx.

 

April 2012

Steven Feuerstein

Oracle PL/SQL for the 21st Century

In 2012, the Oracle PL/SQL language will celebrate its 23rd birthday. Not bad for a language that initially found its application inside SQL*Forms V3 and is now widely regarded as the most powerful, flexible and well-structured relational database programming language. Twenty-three years also has provided Oracle with lots of opportunity to enhance PL/SQL, which makes it ever more challenging for programmers to keep up with all the enhancements. This one-day training covers the most critical features you need to know about if you are going to write PL/SQL programs that fully utilize the capabilities of modern PL/SQL in the 21st century, including the most important enhancements of Oracle Database 11g. The day will finish with a quiz on the topics covered, and prizes awarded to the top 5 scorers. Winners will be announced at the PL/SQL Challenge website, where thousands of Oracle technologists play daily, weekly and monthly quizzes on PL/SQL, SQL and APEX.

 

January 2012

Cary Millsap

Mastering Oracle Trace Data

  1. Thinking Clearly about Performance

  2. Making Friends with the Oracle Database

  3. Oracle Extended SQL Trace Data

  4. What the Oracle Call Names Mean

  5. Using Oracle Trace Data

 

October 2011

Jonathan Lewis

Indexing Strategies

There are several surprising ideas floating around the Internet about how Oracle indexes work. Sometimes these ideas are irrelevant and have no use or impact. Sometimes they have a serious impact on your effectiveness. They may make you do work that need not, or should not, be done. They may introduce down-time that you do not need. They may make you avoid a feature that is really the perfect feature for your application. This session reviews some of the commonly repeated misconceptions about indexes. We all know that indexes are supposed to make things go faster – but sometimes we forget that they have maintenance costs – of two types.

  • How do you identify the optimal set of indexes for your application?
  • How do you identify redundant indexes?
  • How do you check whether or not an index has become inefficient and needs to be rebuilt – and how do you rebuild it most cost-effectively?

This session discusses strategies for ensuring that you don’t waste effort supporting indexes that shouldn’t exist, and don’t waste valuable batch time rebuilding indexes that don’t need it.

 

April 2011

Arup Nanda

RAC for Beginners

This intensive training is designed to jumpstart your learning in RAC, Clusterware and ASM and to show you the ropes so that you can start learning the advanced concepts on your own. It is intended to teach you just enough for you to understand and be immediately effective on RAC in the minimum possible time – just one day. This includes 11g Release 2.

 

May 2010

Jonathan Lewis

Writing Optimal SQL

This session covers the following topics:

  • A quick review of use of indexes, including some of the less common uses and common errors in index design.
  • An introduction to the essential strategy for writing SQL that gets its result by doing the minimum work, and a model for investigating and re-engineering badly performing statements.
  • A brief discussion of the mechanics (and costing) of nested loop and hash joins, and why it’s so easy it is for the optimizer to pick the wrong option.
  • Fixing the code without touching the code – the latest options, including the ways in which you can use OEM to assist with tuning.
  • Problems and options with knowing internal mechanisms and taking advantage of them.
  • A look at a couple of popular requirements, and strategies for addressing them as efficiently as possible.
  • A look at the threats of hints and how to use them properly.

Jonathan Lewis is a well-known name in the Oracle world. Currently an Oracle ACE, and chosen as the Oracle Author of the Year 2006 for his book Cost Based Oracle – Fundamentals (Apress, 2005). Jonathan has been using the Oracle database software for nearly 19 years. Jonathan spends a large fraction of his time trouble shooting high-performance systems – a job that often requires a very detailed investigation of some of the internal mechanisms. The time he doesn’t spend on trouble-shooting is then devoted to further investigation, writing, and teaching on the way that Oracle works.

 

November 2010

Tanel Poder

Scripts and Tools for Oracle Troubleshooting and Advanced Performance Analysis

 

The aim of this training day is to make everyday Oracle troubleshooting and performance analysis work easier, by providing the right tools for the right problems. It is not simply necessary to optimize databases and SQL statements, but also your time. Using the right tools for the right problem allows you to perform your existing tasks faster and focus more on proactive work. This session will demonstrate the main scripts and tools that Tanel uses in his everyday work to facilitate troubleshooting and performance analysis quickly and accurately. A systematic approach for diagnosing different types of performance problems will be used throughout all the demos. The training day content will be roughly split into two focus areas:

  1. How to make your everyday troubleshooting and DBA work easier
  2. How to collect and analyze relevant performance data

Tanel Poder has over 12 years of experience managing and improving Oracle-based database and application environments, troubleshooting, tuning, and delivering training classes for Oracle Education and partners. Currently, he is particularly focused researching Oracle 11g internals and its touch point with Unix/Windows for gaining fast and accurate troubleshooting skills. He hosts an Oracle performance tuning blog at http://blog.tanelpoder.com.

 

February 2009

Tanel Poder

Advanced Oracle Troubleshooting for DBAs and Performance Engineers

This expert-level seminar is concentrated entirely on Oracle troubleshooting. Participants will learn how to systematically find the reasons for crashes, hangs, and poor performance. The seminar explains the full lifecycle of a database request, from client libraries and the network to the Oracle database kernel and underlying OS. Topics covered during the two days of intensive learning include: reading dumps, stack traces, network packet captures and Oracle SGA. Attendees will learn about debuggers and custom tools for real-time and post-mortem diagnosis. Since this seminar discusses Oracle internals in detail, attendees should already have a good understanding of Oracle concepts and DBA tools in order to get most out of the training days.

Tanel Poder has over 12 years of experience managing and improving Oracle-based database and application environments, troubleshooting, tuning, and delivering training classes for Oracle Education and partners. Currently, he is particularly focused researching Oracle 11g internals and its touch point with Unix/Windows for gaining fast and accurate troubleshooting skills. He hosts an Oracle performance tuning blog at http://blog.tanelpoder.com.

 

February 2008

Steven Feuerstein

Best of Oracle PL/SQL

Over its lifetime, PL/SQL has grown increasingly robust and complex. Many programmers are barely aware of the new capabilities of PL/SQL, much less fully understand the implications for their programs. Virtually all PL/SQL developers are too pressured by deadlines to have the time to think through the best way to apply PL/SQL’s many features. “Best of Oracle PL/SQL” offers a rapid-fire, one-day review of the most critical new features of the PL/SQL language, focusing on the major advances in Oracle Database 10g and Oracle Database 11g. Steven then takes you beyond the basics to show you how to apply these features in the context of best practices, so that you write highly optimized and easily maintained and enhanced applications.

Steven Feuerstein, one of the world’s leading experts in the Oracle PL/SQL language, has studied PL/SQL for over 15 years and serves as PL/SQL Evangelist for Quest Software.

 

May 2007

Jonathan Lewis

Understanding and Assisting the Cost-Based Optimizer

Is there a go_faster parameter ? Which parameters affect the cost based optimizer most? Just how does Oracle decide whether or not to use an index? Why does Oracle do a hash join instead of a nested loop? Why is Oracle ignoring my hints? All these, and many other questions about the working of the Cost Based Optimizer will be answered by this training seminar.

Jonathan Lewis is a well-known name in the Oracle world. Currently an Oracle ACE, and chosen as the Oracle Author of the Year 2006 for his book Cost Based Oracle – Fundamentals (Apress, 2005). Jonathan has been using the Oracle database software for nearly 19 years. Jonathan spends a large fraction of his time trouble shooting high-performance systems – a job that often requires a very detailed investigation of some of the internal mechanisms. The time he doesn’t spend on trouble-shooting is then devoted to further investigation, writing, and teaching on the way that Oracle works.

 

November 2007

Kirtikumar Deshpande

Oracle 10g Streams: Data Replication

This session was first presented at Oracle OpenWorld 2006 and was extremely popular, with attendees spilling out into the hallway. In this seminar you will learn about Oracle10g Streams architecture, configuration, administration and monitoring. A supporting demonstration will also show you the working of Oracle10g Streams.

Kirtikumar Deshpande has over 26 years of IT experience in various capacities, including over 12 years as an Oracle DBA. He co-authored the Oracle Press books Oracle Wait Interface – A Practical Guide to Performance Diagnostics & Tuning published in June 2004 and Oracle Performance Tuning 101 published in May 2001. He has presented a number of technical papers in various Oracle User Group conferences and meetings in the USA and abroad.

 

November 2006

Steven Feuerstein

Best Practice PL/SQL
Best Practice PL/SQL Presentation
Demo Files (zip)

Best Practice PL/SQL with Steven Feuerstein is a one-day whirlwind guide to the best that PL/SQL has to offer and the best practices for writing faster, more modular and eminently maintainable applications.

 

November 2005

Steven Feuerstein

PL/SQL Programming for the 21st Century

This seminar showcases new features of Oracle Database 10g PL/SQL, including:

  • Optimizing compiler

  • Compile-time warnings

  • Conditional compilation

  • Nested table set operations

It will also cover key new capabilities of PL/SQL from Oracle9i Database, including:

  • Table functions

  • Multi-level and string-indexed collections,

  • Dynamic SQL method 4 with both Native

 

April 2005

Dr. Paul Dorsey & Peter Koletzke

Java Programming and Web Development

This training session explores the alternative technologies you can use for moving applications to the Web in an Oracle environment. It discusses the terminology and language concepts of Java and describes how Oracle JDeveloper 10g can help you build and deploy a complete web application.

 

February 2005

Michael S. Abbey

DBA Best Practices

Best Practices, Partitioning, DataPump,

 

November 2004

Steven Feuerstein

Min-Max PL/SQL Best Practices and Tuning

Carefully chosen set of recommendations and key features to present in order to have the greatest impact possible on your programming habits and your overall effectiveness as a PL/SQL developer.