Online/Offline Course: Software Development by Oracle with a Live Project
Course at a glance
Course Contents:
- SQL
- PLSQL
- APEX
- Live Project
Course Duration: 6 Month
Payment : BDT 29,500.00
Payment Method:
With Admission: 10000.00
After Complete SQL: 10000.00
After Complete PL/SQL: 9500.00
Training Method
ORACLE 11g SQL |
| 1. Fundamental Database | 2. Creating Tables & Constraints |
| 3. Retrieving Data Using the SQL SELECT Statement | 4. Restricting and Sorting Data |
| 5. Row Functions to Customize Output | 6. Reporting Aggregated Data Using the Group Functions |
| 7. Displaying Data from Multiple Tables | 8. Displaying Data from Multiple Tables |
| 9. Using Subqueries to Solve Queries | 10. Control transactions |
| 11. Creating Other Schema Objects | 12. Managing Objects with Data Dictionary Views |
| 13. Controlling User Access | 14. Managing Schema Objects |
| 15. Manipulating Large Data Sets | 16. Generating Reports by Grouping Related Data |
| 17. Managing Data in Different Time Zones | 18. Hierarchical Retrieval |
| 19. Regular Expression Support | 20. Exam |
ORACLE 11g PL/SQL |
| 1. Introduction to PL/SQL | 2. Declaring PL/SQL Identifiers |
| 3. Writing Executable Statements | 4. Interacting with the Oracle Server |
| 5. Writing Control Structures | 6. Working with Composite Data Types |
| 7. Using Explicit Cursors | 8. Handling Exceptions |
| 9. Creating Stored Procedures | 10. Creating Stored Functions |
| 11. Creating Packages | 12. Using More Package Concepts |
| 13. Utilizing Oracle Supplied Packages in Application Development | 14. Dynamic SQL and Metadata |
| 15. Design Considerations for PL/SQL Code | 16. Managing Dependencies |
| 17. Manipulating Large Objects | 18. Creating Triggers |
| 19. Applications for Triggers | 20. Understanding and Influencing the PL/SQL Compiler |
ORACLE Apex 20.2 |
| 1. Form Builder | 2. Tabular Form |
| 3. Customized Form | 4. Procedure Form |
| 5. Report Builder | 6. Customized Report |
| 7. Parameterize Report | 8. Updatable Report |
| 9. Interactive Report | 10. Chart |
| 11. Invoice/Bill Generation | 12. Branching |
| 13. Data Validation | 14. Process |
| 15. Plugins | 16. Export & import front end |
| 17. Create application for j-quary mobile version | 18. |
