Prerequisites for Technical Oracle Apps Training
|This blog is an effort to help you become a technical Oracle Apps consultant. In this blog, I will publish articles on Oracle Applications training right from the very basics.|
In my case, 10 years ago, I first took training in some programming languages like C,C++,VB, & of course Oracle. The good thing that came out was that I realised all programming languages have a commonality, i.e logic. But logic iwas the thing I feared the most, I never knew I could do it. At university, I had always bunked my Fortran and Unix lessons simply because of the logic phobia I had in my mind. Anyway, eventually I learnt Oracle SQL-PL/SQL, Forms and Reports. The bottom line is, keep your fears aside and take the dive and get started with the learning path.
Please note the pre-requisites. Kindly note that you can't jump onto becoming an Oracle Apps Technical Career path without having learnt the prerequisites that will form the base of Oracle Apps Development work.
1. Learn SQL and PL/SQL.
Firstly learn SQL. I think this link for w3schools will get you started from the very basics. You may also install Oracle Lite from technet and practice some SQL. Just the basic SQL with couple of joins and couple of where classes is good enough to get started. When learning SQL, try to imagine/visualize the scanning and filtering of records that Oracle will be performing behind the scenes.
2. Learn D2k. More importantly Oracle Forms 6.0 and Reports 2.5/3.0. All you need to learn are the fundamentals at this stage. You should be able to created a Master Detail block based form that calls from PL/SQL and one pll. For Oracle Reports, you must try to develop a report from scratch that has at least two queries with one link joining the two. You should also know things like formula column, b4 report & after param triggers.
3. It is good to know some Java Programming, however, knowledge of java has not yet become mandatory for Oracle Apps Technical Consultants. Ditto for XML and HTML. If you are a beginner, then don’t bother to learn Java right now. Java can be learnt in parallel while you work on Oracle Applications.
Once having learnt the above tools, you will then be ready to begin Oracle Apps Technical Training from scratch.