PL/SQL and SQL Injection: Stop Hacking via PL/SQL – Free Tutorial
Prevent SQL Injection through PL/SQL! Secure your Oracle applications! Learn how Oracle PL/SQL with dynamic SQL is susceptible to hacking with SQL Injection. In...
What is REST Enabled SQL
Learn how to access a remote Oracle database with REST enabled SQL! SkillBuilders’ expert Garry Lawton will define and demonstrate the functionality of Oracle...
Common Oracle SQL Tuning Errors
We see some SQL performance (tuning) problems in the Oracle Database over and over again: certain SQL constructs that are known to be inefficient...
When to use Oracle Bitmap Indexes, Tips for Data Warehouse – Free Tutorial
Indexing your VLDB Oracle Database or Data Warehouse for best performance? There are cases, depending on data structures and queries, where b-tree indexes are...
Oracle Tutorial – B-Tree Indexes: What, Why and More
What are Oracle indexes? How do they work? What is a b-tree index? When should you use them? When should you avoid creating indexes?...
Oracle 12c SQL Performance Features
Learn new SQL performance features offered in Oracle Database 12c! Oracle Certified Master John Watson and DBA Dave Anderson will demonstrate several Oracle Database...
Oracle SQL Tuning for Beginners Free Tutorial
Learn Oracle SQL Tuning! We’d like to introduce you to our SQL Tuning courses. The free video lessons below are excerpts from our “Core...
Oracle Database SQL Tuning with Constraints
Learn how to tune SQL – especially in a data warehouse – with CONSTRAINTS. Constraints provide critical information to the Cost Based Optimizer in...
How to Get Secure Web Services (SSL/HTTPS) and Oracle APEX Working
Learn How to Call Secure Web Services (SSL/HTTPS) from Oracle APEX applications! More and more APEX developers need to call (consume) web services from...
Advanced Oracle SQL Aggregations for Data Warehouse – Free Tutorial
How to Query an Oracle Data Warehouse with Advanced Aggregations (LISTAGG, FIRST, LAST, ROLLUP, Cube and more). The original SQL language focused on providing...