SkillBuilders SkillBuilders is an Oracle Partner Welcome  |  Log in
Share:

Free Online Training

Oracle Database 11g / 12c, Application Express (APEX), SQL, PL/SQL, Groovy Programming

Oracle Consultants Available
APEX Consultants Available
New! Convert webinar times to your local time Webinar times are Eastern Time, USA (Providence RI/New York)
Webinar Topic
Description
Date
Time (ET)
Register

SkillBuilders Oracle APEX Plug-In Tabular Form Super LOV

Since its introduction just over 3 years 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.

Now SkillBuilders presents a new version of the Super LOV plug-in...the Tabular Form Super LOV.  Free!

Watch this free video tutorial to learn how to install and use this plug-in.

Recorded Apr 27, 2014

On Demand!

View Training Video

 (Free Registration Required)

SQL Tuning with Oracle Database 12c

Learn the 12c features related to SQL tuning! Oracle Certified Master John Watson teaches with examples and demonstrations: Adaptive Execution Plans and Cardinality Feedback (enhanced in Oracle Database 12c).  

Prerequisites:  Reading an Execution Plan (a free tutorial)

Apr 15, 2014

View Training Video

 (Free Registration Required)

Execution Plans for Beginners - And an Excellent Refresher for Experts

Tuning Oracle SQL?  In this tutorial you will learn how to generate and read (interpret) an execution plan.

Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key.  

Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR.  In the demonstration, John will teach you:

  • How to read an execution plan
  • Find the 1st step in the plan
  • Decipher the order of the steps in the plan
  • That EXPLAIN PLAN can be very misleading 

Prerequisites: To get the most from this tutorial, you should:

  • Know how to code SQL
  • Be familiar with SQL*Plus
  • Know - in very general terms - what an execution plan is. 
  • Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements)
  • Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan.  Hopefully the correct - most efficient - plan).

Next Step:  12c Adaptive Execution Plans and 12c Re-Optimization of Execution Plans

 

...more...

Recorded Mar 30, 2014

On Demand!

View Training Video

 (Free Registration Required)

Tuning Oracle SQL with Extended Statistics

Learn what Extended Statistics are and how they can be used to provide the closest thing to a "silver bullet" in Oracle SQL tuning:  the correct join order!

Jan 13, 2014

View Training Video

 (Free Registration Required)

Oracle SQL Tuning with Direct and Indirect Reads

Learn what direct and indirect reads are and what impact they have on tuning SQL in Oracle Database.

In this free tutorial from SkillBuilders, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help.  

Perhaps most importantly, John will tell you what you can do about it.

Intended Audience:  Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience. 

Recorded Jan 8, 2014

On Demand!

View Training Video

 (Free Registration Required)

Web Development Primer for PL/SQL Programmers

Summary

Are you an expert server side software developer who needs to migrate to a browser based environment like Oracle Application Express (APEX)? Then this webinar is for you; it will help you to "break the back" on the somewhat steep learning curve that is required when you start learning how to effectively use client side browser tools like FireFox's Firebug and Chrome's developer tool. APEX expert and author Patrick Cimolini leads you, step by step, from a simple "hello world" web page to some real-world APEX pages; showing you along the way how to use the browser tools to inspect, test, and debug your HTML, CSS, DOM, AJAX, and JavaScript code.

Abstract

Many Oracle Forms developers are migrating their Oracle Forms applications to Oracle Application Express (APEX). These developers have strong backgrounds in server side programming but find the web environment a bit daunting to learn. This presentation is a primer for these server side programmers. The presentation introduces the audience to the important browser development tools that are required in order to take advantage of the web's browser based environment. Students are shown how to analyse and debug a web page by using the development tools that are built into the FireFox and Chrome browsers. The webinar starts with a simple "hello world" web page and then progresses, step by step, into real-world APEX pages where HTML, CSS, DOM, AJAX, and Javascript must be inspected, tested, and debugged. We'll de-mystify the web tools and help you achieve a level of comfort and confidence when working with the client side web tools.

Target Audience: SQL and PL/SQL programmers, Oracle Forms Developers.  Persons new to Oracle APEX.

 

...more...

Recorded Dec 17, 2013

On Demand!

View Training Video

 (Free Registration Required)

Convert to Oracle 12c RAC In 10 Minutes - A Free Tutorial from SkillBuilders

RAC and Grid Infrastructure are very sophisticated technology, but need not be intimidating. We can convert a single instance Oracle 12c database to two-node Real Application Clusters (RAC) in 10 minutes (using 12c online datafile move) - and so can you, after watching us do it. This tutorial will describe and demonstrate the technique.

Presented by Oracle Certified Master DBA John Watson, SkillBuilders' Director of Oracle Database Services.

...more...

Recorded Nov 5, 2013

On Demand!

View Training Video

 (Free Registration Required)

Oracle 12c Security Transparent Sensitive Data Protection Tutorial

What is Oracle 12c Transparent Sensitive Data Protection?

Transparent Sensitive Data Protection (a 12c new feature) leverages the Virtual Private Database facility (available since release 8i) and the the Data Redaction facility (introduced in release 12.1.)  TSPD eases the process of implementing and managing either VPD or Redaction. 

This tutorial will go through the old way of doing things with VPD: it was always a mission to set up, and because it operates at the row selection stage, sometimes hard to tune. Then we'll look at Data Redaction: in some ways simpler than VPD, and because it operates at column projection stage, possibly better performing. 

Everything discussed is Enterprise Edition, but no need to licence any additional options. 

Presented by Oracle Certified Master John Watson, SkillBuilders' Director of Oracle Database Services. 

Oracle 12c TSDP

Limited Time Complimentary eBook, Securing Oracle Database 12c

Are you an Oracle DBA who wants to protect your databases? Register now for the complimentary eBook and learn about Oracle Database Security from the experts who brought you the #1 database in the world. http://www.mhprofessional.com/dbsec

 

...more...

Sep 18, 2013

View Training Video

 (Free Registration Required)

Oracle Database 12c Security Free Tutorial

Oracle Database Security Tutorial for PL/SQL

Historically, we had definer's rights and invoker's rights. Definer's rights code lets the invoker escalate his privileges, invoker's rights code lets the definer escalate his privileges. Big problem! And the use of roles complicated things further. We have all been caught out by misunderstanding how roles are applied (or not) within PL/SQL. Oracle Database 12c tidies this up, with the INHERIT [ANY] PRIVILEGE privilege, and the ability to grant roles to program units. It is enabled by default, so make sure you understand it.

Presented by Oracle Certified Master John Watson, SkillBuilders' Director of Oracle Database Services.

Oracle 12c TSDP

 

Limited Time Complimentary eBook, Securing Oracle Database 12c

Are you an Oracle DBA who wants to protect your databases? Register now for the complimentary eBook and learn about Oracle Database Security from the experts who brought you the #1 database in the world.  http://www.mhprofessional.com/dbsec

...more...

Recorded Aug 28, 2013

On Demand!

View Training Video

 (Free Registration Required)

Oracle Clone Tutorial Lightning-Fast Cloning Large Oracle Databases

Oracle Clone Tutorial

Take the pain out of cloning! Take the time out of cloning!

Do you need to provide read-write clone databases for testing or development? Do you need to do it fast, simply, and with minimal disc space? This Oracle Clone Tutorial will show you how. 

Cloning databases can be slow, painful, and requires lots of disc space. Not any more. We can use copy-on-write technology to create as many independent clones as you want, all based on one backup of the source database. Creating a clone takes minutes, no matter how big the database is. The space used by each clone is only the space needed to record changes made within the clone (so initially, zero.) As far as your users are concerned, each clone is an independent database. They will have no idea that they are all sharing a common source. 

This facility (based on Oracle's Direct NFS technology) was introduced in release 11.2.0.2 and formally documented in 12.1.x. 

Presented by Oracle Certified Master John Watson, SkillBuilders' Director of Oracle Database Services. 

Oracle Clone Tutorial

...more...

Aug 14, 2013

View Training Video

 (Free Registration Required)

Oracle APEX Architecture Free Tutorial

This free tutorial explains APEX architecture, i.e. how the HTTP request/response cycle works, how an APEX application works (prerequesite knowledge), then introduces the options for an HTTP listening service: the embedded PL/SQL gateway, the Apache mod_plsql module, and the APEX listener deployed to either a Glassfish or a WebLogic container.

We summarize with benefits and recommendations for the various listener options. 

Audience:  Oracle DBA's, Internet Architects, System Admins, APEX Developers, anyone interested in learning how APEX works. 

Presenter: John Watson, Oracle Certified Master and SkillBuilders' Director of Oracle Database Services.

Moderator: Dave Anderson, SkillBuilders President and Oracle DBA

...more...

Jul 25, 2013

View Training Video

 (Free Registration Required)

Oracle Database Instance Recovery Tutorial

Is It Possible to Corrupt an Oracle Database?

No, You Cannot - Not If It Is Properly Administered

Why? Because the mechanism of redo and undo is the best yet developed on this planet.  

In this tutorial, Oracle Certified Master John Watson will explain redo, undo, commit, instance recovery and demonstrate why your database can never lose one row of committed data.  

Learn what actually happens, in memory and on disc, when DML is issued. John will demonstrate that instance recovery is automatic, and unstoppable. 

This is critical and essential knowledge for all Oracle Administrators and DBA students.

Presenter: John Watson, Oracle Certified Master

...more...

Jun 4, 2013

View Training Video

 (Free Registration Required)

Oracle SQL Tuning Tutorial -Tuning Long Full Table Scans

Long Full Table Scans. A Free Tutorial.

Number Eight in the  "Performance tuning Guide, Top Ten Mistakes Found in Oracle Systems" Long Full Table Scans is described as follows: 

"Long full table scans for high-volume or interactive online operations could indicate poor transaction design, missing indexes, or poor SQL optimization. Long table scans, by nature, are I/O intensive and unscalable."

Actually, there are many cases where the full table scan is your friend. But whether they are good or bad for the performance of the SQL that invokes them, there may be implications (for better or for worse) for performance of other statements. This is particularly true in 11.2.x, where direct reads are possible for serial scans, and indirect reads are possible for parallel scans. Do you trust the optimizer? The change in behaviour in recent releases may need some investigation, and revisiting older code. 

As always with a SkillBuilders' tutorial, we shall illustrate the issues and solutions with live demonstrations using release 11g (11.2.0.3). 

Audience:  Operating System Administrators, Storage Administrators, Oracle Administrators and Management responsible for Storage and / or Oracle Databases. 

Presenter: John Watson, Oracle Certified Master

Aug 4 - Online Data Guard Training with Oracle Certified Master John Watson

...more...

Mar 28, 2013

View Training Video

 (Free Registration Required)

Oracle Database 12c New Features Tutorials

We are building an entire course on Oracle Database 12c New Features, but we couldn't wait to introduce just a few now.  (Be sure to set your resolution to "HD".  Transcript available in 88 languages.)

Check out John's new Oracle Security Administration Class, updated for Oracle Database 12c!

This tutorial includes:

  1. Make limiting results and pagination through rows sets so much easier. Rather than using ROWNUM (and the associated problems), or a potentially poor performing subqueries, 12c implements a more sophisticated feature. This feature is implemented with the ROW LIMIT clause, FETCH FIRST n ROWS ONLY and variations. 
  2. New online capabilities for moving tables, indexes and even data files will reduce downtime for any sort of report hugely. 
  3. In earlier releases, numeric primary keys such as, for example a transaction number , where often handled by creating NUMBER column, a sequence, and a trigger to populate the column with unique, sequential numbers. Oracle 12c replaces all this with the "identity column" feature, manifested in the new clause "generated as identity". Much easier. 
  4. And our favorite, the multi-threaded database: a whole new process architecture, with the potential for spectacular performance and scalability improvements. 

In this free webinar, Oracle Certified Master John Watson will demonstrate the old and the new techniques and sometimes, as he often does, reverse engineer the feature to show how Oracle actually implements it. Just for good measure John adds a few other useful insights. 

All demonstrations on Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 

Audience: Oracle DBAs and Developers eager to learn Oracle 12c. 

Presenter: Oracle Certified Master John Watson

...more...

Recorded Feb 28, 2013

On Demand!

View Training Video

 (Free Registration Required)

Oracle 11g / 12c Grid Infrastructure Free Tutorial

What is Grid Infrastructure? (Hint: It's not Grid Control.)  

It is still possible to run an Oracle database without installing Oracle Grid Infrastructure. But is it sensible?  And, if you want to use ASM - which we strongly recommend - you need GI!

In this tutorial you will learn how Grid Infrastructure can replace (or complement) third party products for RAID, network management, and high availablility. At the same time, using these facilties can improve performance dramatically. Grid Infrastructure is the way Oracle is moving, and we want to show you that it is not necessarily complicated and can indeed make your life simpler. It can also save you money.

Content: live demonstrations of configuring and using Grid Infrastructure services with release 11g.

Audience: DBAs looking for entry level knowledge of what Grid Infrastruture can do.

Presenter: John Watson, Oracle Certified Master

Aug 4 - Online RAC & Grid Infrastructure Training with Oracle Certified Master John Watson

...more...

Feb 21, 2013

View Training Video

 (Free Registration Required)

Oracle Database 12c New Features: Online Move Enhancements

Oracle 12c offers new online capabilities for moving tables, indexes and even datafiles.  In this tutorial, SkillBuilders' Oracle Master John Watson explains and demonstrates the new capabilities.  Visit www.SkillBuilders.com/Oracle-Tutorials for more free Oracle Database tutorials.

Recorded Feb 21, 2013

On Demand!

View Training Video

 (Free Registration Required)

Oracle Database 12c New Features: Row Limit Tutorial

Make limiting results and pagination through rows sets so much easier. Rather than using ROWNUM (and the associated problems), or a potentially poor performing subqueries, 12c implements a more sophisticated feature. This feature is implemented with the clause FETCH FIRST n ROWS ONLY and several extensions such as OFFSET n ROWS.
 
In this free tutorial, SkillBuilders' Oracle Master John Watson will demonstrate the old methods of limiting results and pagination, and the 12c implementation, with several variations.  

 

...more...

Recorded Feb 21, 2013

On Demand!

View Training Video

 (Free Registration Required)

Using ApexSec to Develop Secure Oracle APEX Applications

Not all APEX applications have the same security requirements. When security really matters, arming yourself with the knowledge to build secure applications for the modern web is very important – but it’s not enough. You may have code you didn't write, code you wrote before you learned how to develop securely, or even code you wrote after you learned but before you had your coffee. The point is everyone makes mistakes and that’s where ApexSec comes in. ApexSec, developed by Recx, is a tool that analyses deep into the code of all versions of APEX and makes it easy to identify and fix the most serious of vulnerabilities that affect web applications today. In this session, attendees will see real mistakes that an experienced APEX developer made and how ApexSec was used to find and fix the vulnerabilities to help ensure the application’s security. 

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

...more...

Recorded Feb 20, 2013

On Demand!

View Training Video

 (Free Registration Required)

Oracle Database 12c New Features Free Tutorials: Identity Column

In Oracle 11g and earlier releases, "identity" columns, or numeric primary keys such as, for example a transaction number , where often handled by creating NUMBER column, a sequence, and a trigger to populate the column with unique, sequential numbers. Net: Work for the DBA or Developer. Clumsy: doing programmatically what the RDBMS should do by itself

Oracle 12c eliminates the need for sequences and triggers with the "identity column" feature, manifested in the new clause "generated as identity".  

In this tutorial, Oracle Certified Master John Watson will demonstrate the old and the new technique and, as he often does, reverse engineers the feature to show how Oracle actually implements it. Just for good measure John adds a few other useful insights. 

...more...

Recorded Feb 14, 2013

On Demand!

View Training Video

 (Free Registration Required)

The Top Ten Oracle Performance Tuning Mistakes: Connection Management

Oracle's Performance Tuning Guide has a section headed " The Top Ten Mistakes Found in Oracle Systems". It describes them, but it doesn't give solutions. We do.

This webinar will begin the process determining if your databases have these problems, and if so what to do about them.  Specifically, this session will deal with the problems - and solutions - caused by connection mis-management. 

As always with a Skillbuilders webinar, we illustrate the issues and solutions with live demonstrations using release 11g (11.2.0.3). 

Audience:  Operating System Administrators, Storage Administrators, Oracle Administrators and Management responsible for Storage and / or Oracle Databases. 

Presenter: John Watson, Oracle Certified Master 

Aug 4 - Online Data Guard Training with Oracle Certified Master John Watson

...more...

Recorded Feb 6, 2013

On Demand!

View Training Video

 (Free Registration Required)

Oracle ASM Free Tutorial

ASM may be the best thing to happen to Oracle this century, but the take up has been slow. How do you motivate the move to ASM? How do you work with your system administrators? What is the interaction between ASM and the storage infrastructure? These are the questions we will address, the answers should help you to launch an ASM implementation project.

Audience: Operating System Administrators, Storage Administrators, Oracle Administrators and Management responsible for Storage and / or Oracle Databases.

Presenter: John Watson, Oracle Certified Master

Aug 4 - Online Data Guard Training with Oracle Certified Master John Watson

...more...

Dec 20, 2012

View Training Video

 (Free Registration Required)

Zen and the Art of Mobile Development

Focus on the essential. Eliminate the superfluous. Less is more. Is this a Zen class or a session on mobile User Interface (UI) design? Actually, the two have more in common than you would think. The high demand for mobile Web applications is forcing Web developers to rethink UI design. After years of working with an abundance of pixels, this can be a difficult process and the actual implementation even more so. But it can also be very Zen like. In this session, attendees will learn about the most common patterns in mobile UI design as well as how such designs can be constructed in Oracle Application Express. 

Your instructor, Dan McGhan is an Oracle ACE, Oracle Application Express Developer Certified 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.

...more...

Recorded Dec 5, 2012

On Demand!

View Training Video

 (Free Registration Required)

Oracle Data Guard Tutorial: Data Guard for Performance and Reduced Licensing Costs

We all know that Data Guard is essential for protecting data. And we know that it is expensive and relies on largely idle systems, sitting there waiting for a problem that may never happen.  This tutorial provides a quick review of what Data Guard is, and then goes on to show how you can extract value from Data Guard in every-day usage: how you can use it to enhance performance, and to reduce (yes, reduce!) your need for Oracle licences. 

Audience:  This will be of interest to anyone already running Data Guard (or the old Standard Edition "standby database" facility) who needs to become aware of the newer capabilities, and to anyone trying to motivate the investment needed for a new Data Guard implementation. 

Recommended Prerequisites: As is common with SkillBuilders webinars, the content is technical, including live demonstrations of the techniques described. Some knowledge of Data Guard is recommended. 

Presenter: John Watson, Oracle Certified Master.

Aug 4 - Online Data Guard Training with Oracle Certified Master John Watson

...more...

Recorded Nov 7, 2012

On Demand!

View Training Video

 (Free Registration Required)

Oracle APEX Security Free Tutorial

Oracle Application Express (APEX) has many security related features that help developers create applications that are guarded from today’s web based threats. But if developers are unaware of these features, how they work and what they guard against, then it is likely they will create applications with at least a few security holes. In this session attendees will see live demos of certain exploits, including Cross Site Scripting and SQL injection, and subsequently learn how to protect against them using the correct feature(s) in APEX or Oracle in general.

Recorded Sep 27, 2012

On Demand!

View Training Video

 (Free Registration Required)

Oracle SQL Tuning Free Tutorial

There are often several ways to get the same answer from your Oracle Database.  But which version of the equivalent SQL query is faster? We need to learn how to tune SQL statements that produce equivalent results. 

Listen and watch as Oracle Master John Watson demonstrates why not all equivalent SQL statements are created equal. 
John demonstrates how SQL statements that produce equivalent result sets can have radically different response times, why this happens and common solutions.

In this free video tutorial, listen and watch as Oracle Master John Watson demonstrates why equivalent SQL statements are not all created equal when it comes to performance. 

John demonstrates how SQL statements that produce equivalent result sets can have radically different response times, why this happens and common tuning solutions.

...more...

Recorded Sep 12, 2012

On Demand!

View Training Video

 (Free Registration Required)

Application Express 4.1 New Features in Action

Have you upgraded to 4.1?  Are you making use of our favorite features? Oracle Application Express (APEX) 4.2 Early Adopter was recently announced, so if you haven't already its time to move to 4.1!

 

APEX 4.1 is packed with new features including the use of ROWID over primary keys, a standardized data upload process, row processing for tabular forms, and much more. 

 

In this session, Dan and Tyson  have picked out their top 10 favorite new features and will demonstrate them live in turn. If you're looking for a reason to upgrade, do not miss this session!

  

Dan McGhan & Tyson Jouglet of SkillBuilders co-teach this tutorial.  A great opportunity to learn from two of the best!  

...more...

Recorded Jul 26, 2012

On Demand!

View Training Video

 (Free Registration Required)

Solaris 11 New Features - ZFS File System Enhancements

Many new ZFS file system features have appeared in Oracle Solaris 11. In this free tutorial, via lectures and demonstrations, you will several critical enhancements.  Free registration is required.  

Prerequisites: Solaris Administration experience.  Some ZFS experience is helpful.  

Your instructor, Mick Hosegood, holds 3 Solaris Certifications and has been working 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.

Recorded Apr 11, 2012

On Demand!

View Training Video

 (Free Registration Required)

Oracle OCA/OCP Exam Tutorial - Data Retrieval with SQL SELECT

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.

...more...

Recorded Feb 29, 2012

On Demand!

View Training Video

 (Free Registration Required)

Oracle Database 11g New Features Adaptive Cursor Sharing

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.

...more...

Recorded Feb 8, 2012

On Demand!

View Training Video

 (Free Registration Required)

SkillBuilders Oracle APEX Plug-In Super LOV 2.0

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.

Free SkillBuilders Super LOV Download

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. 

...more...

Recorded Jan 12, 2012

On Demand!

View Training Video

 (Free Registration Required)

Free Tutorial - ZFS Management System / ZFS Storage Appliance

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.

...more...

Recorded Dec 22, 2011

On Demand!

View Training Video

 (Free Registration Required)

Oracle Database 11g New Features SQL Plan Management Baselining

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. 

Related Tutorials:

Recorded Nov 30, 2011

On Demand!

View Training Video

 (Free Registration Required)

Oracle Database Tuning Free Video Tutorial

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 including new parallelism features.  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.

Recorded Nov 10, 2011

On Demand!

View Training Video

 (Free Registration Required)

Learn How To Use Oracle Subqueries

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

...more...

Recorded Nov 4, 2011

On Demand!

View Training Video

 (Free Registration Required)

Rapid Deployment of Logical Domains / A Free Tutorial from SkillBuilders

Learn how to use ZFS backend storage for rapid deployment of Oracle VM Server for SPARC logical domains running the Solaris operating system.  Another name for this tutorial could be, "creating Solaris operating systems in minutes, not hours!"

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.

 

...more...

Recorded Oct 26, 2011

On Demand!

View Training Video

 (Free Registration Required)

Don't Do That! (in PL/SQL) with Steven Feuerstein

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.

...more...

Recorded Oct 25, 2011

On Demand!

View Training Video

 (Free Registration Required)

Installing Oracle VM Server for SPARC (formerly Solaris Logical Domains) on SPARC T-series Servers

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.

 

Recorded Oct 5, 2011

On Demand!

View Training Video

 (Free Registration Required)

Introduction to Advanced Ruby: What Makes Ruby Special

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

...more...

Recorded Sep 9, 2011

On Demand!

View Training Video

 (Free Registration Required)

Introducing SkillBuilders Modal Page Plug-in

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

...more...

Recorded Aug 31, 2011

On Demand!

View Training Video

 (Free Registration Required)

Oracle Geo Clusters Tutorial (Stretched / Extended Distance Clusters)

Oracle Geo Clusters are also called Stretched Clusters, Extended Distance Clusters

You want 100% percent uptime and zero percent data loss? Thinking big price tag for two licenses of Enterprise Edition plus RAC, Data Guard Active Standby Option? Perhaps not. We can do it for a fraction of the cost by building an Oracle GeoCluster with Oracle Standard Edition, RAC and ASM.

Learn how to design and configure an Oracle Geo Cluster in this free Tutorial.

Presenter: John Watson, Oracle Certified Master

Oracle Exadata 11g Certified Implementation Specialist
Oracle Certified Master
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
BSc Information Technology

Duration: 47 Minutes

Oracle Geo Clusters

More Oracle services provided by John.

...more...

Recorded Aug 25, 2011

On Demand!

View Training Video

 (Free Registration Required)

Keys to Oracle Certification

PL/SQL Programming Class Starts MONDAY, March 18, with Oracle Master John Watson

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.

...more...

Recorded Aug 17, 2011

On Demand!

View Training Video

 (Free Registration Required)

Oracle SQL Tuning Tutorial Feedback Optimization

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!

View Training Video

 (Free Registration Required)

Manual Tabular Forms in Oracle APEX: A Methodology that Works

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!

View Training Video

 (Free Registration Required)

jQuery in APEX - An Introduction for Database Developers

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. 

...more...

Recorded Jun 14, 2011

On Demand!

View Training Video

 (Free Registration Required)

Learn How To Use Oracle Analytic Functions

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

...more...

Recorded Apr 27, 2011

On Demand!

View Training Video

 (Free Registration Required)

Solaris Network Failover and Load Spreading Features

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

...more...

Apr 6, 2011

Learn More

Taking Advantage of Plug-ins in APEX, Dan McGhan, SkillBuilders

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

...more...

Feb 22, 2011

Learn More

jQuery in APEX - An Introduction for Database Developers

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

...more...

Recorded Feb 3, 2011

On Demand!

View Training Video

 (Free Registration Required)

'Look What You Can Do With PL/SQL!' with Steven Feuerstein

Steven Feuerstein gives you a whirlwind tour of some of the most exciting features of PL/SQL, including DBMS_ERRLOG, FORALL, BULK COLLECT and DBMS_UTILITY.FORMAT_ERROR_BACKTRACE. This webinar is a preview of Steven's upcoming 2-day seminar.

SkillBuilders presents Steven Feuerstein: "Best of Oracle PL/SQL"

January 26–27 at the Sheraton Needham, MA
Learn about the most important features of the PL/SQL language from a PL/SQL expert. Steven shows you how to apply these features in the context of best practices to write highly optimized, and easily maintained and enhanced, applications.

Please click on a link to watch this video in Windows Media Player:

...more...

Recorded Jan 26, 2011

On Demand!

View Training Video

 (Free Registration Required)

Dynamic Actions in APEX 4.0: What's Possible, What's Not, and How to Bridge the Gap

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 Oracle Application Express expert, Dan McGhan.

Audience - Anyone working with or interested in Oracle Application Epxress

Language: English

Duration: 53 minutes

...more...

Recorded Jan 13, 2011

On Demand!

View Training Video

 (Free Registration Required)

Groovy and Grails for Ellucian (SunGard) Banner Developers

The next version of Ellucian (formerly 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 programming and the Grails platform.

Language: English

Duration: 58 minutes

...more...

Recorded Dec 8, 2010

On Demand!

View Training Video

 (Free Registration Required)

What You Should Know About 11g CBO
(at the NYC Metro Area Oracle Users Group Meeting)

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

...more...

Recorded Dec 8, 2010

On Demand!

View Training Video

 (Free Registration Required)

Web Development with Ruby On Rails

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

...more...

Recorded Nov 12, 2010

On Demand!

View Training Video

 (Free Registration Required)

Dynamic Actions in Oracle Application Express (APEX) 4.0
(Presented at ODTUG APEXPOSED 2010)

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

...more...

Recorded Nov 11, 2010

On Demand!

View Training Video

 (Free Registration Required)

The Right Way to Secure Oracle

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

...more...

Recorded Sep 29, 2010

On Demand!

View Training Video

 (Free Registration Required)

Oracle APEX Plug-Ins

If you use Oracle Application Express (APEX) 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.

Free SkillBuilders APEX Plug-Ins Downloads.

Need a Consultant? Everything APEX!

Audience: Anyone interested in Oracle Application Express.

Language: English

...more...

Recorded Aug 4, 2010

On Demand!

View Training Video

 (Free Registration Required)

Rapid Development with the Grails Platform

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

...more...

Recorded Jul 9, 2010

On Demand!

View Training Video

 (Free Registration Required)

JavaScript in APEX – A Lesson for the PL/SQL Developer

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

...more...

Recorded Jun 29, 2010

On Demand!

View Training Video

 (Free Registration Required)

Oracle APEX 4 Free Tutorial

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

...more...

Recorded Jun 23, 2010

On Demand!

View Training Video

 (Free Registration Required)

Learn How To Use Oracle Analytic Functions

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

...more...

Recorded Jun 17, 2010

On Demand!

View Training Video

 (Free Registration Required)

Groovy for Java Developers

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

...more...

Recorded Jun 4, 2010

On Demand!

View Training Video

 (Free Registration Required)

Oracle Application Express as a Reporting Solution

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

...more...

Recorded May 5, 2010

On Demand!

View Training Video

 (Free Registration Required)

Designer/Developer Workflow with Flex 4 and Flash Catalyst

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

...more...

Recorded Mar 5, 2010

On Demand!

View Training Video

 (Free Registration Required)

jQuery Tabs in Oracle Application Express

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

...more...

Recorded Feb 3, 2010

On Demand!

View Training Video

 (Free Registration Required)

Using the Oracle 11g SQL Results Cache

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!

View Training Video

 (Free Registration Required)

Introduction to Oracle Application Express APEX

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

...more...

Recorded Dec 10, 2009

On Demand!

View Training Video

 (Free Registration Required)

Oracle Forms to Oracle APEX – A Migration Roadmap

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

...more...

Recorded Nov 18, 2009

On Demand!

View Training Video

 (Free Registration Required)

"Look What You Can Do With PL/SQL!" with Steven Feuerstein

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

...more...

Recorded Nov 3, 2009

On Demand!

View Training Video

 (Free Registration Required)

Introduction to Oracle Application Express

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

...more...

Recorded Oct 21, 2009

On Demand!

View Training Video

 (Free Registration Required)

Customizing Oracle Grid Control with User Defined Metrics and Reports

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

Get Presentation
 
(Free Registration Required)

Oracle Security: Guidelines for an Effective Audit

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!

View Training Video

 (Free Registration Required)

jQuery Tabs in Oracle Application Express

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

...more...

Recorded Sep 17, 2009

On Demand!

View Training Video

 (Free Registration Required)

Introduction to Oracle Data Guard

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

Get Presentation
 
(Free Registration Required)

Scaling to Infinity – Partitioning Data Warehouses on Oracle

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!

View Training Video

 (Free Registration Required)

Oracle 11g New Features – Part II

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

...more...

Recorded Jun 4, 2009

On Demand!

View Training Video

 (Free Registration Required)

Oracle 11g New Features

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!

View Training Video

 (Free Registration Required)

SQL Tuning: Analyzing Oracle SQL Execution Plans

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

...more...

Recorded Apr 13, 2009

On Demand!

View Training Video

 (Free Registration Required)

Shared Spreadsheet Nightmares? Oracle ApEx to the Rescue!

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

...more...

Recorded Apr 3, 2009

On Demand!

View Training Video

 (Free Registration Required)

Oracle Real Application Clusters (RAC) Free Video Tutorial

Please see:

Our NEW free Oracle RAC Video Tutorial

Our RAC class "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.

Presenter: OCM John Watson

Language: English

...more...

Recorded Mar 20, 2009

On Demand!

View Training Video

 (Free Registration Required)

Understanding and Using PL/SQL Arrays and Bulk Processing

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

...more...

Recorded Feb 27, 2009

On Demand!

View Training Video

 (Free Registration Required)

Understanding and Using XML

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

...more...

Recorded Feb 23, 2009

On Demand!

View Training Video

 (Free Registration Required)

Effective Use of Oracle SQL Trace

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

...more...

Recorded Jun 27, 2008

On Demand!

View Training Video

 (Free Registration Required)

SQL Injection: From the Basics to Botnet-Based Attack Automation

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

...more...

Jun 19, 2008

Learn More

An Introduction to SOA and Web Services

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 discussed 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

Learn More