Steps | Modules | Duration |
1 | Structured Query Language (SQL) | 1 month | |
| Installation and deinstallation of Oracle database | | |
| Intro to SQL | | |
| Restriction and sorting data | | |
| Single Row Function and Group Functions | | |
| Joins and Subqueries | | |
| DML and DDL | | |
| Scheme Objects | | |
| Managing objects with Data Dictionary Views | | |
| | | |
2 | Procedural Language (PL/SQL) | 1 month | |
| Introduction to PL/SQL | | |
| Lexical units in PL/SQL | | |
| Composite Datatypes | | |
| Handle Exceptions | | |
| Developing Procedures and Functions | | |
| | | |
3 | Forms and Report | 1 month | |
| Installation and deinstallation of Oracle Development Suite | | |
| Create Basic Form Module | | |
| Master Detail Form | | |
| Work with DataBlocks and Frames | | |
| Creating Input items and Non Input items | | |
| Runtime Message and Alerts | | |
| Query Triggers | | |
| Validation and Navigation | | |
| Multiple Form Application | | |
| Design and developed Report | | |
| Total | 3 month | |
| | | |
Course | Enterprise Resource Planning Development | | |
Job Title | ERP Developer | | |
Tool | Oracle Development Suit and Oracle Database | | |