Learn Oracle SQL
Learn Oracle SQL, PLSQL, SQL Loader and Performance Tuning.
1. SQL
a) Datatypes
b) Tables, Views, Synonyms and Sequences
c) Manipulating Data
d) Querying Data
e) Indexes
2. PLSQL
a) Cursors
b) Procedures
c) Functions
d) Packages
e) Database Triggers
f) PLSQL Datatypes, PLSQL tables, records and Bulk processing.
3. SQL Loader
a) Preparing Control File
b) Preparing Input file
4. Performance Tuning
a) Getting Trace
b) Running Explain plan
c) Analyzing Trace file and identifying bottlenecks.
d) Understanding Database Locks