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 …
All dates are in Eastern Time (ET).