Onkar Joshi's blog

Index: Other posts on training in this series

After 5 days of classroom sessions, 2 days exclusively for practice and finally another day for the test, I am through with training on Oracle PL/SQL.

Some of the topics we covered include basic Oracle architecture and PL/SQL constructs, Records, Tables, Cursors, Exception Handling, Procedures and Functions, Packages, Triggers, Objects, VArrays etc.

No reference material was allowed during the test. Only Notepad was available as an editor.

The test wasn’t too tough and like all the other tests we’ve had so far focused on the basics of what was covered which one would definitely be familiar with by the end of the course. Practice should ensure that you don’t get stuck on little things and have enough time to complete and check your code. And besides helping in the test, it should make one confident about using PL/SQL in the real world which is actually much more important.

Last module of technical training, UNIX shell programming, coming up Monday onwards! I’m already familiar with it so hope to be able to be able to concretize what I already know and pick up valuable additions on my way to the test. Borrowed Sumitabha Das’ UNIX book from the library when returning the PL/SQL book by Ivan Bayross. The schedule for UNIX training is 3 days of training. 1 day for practice. And another day for the test.