Igot the opportunity during my first job to train a batch of professionals working on other programming languages about SQL, PL/SQL, Oracle and performance tuning and how best to write high performing SQL code. I was chosen as I had quite the expertise working with PL/SQL. I managed to find a cache of some documents and training materials I created for those sessions.

I have attached them with this post, but then please note other than the basic concepts there are new features that were non existent at that time and as such these are to be considered as historical.

Analytic-Functions

DatabaseConcepts

DataDictionary

DataTypes

Dependency-Issues

ER-Modelling

Explain-Plan

Export-Utility

HINTS

Histogram

Import-Utility

Indexes

IndexOrganizedTables

Joins

Key-Compression

Normalization

Parallel-Execution-of-SQL-Statements

Partitioning

Pipelined-Table-Functions

PLSQL

SQL-crash-course

SQL-Loader

Star-Schema

SQL-Tuning

Transaction-management

Varrays

Views