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
|
|
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.
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:
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:
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:
It will also cover key new capabilities of PL/SQL from Oracle9i Database, including:
|
|
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.
|