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.

Feb 8, 2012

1pm-2pm

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

To celebrate Super LOV’s first birthday (a little belated),we are releasing version 2.0 which brings one of the most requested featuressince day one: enterable! Of course enterable is only one of the many featuresoffered by Super LOV at this point. In fact, Super LOV is so action-packed withfeatures we thought it would be fun to invite you to a webinar to show you howto use them all. So if you are in need of a multi-column LOV solution, or you’dsimply like to learn more about installing and leveraging plug-ins in APEX, donot 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

Jan 12, 2012

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.

Free Video Tutorial Coming Soon!

Dec 22, 2011

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

Recorded Nov 30, 2011

On Demand!

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

Recorded Nov 10, 2011

On Demand!

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

Recorded Nov 4, 2011

On Demand!

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.

Recorded Oct 26, 2011

On Demand!

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"

Recorded Oct 25, 2011

On Demand!

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.

Recorded Oct 5, 2011

On Demand!

"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.

Recorded Sep 9, 2011

On Demand!

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

Recorded Aug 31, 2011

On Demand!

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.

Recorded Aug 25, 2011

On Demand!

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.

Recorded Aug 17, 2011

On Demand!

Learn how - in Oracle Database 11g - the runtime engine feeds data back to the optimizer to increase Oracle performance. A free tutorial from SkillBuilders.

See all our free Oracle tutorials.

Want to learn more SQL Tuning? Check out our online classes!

Audience: Experienced Oracle Database Administrators.

Language: English

Recorded Jul 20, 2011

On Demand!

Manual tabular forms are considered by many to be one of the most difficult concepts in APEX. For that reason it is best to use declarative tabular forms whenever possible. However, sometimes the creation of manual tabular forms is unavoidable – often due to strict requirements. When this is the case, it is best to have a methodology in place that allows you to approach the creation of tabular forms systematically. In this session, learn to identify those situations that require manual tabular forms as well as methodology that will help you create them quickly and easily.

Recorded Jul 14, 2011

On Demand!

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. 

Recorded Jun 14, 2011

On Demand!

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

Recorded Apr 27, 2011

On Demand!

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

Apr 6, 2011

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

Feb 22, 2011

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

Recorded Feb 3, 2011

On Demand!

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

Recorded Jan 13, 2011

On Demand!

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

Recorded Dec 8, 2010

On Demand!

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

Recorded Dec 8, 2010

On Demand!

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

Recorded Nov 12, 2010

On Demand!

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

Recorded Nov 11, 2010

On Demand!

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

Recorded Sep 29, 2010

On Demand!

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

Recorded Aug 4, 2010

On Demand!

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

Recorded Jul 9, 2010

On Demand!

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

Recorded Jun 29, 2010

On Demand!

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

Recorded Jun 23, 2010

On Demand!

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

Recorded Jun 17, 2010

On Demand!

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

Recorded Jun 4, 2010

On Demand!

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

Recorded May 5, 2010

On Demand!

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

Recorded Mar 5, 2010

On Demand!

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

Recorded Feb 3, 2010

On Demand!

Learn how to configure and use the Oracle Database 11g SQL Results Cache in this webinar. Dave will teach the fundamentals of the cache, then demonstrate how to configure, use, monitor and do performance testing using the results cache.

Dave Anderson founded SkillBuilders.com in 1994. He has worked in the IT field since March 1980, and has 25 years of hands-on relational database experience.

Want to learn more Oracle?
Our online class calendar is here!

Audience: Oracle DBA's and Developers.

Language: English

Recorded Jan 14, 2010

On Demand!

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

Recorded Dec 10, 2009

On Demand!

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

Recorded Nov 18, 2009

On Demand!

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

Recorded Nov 3, 2009

On Demand!

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

Recorded Oct 21, 2009

On Demand!

Learn how to use "User Defined Metrics" in Oracle Grid Control. This session is going to be highly technical in nature – attendees should have a good understanding of Oracle Grid Control. Topics covered will include an overview of Grid Control, an introduction to User Defined Metrics (UDMs), creating Host UDMs, creating Database UDMs, creating Alerts on UDMs, creating custom reports using UDM values and creating rules for UDB Alerts.

Audience: attendees should already have a good understanding of the Oracle Database and in particular Oracle Grid Control.

Language: English

Oct 5, 2009

This webinar outlines the need for securing Oracle, and explores the traditional approach versus the correct approach. Topics covered include data flow, privilege and access assessment, and caveat emptor.

Presenter: Ron Reidy

Audience: Oracle DBAs, IT auditors, IT management, etc. A basic understanding of Oracle is required.

Language: English

Recorded Sep 23, 2009

On Demand!

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

Recorded Sep 17, 2009

On Demand!

What is High Availability? What is Disaster Recovery? And why do we need them? This webinar, geared toward both technical staff and management, is designed to answer those questions. We begin with a Data Guard overview including basic concepts and components, and cover configuring, monitoring and troubleshooting Data Guard.

Language: English

Sep 9, 2009

Learn the basic design issues necessary to scaling data warehouses in size while maintaining performance and manageability. Key is the proper use of partitioning, but the theoretical and practical underpinnings for the recommendations are reviewed as well.

Language: English

Recorded Aug 12, 2009

On Demand!

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

Recorded Jun 4, 2009

On Demand!

This session provides an overview of important new features in Oracle 11g. The discussion begins with performance enhancements, including improved analysis of Wait Events, a new invisible index feature and caching of SQL statement results. In the next session we will cover Database Replay, which allows the capture of a production workflow for testing on a testing server and Oracle 11g's simplified PL/SQL code compiling, which also eliminates the need for a C compiler allowing it to be used on Windows platforms.

Presenter: Chuck Felix

Language: English

Recorded May 19, 2009

On Demand!

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

Recorded Apr 13, 2009

On Demand!

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

Recorded Apr 3, 2009

On Demand!

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

Recorded Mar 20, 2009

On Demand!

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

Recorded Feb 27, 2009

On Demand!

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

Recorded Feb 23, 2009

On Demand!

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

Recorded Jun 27, 2008

On Demand!

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

Jun 19, 2008

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

Jun 5, 2008

This one hour presentation will provide the attendee with a basic understanding of the general Service Oriented Architecture (SOA) and its more specific manifestation as Web Services. Topics that Kevin will discuss include the SOA service provider/consumer model, the Web Service XML technology stack (WSDL, SOAP, and UDDI), coarse grained vs. fine grained transactions, web latency, and asynchronous transmissions.

Language: English

May 1, 2008