PL/SQL and SQL Injection: Techniques to hack an Oracle Database (and how to block them)
Prevent SQL Injection through PL/SQL! Secure your Oracle applications! Oracle PL/SQL has the ability to run dynamically created SQL statements. Some developers find this useful, some hackers find it even more useful. This webinar will demonstrate some commonly used techniques …
Record Locking in APEX and other Connection Pooled Environments
We will cover the following major topics: The Issue * Multi-user applications and data corruption * The LOST UPDATE problem Potential Solutions * Pessimistic Locking * Optimistic Locking * Pros and Cons of each Dedicated Connection vs Connection Pooled Environments …
Oracle Tuning Webinar: Why Some SQLs Destroy the Performance of the Database (And techniques for fixing them)
Why do some SQL constructs monopolize so much of the database resources? (destroy database performance) How can I fix / tune these terrible, resource intensive SQLs? Oracle Certified Master DBA John Watson will demonstrate some of these with alternative structures …
How to Create a Physical Standby Database
Learn Oracle Data Guard! This two hour webinar is an extract from our Data Guard course, detailing the creation of a basic Physical Standby database. The demonstrations will go through the entire process, starting from a pre-existing noarchivelog mode database …
Learn REST Enabled SQL to Access a Remote Database
Learn how to access a remote Oracle database with REST enabled SQL! SkillBuilders’ experts Tyson Jouglet and Garry Lawton will demonstrate the functionality of Oracle ORDS and APEX integration using REST Enabled SQL instead of a traditional DB Link (and …
Better Oracle Analytics with Advanced SQL Aggregations
Learn Oracle Analytics with (advanced) SQL aggregations such as LISTAGG, ROLLUP and CUBE! Our Oracle Advanced SQL Tutorial Series provides an in-depth look at Oracle’s Advanced SQL capabilities. Previous tutorials have reviewed features such as Analytic Functions, Advanced Use of …
Dynamic Actions for Super Heroes, An Oracle APEX Webinar
Regardless if you are new to APEX or have doubts about mastering your dynamic actions, this is a session for you. We will demystify all corners of DA and how they can be utilized in your applications, including: • How …
Universal Theme: Understanding Core Technology and Lesser-Known Features
REGISTER FOR THIS WEBINAR The Universal Theme provides a plethora of tools to quickly build sleek and responsive applications. For more complex applications, you may want to either manipulate the page to perform certain actions or adjust the display. In …
Universal Theme – Basic Principles to Modern Applications
REGISTER FOR THIS WEBINAR How difficult can it be to create modern and responsive app using Oracle APEX 18.x/19.x? In this demo session we will build a public facing app following a few basic principles to demonstrate the power of …
All dates are in Eastern Time (ET).