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 | Advance Procedural Language (PL/SQL) | 1 month |
| Overloading SubPrograms | |
| Using UTL_MAIL | |
| DBMS_METADATA Package | |
| Managing Dependencies | |
| Database Triggers | |
| Total | 3 month |
| | |
Course | Database Developer | |
Job Title | Backend Developer / Database Support Engineer / DB Developer |
Tool | Oracle Database with SQL Devloper | |