2-day Seminar – “High Performance PL/SQL & Oracle 11g New Features”

May 16, 2012 by · Comments Off
Filed under: Uncategorized 

Steven Feuerstein 2-day Seminar
“High Performance PL/SQL & Oracle 11g New Features”
June 11 & 12 at Level 3 Communications
1025 Eldorado Blvd.
Broomfield, Colorado 80021

 

Steven Feuerstein, generally considered the world’s leading PL/SQL expert, will be presenting his all-new, 2-day, “Higher Performance PL/SQL and Oracle 11g PL/SQL New Features” seminar on June 11 & 12 at Level 3 Communications in Broomfield, Colorado.  This will be Steven’s first Denver seminar in almost 4  years.  Who knows when he will offer another?

The cost is $800 for RMOUG members and out-of-state registrants and $900 for non-members. This low price includes a free copy of the 5th edition of Steven’s seminal “Oracle PL/SQL Programming” a $38.17 value, covering all versions through 11g.  Attendees have the option of foregoing the book and having the $38.17 contributed in their name to the Stan Yellott Scholarship Fund.  Speak-Tech will match each such contribution and also contribute $100 for each attendee over a base of 30.    

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 two-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 PL/SQL, including the most important enhancements of Oracle Database 11g.   Register here.

Detailed Description of Topics to be Covered

1. Bulk Processing with BULK COLLECT and FORALL: the most important performance optimization feature of PL/SQL, bulk processing turbo-charges the speed of repeated execution of the same SQL statement (think: DML inside a loop) by reducing the number of context switches. We’ll explore every nook and cranny of BULK COLLECT and FORALL.

2. The Function Result Cache (11g): a fantastically elegant and high-impact feature, the function result cache provides an SGA-based cache that helps you optimize the performance of queries across an entire instance that repeatedly retrieve the same rows of data.

3. Row-Level Error Suppression in DML: added in Oracle Database 10g Release 2, the LOG ERRORS clause (along with the built-in package, DBMS_ERRLOG) offers row-level suppression of errors in DML statements, especially helpful when modifying large numbers of rows.

4. PL/Scope (11g): new to Oracle Database 11g, PL/Scope analyzes the way that all identifiers (variables, constants, subprograms, exceptions, types, etc.) are used in your code. It allows us to perform analysis on our code in a way never before possible. For example, you can implement your own scripts to check code for compliance with naming conventions – no parser required!

5. The NOCOPY Hint: so simple, and yet so impactful. Add one keyword to your IN OUT parameter definition and get a significant boost in performance. Along the way, learn about the difference between formal parameters and actual argument values, passing by reference vs. value.

6. Dynamic SQL Advanced Features: Oracle Database 11g includes many enhancements for dynamic SQL, especially for Method 4 dynamic SQL.

7. Advanced Collection Features: the year is 2012 and all PL/SQL developers should be aware of and use collections (PL/SQL’s version of arrays). So we’ll skip the basics and concentrate on advanced features like use of the TABLE operator, string-indexed associative arrays, and nested collections.

Prerequisites

A working knowledge of PL/SQL and at least a year’s worth of experience with the language. All developers, from beginner to expert, will benefit from Steven’s ideas and examples.

Oracle Version

Steven will demonstrate techniques and principles that apply to all recent versions of Oracle, but will also showcase new features in Oracle Databases 10g and 11g that can dramatically improve the quality and performance of code that you write.

We will finish with a quiz on the topics covered, and prizes awarded to the top 10 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.

Register here.

John Goodhue

Speak-Tech, LLC

 John.Goodhue@Speak-Tech.com

 Cell 612 203-6503

Tags: , , ,

Gaining Faster, More Reliable Oracle Applications

May 5, 2012 by · Comments Off
Filed under: Uncategorized 

F5 Networks Webinar Focused on Accelerating Oracle Applications
Thursday, May 24, 2012, 11:30 a.m.

Join F5 for a webinar focused exclusively on accelerating Oracle applications including Oracle E-Business Suite, PeopleSoft, Siebel and Beehive.  If you are responsible for deploying or managing  an Oracle application or supporting the network for these solutions, don’t miss out. F5 solutions help your network and Oracle applications work faster, use fewer resources, and perform more cost-effectively.  We look forward to your participation.

Learn how F5’s Solutions for Oracle improve web application speed and replication between datacenters and enable your organization to:

    Accelerate web applications for remote and mobile users by up to 5x (up to 10x in a symmetric deployment)
    Speed data replication over the WAN for business continuity and disaster recovery.
    Build a globally distributed application and database architecture.
    Provide comprehensive application and database security.

Register Now

Tags: ,

Register for the Denver IOUG Oracle Enterprise Data Security Event

May 1, 2012 by · Comments Off
Filed under: Uncategorized 

Independent Oracle Users Group Seminar
How Secure Is Your Enterprise Data?
Tuesday, May 8, 2012, 10:00 a.m. – 2:00 p.m.
Flemings Steakhouse, 191 Inverness Drive West, Englewood, CO 80112

Register online for this FREE event, or call 1.800.820.5592 ext.10554.

Despite successful attacks on databases resulting in more than 1 billion stolen records, fraud headlines, and global regulations calling for data privacy protection, many organizations have yet to put in place the controls needed to protect sensitive data throughout the enterprise. A recent Independent Oracle Users Group (IOUG) survey of information security professionals produced some staggering results, with 60% of respondents claiming that a data breach over the next 12 months is likely or unknown.

Join IOUG for this special seminar series featuring highlights of the IOUG Security Survey: Enterprise Data at Risk, as Oracle security experts discuss why organizations are at risk and how database security best practices can help reduce that risk.

During this event, you’ll also have the opportunity to participate in an exclusive Q&A session with Oracle security experts while networking with industry peers!

Tags: , , ,

Next Page »