Feb
28
2016Oracle Training Materials
I got 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 today, 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.
| Topic | Attachment |
| Core Database Concepts | DatabaseConcepts |
| Data Dictionary | DataDictionary |
| Data Types | DataTypes |
| Views | Views |
| Transaction Management | Transaction management |
| Index Organized Tables | IndexOrganizedTables |
| Indexes | Indexes |
| Joins | Joins |
| Explain Plan | Explain Plan |
| Oracle Hints | HINTS |
| Parallel Execution of SQL Statements | Parallel Execution of SQL Statements |
| Partitioning | Partitioning |
| Training – SQL Tuning | Training – SQL Tuning_Updated |
| ER Modelling | ER Modelling |
| Normalization | Normalization |
| Star Schema | Star Schema |
| Analytic Functions | Analytic Functions |
| Pipelined Table Functions | Pipelined Table Functions |
| Histogram | Histogram |
| Key Compression | Key Compression |
| Dependency Issues | Dependency Issues |
| Export Utility | Export Utility |
| Import Utility | Import Utility |
| SQL Loader | SQL Loader |
| PL-SQL | PLSQL |
| Varrays | varray |
| SQL-crash course | SQL-crash course |
