This webinar series prepares you to pass your Oracle Certified Associate (OCA) exams.  You will learn how to successfully answer questions to all the official Oracle OCA Exam Objectives.
 
This session addresses the second Oracle OCA Official Objective: "Restricting and Sorting Data".  Future sessions will cover all the other exam objectives required to obtain your OCA.
 
We will cover the following major topics required for this exam objective:

• Preliminary concepts:
  • Selection (restricting rows) via WHERE
  • Sorting rows via ORDER BY
• Numeric, character, and date datatypes and conditions
• Implicit and Explicit conversions
• Comparison operators
• Issues with NULLs
• Precedence rules
• Substitution variables
• And finally we will (anonymously) take and score a sample certification mini-exam

Presenter: Geoff Wiland 
Moderator: Dave Anderson

This seminar series prepares you to pass your Oracle Certified Associate (OCA) exams.  It teaches you how to successfully answer questions to all the official Oracle OCA Exam Objectives. 

This seminar addresses the first Oracle OCA Official Objective: “Data Retrieval Using the SQL SELECT Statement”.  Future seminars will cover all the other exam objectives required to obtain your OCA.

We will cover the following six major keys:
*Preliminary concepts: The dual table, case sensitivity/insensitivity, SQL, and statement terminators
*SELECT statement syntax and concepts: Projection, Selection, and Joins
*SELECT statement features including *, DISTINCT, column alias, literals, quotes in literals, and many others
*Datatypes and expressions
*NULLS: a detailed discussion of how to avoid problems with nulls
*And finally we will (anonymously) take and score a sample certification mini-exam

Your instructor, Geoff Wiland, has 25+ years of hands-on experience in the I.T. industry.  His last 10 years have been spent working with Oracle.  Geoff is also a frequent presenter at Oracle User Groups around the country.

This free training is segmented in several separate lessons:

1. Introduction to Data Retrieval with the SELECT Statement
2. Objectives
3. The Dual Table
4. Statement Terminators
5. Case & Column Alias
6. SQLPLUS
7. Selection, Projection and Join
8. SELECT Statement Syntax
9. SELECT Asterisk
10. SELECT Distinct
11. SELECT Concatenation and Literals
12. SELECT Column Aliases
13. SELECT Statement Quotes and Literals
14. SELECT Expressions Arithmetic and Date
15. SQL Datatypes
16. Oracle Nulls

Will we ever get the question of the use of bind variables over literals in our SQL answered?  Mix together the following in your Oracle database environment: large tables, skewed data, histograms (or lack of), bind variables, literals, the CURSOR_SHARING initialization parameter and bind variable peeking.  The mix can lead to uneven and poor performance. 

Oracle Database 11g provides an advanced solution, another answer to the question: Adaptive Cursor Sharing.  Via feedback from the runtime engine, 11g can deliver multiple solutions (execution plans) for the same query, without code changes.

In this tutorial you will receive a brief review of the terms previously mentioned and learn what feedback-based optimization and adaptive cursor shariing is. A demonstration is included.

Since its introduction just over one year ago, the SkillBuilders Super LOV (list of values) free Oracle APEX plug-in has been our most popular plug-in by far. In short, Super LOV displays multi-column LOVs.

To celebrate the Super LOV’s first birthday (a little belated),we are releasing version 2.0 which brings one of the most requested features since day one: Enterable! Of course enterable is only one of the many features offered by Super LOV at this point. In fact, Super LOV is so action-packed with features we thought it would be fun to create a video training series to show you how to use them all. So if you are in need of a multi-column LOV solution, or you’d simply like to learn more about installing and leveraging plug-ins in APEX, watch these videos. 

Your instructor, Dan McGhan is an Oracle ACE, Oracle Application Express Developer Certifed Expert and advocate. In addition to his "day job", he is one of the top contributors to the APEX forum, maintains his own Oracle and APEX Blog and has been a speaker at ODTUG Kaleidoscope, New York Oracle Users Group, New England Oracle Users Group, APEXOSED and Suncoast Oracle Users Group events.

This free training is segmented in several separate lessons:

1. Introduction to Super LOV 2.0 - A brief introduction to the plug-in and the training agenda. (1:55)
2. Installing the Super LOV Plug-In - How to download and install the free plug-in. Helpful for anyone interested in learning plug-in installations. (8:11)
3. Basic Use and features of The Super LOV Plug-In - Learn how to use and adjust the settings for the Super LOV plug-in. (7:36)
4. Adjusting the Look and Feel of The Super-LOV Plug-In - Learn how to customize the look and feel of Super LOV with jQuery UI themes. (10:57)
5. Global Settings - Adjusting global settings including Clear Confirm, No Data Found message and Search Type. (3:27)
6. Other Instance Settings - Adjusting instance settings including Searchable Columns, Hidden Columns, Column to Item Mappings, "Enterable" and Value Validation.  (10:38) 
7. API Methods - Learn API methods including Hide/Show Item, Hide/Show Row, Enable/Disable and Get/Set by Return Value.  (6:28)
8. Optional performance Upgrade - In this version of the plug-in, optional performance upgrades include Server Side PL/SQL Package Compilation and relocating Javascript files from the database to web server location. (4:07)
9. What's next for Super LOV ? - What features is Dan planning next? Watch this video to find out, and submit your own ideas! (1:52)

This one-hour webinar provides a practical demonstration of the Oracle 7000 series storage appliance management software.

We'll start with a brief summary of Oracle's innovative ZFS File System.

This is followed by a short overview of the Storage appliance products themselves, and the benefits ZFS brings to them.

The main part of the webinar will then focus on a live demonstration of the management software, from installation configuration, through the selection and creation of the device's storage model, to the creation and use of shares, and finally the software's monitoring and performance analytics features.

The management software is the same across all 7000 series products, so the webinar will give a good insight into the ease in which any of the product range can be managed.

Your instructor, Mick Hosegood, has been involved with Sun and Solaris for over 19 years. He served in the role of support manager at ICL and UK Training manager (Customer and Internal) at Sun Microsystems UK.

Learn Oracle 11g New Features, free.

Join Oracle Certified Master DBA John Watson and SkillBuilders' Dave Anderson as they continue to discuss the primary reasons you should upgrade to Oracle Database 11g R2. 

In this session, second in a continuing series, John will discuss and demonstrate (yes, live demos!):

• SQL Plan Management / Baselining -  Learn how to avoid disastrous plan changes when upgrading to Oracle Database 11g.  

Related Tutorials:

• Oracle Database 11g New Features, Session One, Parallel Processing and the 11g Results Cache

Free Oracle 11g New Features Tutorial: Oracle Database 11g - The Upgrade Motivators

Join Oracle Certified Master DBA John Watson and SkillBuilders' Dave Anderson as they discuss the primary reasons you should upgrade to Oracle Database 11g R2.  If you are in management or administration you will want to learn the key features that make 11g essential to your enterprise. With Oracle 10g now in Extended Support (you are now paying 42% - ouch!), it is time to upgrade!  Even if you have already upgraded, be certain you are taking advantage of these features.

The first installment, recorded November 10, 2011, covers:

• Enhanced parallel capabilities
• The Oracle 11g Results Cache

SQL is a language that allows you to perform queries to answer a wide range of questions about your data.  Subqueries provide powerful solutions to support a host of complex queries.

In this free online training video Geoff teaches you how Oracle Database supports a wide range of subquery capabilities including:
* Simple Subqueries
* Correlated Subqueries
* Top-N Queries
*  Subqueries in the WHERE clause, subqueries in the FROM clause, subqueries in the SELECT clause . . . subqueries everywhere!

We will also discuss subquery “gotchas” and how to avoid them, subquery best practices, subqueries vs joins, and how and why to use Subquery Factoring.

Your instructor, Geoff Wiland, has more than 25 years of hands-on experience in the I.T. industry.  His last 10 years have been spent working with Oracle. 

Be sure to view our calendar of instructor-led online Oracle classes. 

Duration: 34 minutes

Learn how to use ZFS backend storage for rapid deployment of Oracle VM Server for SPARC logical domains running the Solaris operating system. 

This 1-hour free training covers the following topics:

• Review of Control Domain configuration, using ZFS as the bootable root file system. 
• Creating a guest domain for use as a template ("Golden image"). 
• Creating a snapshot of the template logical domain. 
• Cloning the template to provision a new logical domain.
• Creating and booting the cloned logical domain.

We're always talking about best practice this, best practice that...well, this webcast talks about what you should never do when writing programs in Oracle PL/SQL.  The advice ranges from attention to the smallest details, such as the problem with VARCHAR2(n) declarations to ways that we write SQL statements in our PL/SQL programs. Attendees of the webcast will come away with a deeper appreciation for the traps into which we can fall, and how to climb on out and bask in the sunshine of high quality code.

Your instructor, Steven Feuerstein,Oracle ACE Director Steven Feuerstein is an expert on the Oracle PL/SQL language, having written 10 books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices. He is Quest Software's PL/SQL Evangelist and has been developing software since 1980. He's twice received the Oracle Magazine PL/SQL Developer of the Year award and was the first recipient in 2009 of ODTUG's Lifetime Achievement award.

You might also be interested in Steven's class "Best Practice Oracle PL/SQL + Oracle11g New Features".

This free training is segmented in several separate lessons:

1. Introduction to "Don't do THAT (in PL/SQL)" with Steven Feuerstein
2. Best Practices with VARCHAR2
3. Best Practices with Overloading
4. Best Practices with Error Handling
5. Best Practices with Bulk Processing
6. Best Practices with Top Down Design
7. Summary of Steven Feuerstein's "Don't Do That in PL/SQL"

This free tutorial and demonstration covers: 

• Installation and initial configuration of Oracle VM Server for SPARC v.2 software on an Oracle T-series server. 
• Configuration of the Control Domain, which controls the logical domain environment and provides services to guest domains. 
• A brief example of creating a guest domain.

Related free tutorials

Rapid Deployment of Logical Domains

Oracle ZFS Storage Appliances- A Demonstration

Instructor: Mick Hosegood, SkillBuilders Oracle Certified Solaris System Administrator, Solaris Network Administrator and Certified Linux Implementation Specialist

Duration: 60 minutes

See more Solaris Training from Mick.

"Introduction to Ruby" talks aren't that exciting. Every language has strings, arrays, conditionals, and evaluation, and by now, everyone's sick of "build a CRUD app in 15 minutes" demos. Every language has its own special qualities that set it apart, and this talk focuses what makes Ruby different and special. We'll cover seven advanced language features and techniques, and we'll demonstrate how we use those to solve everyday problems. We'll talk about message passing, extending core language features, lambdas, and we'll even write a little code that writes code. If you've looked at Ruby and thought "What's the point?" then this talk is for you.

Your instructor, Brian P. Hogan is an author, editor, trainer, and web developer who’s been building web sites professionally since 1995. He enjoys teaching and writing about technology, particularly web design, accessibility, and development. When not hacking on Ruby or JavaScript code, he’s writing songs, watching “The Simpsons,” or spending quality time with his wife and daughters.

More Ruby training from Brian.

Audience: Developers who have some experience with the Ruby language.

Language: English

Duration: 58 minutes

For beginners, see our free Web Development with Ruby on Rails tutorial.

Modal windows are very popular these days – and for good reason. They can help focus users’ attention on new content without disturbing their overall context within an application – and they’re cool too! Our latest plug-in, Modal Page, is designed to display entire APEX pages as modal dialogs. Rather than just release the plug-in into the wild, we thought we’d take the opportunity to provide some hands on training with it. If you’re in need of a modal page solution, or you’d simply like to learn more about installing and leveraging plug-ins in APEX, do not miss this session.

Your instructor, Dan McGhan is an Oracle ACE, Oracle Application Express Developer Certifed Expert and advocate. In addition to his "day job", he is one of the top  contributors to the APEX forum, maintains his own Oracle and APEX Blog and has been a speaker at ODTUG Kaleidoscope, New York Oracle Users Group, New England Oracle Users Group, APEXOSED and Suncoast Oracle Users Group events

You want 100% percent uptime and zero percent data loss? Thinking big price tag for two licenses of Enterprise Edition plus RAC and Data Guard? Perhaps not. We can do it for a fraction of the cost by using a stretched cluster: Oracle Standard Edition, RAC and ASM.

Presenter: John Watson, Oracle Certified Master and:

• Oracle Exadata 11g Certified Implementation Specialist
• Oracle Certified Professional, Database Administrator (releases 11g, 10g, 9i, 8i, 8.0)
• Oracle Certified Professional, Application Server Administrator (release 9i, 10g)
• Oracle Certified Expert: Performance Tuning; Real Application Clusters; Managing Oracle on Linux

Duration: 47 Minutes

More Oracle services provided by John.

Your Path to Oracle OCA/OCP Certification

How would you like to earn 13.5% more than you are currently earning?

The average salary for an Oracle professional who is “Oracle Certified” is 13.5% higher than for an employee who is not “Oracle certified”.  Oracle Certification is clearly a very valuable tool in today’s competitive marketplace.  

The question an Oracle professional needs to answer is “How can I get my Oracle certification as soon as possible?”  This webinar answers that for you.

We will cover the following five major keys to receiving your Oracle certification:

• Review the Oracle certification paths
• Describe the certification exams
• Show how to prepare for and pass the Oracle OCA and OCP certification exams
• Teach a sample certification lesson
• Take and score a sample certification mini-exam

At the completion of this webinar you will have a solid understanding of exactly what you need to do to get your certification.

Your instructor, Geoff Wiland, has more than 25 years of hands-on experience in the I.T. industry.  His last 10 years have been spent working with Oracle. Geoff is also a frequent presenter at Oracle User Groups around the country.

Oracle Application Express developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. Luckily JavaScript libraries, such as jQuery which is integrated into APEX, have made the language much easier to use. In this session, learn about jQuery through a series of analogies, nine in total, which will relate important concepts in the library back to what you already know in the database world.

Want to learn more APEX? Everything APEX!

Audience: Anyone working with or interested in Oracle Application Express

Presented by SkillBuilders' Oracle Application Express expert, Dan McGhan. 

SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena.

These questions can be easily answered via SQL statements called Analytic Functions. This presentation will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently.

Your instructor, Geoff Wiland, has more than 25 years of hands-on experience in the I.T. industry. His last 10 years have been spent working with Oracle. Geoff is also a frequent presenter at Oracle User Groups around the country.

Want to learn more? Check out our online classes!

Audience: Anyone familiar with an Oracle database.

Language: English

This webinar covers the configuration of two types of Solaris network failover and load-spreading features, both of which offer simple but effective solutions for network reliability and efficiency:

• IPMP (Internet Protocol Multi-Pathing) - a facility to create network failover with multiple network interfaces, and with the added benefit of outbound load spreading.
• Link Aggregations - similar to the above, but combines multiple interfaces into one, with full inbound and outbound load spreading. Also provides much more in terms of monitoring and control than IPMP.

Want to learn more about Solaris? Check out our online classes!

Presented by SkillBuilders instructor, Mick Hosegood began his career over twenty years ago at Sun Microsystems. He specializes in Solaris and Linux.

Audience: Anyone working with or interested in the Solaris Operation System.

Language: English

The Application Express (APEX) plug-in architecture is still relatively new - still celebrating "monthiversaries" in fact. But did you know you already have access to over 60 plug-ins for use in your applications? That's right, the community is rallying around this exciting new architecture! But here's the rub: you cannot benefit from what you do not know about.

In this session you will learn everything you need to start taking advantage of plug-ins in APEX. Where to find plug-ins and how to install them will be covered in the first part of the session. The second part of the session, which will consume the majority of the time, will provide an overview of some of the most useful and popular plug-ins. Be prepared to take mental notes because you never know when one or more of these plug-ins will come in handy.

Want to learn more APEX? Everything APEX!

Audience: Anyone working with or interested in Oracle Application Express

Language: English

Oracle Application Express developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. Luckily JavaScript libraries, such as jQuery which is integrated into APEX, have made the language much easier to use. In this session, explore JavaScript through a series of analogies, 9 in total, which will relate important concepts in the library back to what you already know in the database world.

Want to learn more APEX? Everything APEX!

Presented by SkillBuilders' Oracle Application Express expert, Dan McGhan.

Audience: Anyone working with or interested in Oracle Application Epxress

Language: English

Introduced with APEX 4.0, Dynamic Actions have successfully created a declarative interface around the complex event model used by modern browsers. Does this mean that knowledge of JavaScript been rendered useless? In short, no. This session will explore the declarative side of Dynamic Actions to find out exactly what is possible and what is not, but most importantly, it will demonstrate what one would need to know to bridge the gap.

Want to learn more APEX? Everything APEX!

Presented by SkillBuilders' Oracle Application Express expert, Dan McGhan.

Audience - Anyone working with or interested in Oracle Application Epxress

Language: English

Duration: 53 minutes

The next version of SunGard Banner uses the Groovy programming language for its business rules and the Grails framework for applications development. Groovy and Grails are new, state-of-the-art technologies that will change the way you work. Both are likely to be new to existing Banner programmers. Ken will provide an overview of both technologies and discuss their likely impact on future development. He'll also present ways to minimize disruption as you decide how to best use them in your environment. Topics will include: What is Groovy and what can it do for me? How can I build and support Grails applications? What do I need to know to use both successfully? How can I stay productive while I learn all that?

Want to learn more Groovy and Grails? Check out our online classes!

Audience: Programmers, Developers, anybody interested in Groovy and Grails.

Language: English

Duration: 58 minutes

Learn what's different about cost-based optimization in 11g Release 2. In this session Dave Anderson will guide you through some enhancements and other surprises in the Oracle 11g cost-based optimizer. Through live demonstrations and lecture, you will learn about features such as adaptive cursor sharing, new join techniques, DBMS_STATS enhancements, direct (PGA) reads for "large" full table scans, new hints and more.

Presented by SkillBuilders' President, David G. Anderson.

Want to learn more? Check out our online classes!

Audience: Experienced Developers and DBAs.

Language: English

The Ruby on Rails framework gives you the tools you need to develop web applications faster. In this webinar, you'll learn about the basic components of the Rails framework and see how to create and test a very simple web application that you can build upon. By the end you'll have an idea of how you can leverage Ruby on Rails in your work.

Your instructor, Brian P. Hogan is an author, editor, trainer, and web developer who’s been building web sites professionally since 1995. He enjoys teaching and writing about technology, particularly web design, accessibility, and development. When not hacking on Ruby or JavaScript code, he’s writing songs, watching “The Simpsons,” or spending quality time with his wife and daughters.

Audience: Programmers, Developers, anybody interested in Ruby on Rails.

Language: English

Duration: 57 minutes

Introduced with APEX 4.0, Dynamic Actions have successfully created a declarative interface around the complex event model used by modern browsers. Does this mean that knowledge of JavaScript been rendered useless? In short, no. This session will explore the declarative side of Dynamic Actions to find out exactly what is possible and what is not, but most importantly, it will demonstrate what one would need to know to bridge the gap.

Presented by SkillBuilders' Oracle Application Express expert, Dan McGhan.

Want to learn more APEX? Everything APEX!

Audience: Anyone interested in Oracle Application Express.

Language: English

Most companies use the checklist/tip based approach to secure their databases BUT this is flawed as the checklists available for hardening are based around parameters and the core database software not the data. The goal must be to secure the *data* not the software; of course we must use the software setttings to secure the data but the focus of any data security project must be the data.

Pete will show the issues with the traditional approach and then outline what is the correct approach to securing data with lots of examples and tips. Pete will work through the process needed step by step to target and understand your data and then outline steps to secure it.

Pete Finnigan is well known in the Oracle and security worlds for contributing to the field with books, papers and presentations. Pete wrote the SANS Oracle Security step by step and created the S.C.O.R.E checklist, and the CIS Benchmark is based on his work. He recently wrote chapters on data security and user security for the new Oak Table book, "Oracle Expert Practices." Pete also consults for clients worldwide, securing their data through design work and security audits, and also teaching his very successful training courses.

Want to learn more Oracle? Check out our scheduled Oracle classes!

Audience: Anyone familiar with an Oracle database.

Language: English

If you use Oracle Application Express then you have probably heard of "plug-ins" by now. But you may still have some unanswered questions, such as:

• What exactly is a plug-in?
• What can plug-ins do for me?
• What plug-ins are available?
• How do I install and use plug-ins?

These questions and more will be answered during this webinar. This will be a high level introduction to plug-ins during which we will demonstrate how plug-ins can save your organization time and money by easing development efforts. Attendees will receive a copy of the next SkillBuilders plug-in – one week before its general release to the public.

Want to learn more APEX? Everything APEX!

Audience: Anyone interested in Oracle Application Express.

Language: English

Grails is a dynamic-language based, complete-stack framework that brings simplicity and elegance to web development. It uses the Groovy programming language to work with the existing, mature open-source projects Spring, Hibernate, and SiteMesh. Through its plug-in system, it incorporates many other projects as well, ranging from Quartz scheduling to GWT user interfaces to Spring (Acegi) Security, with more added all the time. This talk will demonstrate some of the main features of web site development with Grails, including:

• Object-relational mapping with GORM
• Scaffolding, both static and dynamic
• Testing
• Using RESTful web services
• User interface design with Groovy Server Pages

Want to learn more Groovy? Instructor-Led, online class: Getting Started with Groovy and Grails!

Audience: Groovy developers and others interested in learning Grails.

Language: English

Oracle Application Express developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. In this session, explore JavaScript through a series of analogies, 9 in total, that will relate important concepts in the language back to what you already know in the database world.

Recorded at ODTUG Kaleidoscope 2010

Want to learn more APEX? Everything APEX!

Audience: anyone interested in learning about JavaScript in PL/SQL and APEX 4.0 development.

Language: English

APEX 4.0 is a game changer - and it's closer than you may think! Some of the highlights of the release include:

• Improved Interactive Reports - Ever wanted to share a customized report you with others or schedule a report to be emailed to you? Now you can!
• Websheets - A new style of application that puts the controls in the hands of the end user rather than the developer. If spreadsheets are causing headaches but a traditional application seems like overkill, Websheets are the solution!
• Dynamic Actions - Dynamic Actions allow developers to create highly interactive, web 2.0 applications declaratively - no knowledge of JavaScript required!
• Plug-ins - The new plug-in architecture makes APEX more extensible than ever by allowing the community to add custom items, regions, processes and dynamic actions. All you have to do is download, install, and use!

Want to learn more APEX? Everything APEX!

Audience: anyone interested in learning about APEX 4.0

Language: English

SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena.

These questions can be easily answered via a new class of SQL statements called Analytic Functions. This presentation will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently.

Want to learn more Oracle? Check out our scheduled Oracle classes!

Audience: Anyone familiar with an Oracle database.

Language: English

Groovy is part of the new generation of dynamic languages for the JVM. It's not intended to replace Java, but rather to make it easier, more flexible, and more powerful. Groovy is what Java would have been like had it been designed in the 21st Century. Groovy dramatically simplifies Java development, and also brings modern language concepts like builders, closures, and metaprogramming to existing Java systems. The purpose of this session is to demonstrate both how Groovy makes Java development quicker and easier, and also to show some of Groovy's more advanced features. The capabilities illustrated will include:

• Groovy beans
• Optional typing
• Easy access and processing XML data
• Unit and functional testing of both Groovy and Java code
• Simplified file and directory handling
• Templating
• Ant builders, Swing builders, and XML builders

Want to learn more Groovy? Instructor-Led, online Groovy for Java Developers class!

Audience: Java developers interested in learning Groovy.

Language: English

Many organizations use applications that run on Oracle such as SunGard Banner, FAMIS, and Oracle Applications to name a few. These applications often offer reporting capabilities that are rigid or ineffective when it comes to keeping up with changing business needs and/or business processes viewed as "unusual" or "non-standard". More and more, these organizations are turning to Oracle Application Express (APEX) to fill this reporting void. Because of its small learning curve and impressive capabilities, APEX is the perfect solution to deliver all kinds of reports. In this webinar, learn how to use APEX to build applications used solely for reporting purposes. Topics will include:

• Creating both standard and interactive reports
• Creating drill down reports
• Creating charts
• Creating report menus for navigation
• Report printing options
• Securing access to data and reports

Want to learn more APEX? Everything APEX!

Audience: Anyone interested in reporting with APEX.

Language: English

Flex 4 and Flash Catalyst provide the easiest and most rapid way to build engaging Rich Internet Applications today. In this webinar, we'll show you how to use Flash Catalyst to convert a designer's Photoshop file into a Flex 4 UI, enhance the user experience with transitions and effects, then use the data centric features of FlashBuilder 4 to create a complete application that can create, read, update, and delete records using a PHP data service.

Want to learn more Adobe Flex? Everything Adobe Flex!

Audience: Anyone interested in rapidly creating powerful applications that run in browsers, on desktops, and on mobile devices. This webinar will demonstrate the benefits of using Flex and the Flash Platform in a way that anyone can understand.

Language: English

Many developers and organizations are looking for ways to take their Application Express (Apex) applications to the next level. On the client side, one of the best tools available for this purpose is jQuery and jQuery UI. In this webinar, we'll show you how to how "install" jQuery into your Apex application. Afterward, we'll demonstrate how to use a jQuery UI widget called Tabs to improve upon a rather cluttered application page.

Want to learn more Application Express? Everything Apex!

Audience: Anyone interested in making their Apex applications better, including IT Management, Developers and DBA's.

Language: English

Oracle Application Express (APEX) is an easy to use platform for developing data-centric web based applications. Although it has been around for years, many people have yet to really discover and utilize its unique strengths. Those new to Apex often have many questions including: What can Apex do for me or my organization? What features are available "out of the box" and can I extend the product if needed? Is is secure and can it scale? This session will answer these questions, and many more, via a high level product overview which will include a live demo.

Want to learn more Apex? Online Classes starting soon... Click HERE now

Audience: Anyone interested in learning more about Oracle Application Express, including IT Management, Developers, DBA's, Oracle End-Users.

Language: English

Many organizations are seeking an HTML-based migration path for their Oracle Forms applications. The main platforms available, including JSP/JSF, .NET, and PHP, are object oriented and may require extensive time and training for those new to them.

Another solution is Oracle Application Express (Apex), which can provide an HTML-based solution while leveraging existing SQL and PL/SQL knowledge. Attendees will learn about the main differences between the two platforms, the pros and cons of the alternatives (JSP/JSF, .NET, PHP), the general migration process and how to avoid some pitfalls along the way.

Need more Apex Training, Mentoring or Services? Everything Apex.

Audience: Oracle Forms and Reports Developers, IT Management, Oracle DBAs.

Language: English

This webinar provides a whirlwind tour of some of the most exciting features of PL/SQL that you all should know about and use, including DBMS_ERRLOG, FORALL, BULK COLLECT and DBMS_UTILITY.FORMAT_ERROR_BACKTRACE.

This webinar is a preview of Steven's class, "Best of Oracle PL/SQL".

Audience: Oracle developers and DBAs with 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 ACE Director Steven Feuerstein is an expert on the Oracle PL/SQL language. He is the author or coauthor of 10 books on PL/SQL including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices, is a PL/SQL Evangelist and has been developing software since 1980. His current obsession is improving PL/SQL code quality through automated unit testing. You can find out more about Steven and his PL/SQL-related activities by visiting www.stevenfeuerstein.com and www.ToadWorld.com/SF.

Language: English

Application Express (Apex) is an easy to use platform for developing data-centric web based applications. Although it has been around for years, many people have yet to really discover and utilize its unique strengths. Those new to Apex often have many questions including: What can Apex do for me or my organization? What features are available "out of the box" and can I extend the product if needed? Is is secure and can it scale? This session will answer these questions, and many more, via a high level product overview which will include a live demo.

Want to learn more Apex? Online Classes starting soon... Click HERE now

Audience: Anyone interested in learning more about Oracle Application Express, including IT Management, Developers, DBA's, Oracle End-Users.

Language: English

Many developers and organizations are looking for ways to take their Application Express (Apex) applications to the next level. On the client side, one of the best tools available for this purpose is jQuery and jQuery UI. In this webinar, we'll show you how to how "install" jQuery into your Apex application. Afterward, we'll demonstrate how to use a jQuery UI widget called Tabs to improve upon a rather cluttered application page.

Want to learn more Apex? Online Classes Starting May 24

Language: English

This training provides you with a technical introduction to the Database Replay utility, which can capture a real workload and replay that workload against a test system. (Note that in this presentation Chuck delivers a live demo of database replay and encounters an error with the capture process. Per Chuck "....having saved the previous capture files into a sub-directory was the problem. Even though the capture files were moved out of the default directory, the fact that there was a sub-directory there was enough to make the capture job FAIL!") Database Administrators, PL/SQL Developers, IT Managers and Training Coordinators with Oracle Database experience can all benefit from this webinar.

Presenter: Chuck Felix

Language: English

An Oracle SQL execution plan is a vital component in diagnosing performance issues with sql statements. One of the challenges faced by Oracle developers and DBA's alike is how to use execution plan to focus efforts. Searching for specific operations or access paths may shift your the focus away from the real issue and waste your time making changes that have little positive impact. Using the foundation of the Throwaway Method and Response Time-based tuning, this session shows how to look for inefficiencies in statement processing and how to identify operations that contribute the most to the overall response time.

Presenter: Daniel Fink, Oracle Oak Table Member

Language: English

In this session we will show you how easy it can be to convert an existing spreadsheet into an ApEx application. Once the application is created we'll explore some of the advanced functionality available "out of the box". Later we will enhance the application by adding validations which help ensure the integrity of the data as well as authentication and authorization schemes which provide security.

Presenter: Daniel McGhan, ApEx expert, developer of the famous Brown University Energy Efficiency Application and SkillBuilders ApEx instructor.

Language: English

Also see: Online ApEx Classes

Please see our recently updated "Oracle Database 11g R2: RAC and Grid Infrastructure for Administrators" class.

Oracle Real Application Clusters (RAC) is Oracle's premier clustering product. RAC provides both scalability and availability by allowing multiple instances to simultaneously access the same database.

This session will provide you with an overview of the RAC architecture and features. In addition, some administration and tuning tips will be provided. As with most technology, RAC is not a solution for every scenario. Some applications scale well with RAC and others don't scale as well. Some examples of different configuration options and architectures will be provided. This will allow you to decide if RAC might be right for your system.

Presenter: Edward Whalen

Language: English

PL/SQL is Oracle's procedural language extension to SQL. It is functionally similar to SQL Server and Sybase's Transact SQL, but much more powerful.

The strength of PL/SQL and similar language extensions to SQL is that they are much more flexible than SQL. Their weakness is their performance. Oracle has addressed this weakness via PL/SQL's support of PL/SQL Arrays and Bulk Processing.

For many applications traditional PL/SQL requires us to process one row at a time. With Arrays and Bulk Processing many of these same applications can be easily rewritten to process many rows at a time. Additionally, Arrays allow us to build in-memory tables which are designed to avoid repeated SQL queries. Both techniques can lead to significant improvement in PL/SQL performance.

In this presentation we review various scenarios where PL/SQL is required. We then demonstrate the traditional PL/SQL solutions, and how to convert the traditional slower PL/SQL code to much faster code using PL/SQL Arrays and Bulk Processing.

Presenter: Geoff Wiland

Language: English

XML, the eXtensible Markup Language, is a universal language for describing data. XML is somewhat similar to HTML but addresses a much broader purpose and is therefore far more powerful and useful. In short, XML provides a common data format that all applications can share.

In this presentation, we review the many uses of XML in application design and demonstrate how to create an XML document. Once created, we examine how to automatically validate your XML document using both DTD schemas and XSchemas. Additionally, we describe and give examples of how XML Stylesheets are used to convert XML to HTML for presentation in a browser.

This presentation will give you a solid foundation in how XML is used in developing modern software applications.

Presenter: Geoff Wiland

Language: English

Extended SQL Trace is one of the most effective diagnostic tools for Oracle. When done properly, tracing reveals exactly what calls a user session is making and eliminates guess work when addressing performance issues. This presentation focuses on real life experience with lightly documented issues and covers how to properly trace a user session, wait events, trace file architecture and how to read it, and summarizing session activity using profiling tools. We finish with several test cases demonstrating the usefulness of sql trace to diagnose session, sql, system and architecture issues.

Presenter: Daniel Fink specializes in Oracle performance diagnosis and optimization, monitoring and data recovery. He has been in IT for over 17 years, first as a Cobol programmer on the Vax VMS platform. In 1995, he transitioned to Oracle, first as a developer, then DBA...on DEC Alpha OpenVMS and Oracle Parallel Server 7.0.13. He has been both a development and production DBA (often at the same time). For the past 5 years, Daniel has focused on Oracle performance diagnosis and optimization. He has been a member of the Oak Table Network (www.oaktable.net) since 2004. Daniel has presented at conferences and user group meetings across the United States and Europe, including RMOUG Training Days, The Hotsos Symposium, IOUG-A Live!, UKOUG, Miracle dbForums in Denmark and Scotland.

Language: English

SQL Injection is an enormous emerging data security threat, used to commit wide-scale fraud, steal from bank accounts, capture credit card numbers, distribute malware, and construct botnets. Neil Daswani reviews how SQL Injection works, provides examples of advanced and automated SQL injection attacks, outlines how to properly defend against attacks, and discusses why you must defend against them — even if you don't store "sensitive" information in your databases.

Presenter: Neil Daswani has held R&D, teaching and managerial roles at Google, Stanford University, DoCoMo USA Labs, Yodlee, and Bellcore (now Telcordia). He is an expert in data security, and the lead author of "Foundations of Security: What Every Programmer Needs to Know."

Language: English

Find out how – beginning with Oracle 10g and growing more powerful in Oracle 11 – the new features of ASH (Active Session History) and AAS (Average Active Sessions) are more versitile and powerful than statspack. Learn more about ASH, a new paradigm in performance data, and AAS, the ultimate summary of ASH data. Kyle will also present examples of problem detection, analysis and resolution, as well as scripts to get the most out of ASH with the least amount of effort.

Language: English

Presenter: Kyle Hailey, ASH Master! Kyle recently helped Oracle redesign OEM to be wait-event centric and was the Technical Editor of the 5-Star Oracle Wait Event Tuning book by Richmond Shee.

Attend an online class with Kyle