Prerequisites:

Experience in advanced SQL & PL/SQL

Audience :

1- Administrator
2 – Developer
3 – Implementer

Objectives :

1 – Link one form module to another
2 – Create form modules, including components for database interaction and GUI controls.
3 – Display form modules in multiple windows and use a variety of layout styles
4 – Test form modules in a Web browser
5 – Debug form modules in a 3-tier environment
6 – Implement processes to enhance form functionality
7 – Reuse objects and code

Topics: 
Course Content (According to Oracle University) :

Course Content (According to Oracle University) :

1. Getting Started with Oracle APEX on the Oracle Autonomous Database
2. Describe Oracle APEX
3. Creating and Managing a Workspace
4. List and describe the major components of Oracle APEX
   
   
5. Using SQL Workshop
6. Create and modify database objects
7. Run SQL Commands and Scripts
8. Load and Unload data using the Data Workshop Utility
9. Generate SQL using Quick SQL
   
   
10. Creating an APEX Application
11. Create an APEX application based on existing tables
12. Create an APEX application from a file
13. Create a progressive web application (PWA)
14. Managing Application Attributes with App Builder Concepts
    
    
15. Working with Pages and Regions
16. Create different page types and regions
17. Manage pages in Page Designer
18. Manage page attributes
19. Add Page Components
20. Developing Reports
21. Create and customize the interactive report
22. Create and customize the interactive grid
23. Create and customize the classic report
24. Create a report with a form
25. Create and customize Cards
26. Create and customize Smart Filter
27. Create and customize a faceted search page
    
    
28. Creating and Using Forms
29. Create an editable interactive grid
30. Create a simple form and link a report to this form
31. Create different types of master-detail forms
32. Modify a form
33. Creating Application Page Controls
34. Create and use page-level items and buttons
35. Adding Computations, Processes, Validations, and Branches
36. Create computations
37. Create page processes
38. Create validations
39. Create branches
40. Implementing Navigation in Your Application
41. Create, edit, and use the following shared components that aid navigation in an application: Lists, Navigation Menus. Breadcrumbs, Navigation bar entries
42. Search Configurations
43. Managing Application Data
44. Use Collections
45. Manage REST Enabled SQL References
46. Manage REST Data Sources
47. Data Synchronization
    
    
48. Using Themes and Theme Styles
49. Create and use a new theme
50. Use Theme Styles
51. Use Theme Roller and Live Template Options
    
    
52. Extending Application Capabilities
53. Sending E-Mail from an application
54. Automation
55. Approvals and Unified Tasks Lists
56. Describe and Implement Plug-ins in your application
    
    
57. Implementing Security in Your Application
58. Create and use an authentication scheme for your application
59. Create and attach an authorization scheme to your application, page, or components
60. Using Session State Protection
61. Adding Additional Pages to Your Application
62. Oracle JET Charts
63. Calendars
64. Trees
65. Maps
66. Creating and Using Dynamic Actions
67. Create and use Dynamic Actions
68. Implement Plug-ins in your application
69. Migrating Application Development Between Environments :
    
    
70. Export the application definition, underlying database objects, and data from your development environment and import them into the target development environment
71. Perform One-click Remote Application Deployment

Course Content Reference :
https://education.oracle.com/oracle-apex-cloud-developer-professional/pexam_1Z0-770

Reports :

1 – Jasper Report

2 – BI Publisher Report

About Muhammad Abdullah Al Noor, Chief Trainer of TrainerBD.com

Muhammad Abdullah Al Noor is an ICT professional and software developer having 20+ years hands-on experience in creating large ERPs with Oracle. He is an MBA (MIS) and OCP (Oracle Certified Professional). His areas of expertise are Project Management, Software Development with Oracle, Oracle Database Administration, Oracle Database Performance tuning and lead team of Oracle developers and Oracle DBA. He had successfully conducted a good number of sessions on Oracle Database and Programming Training up to advance level.

Learn More ..

Payment Procedure :