01Introduction to Oracle APEX4 topics
- What is Oracle APEX?
- APEX architecture and components
- Setting up an APEX development environment
- APEX user interface and navigation
02APEX App Builder5 topics
- Creating a new APEX application
- Application properties and attributes
- Pages and page types
- Regions and items
- Buttons and actions
03APEX SQL Workshop5 topics
- Accessing and managing database objects
- SQL Commands and scripts
- Object Browser and Query Builder
- Data Workshop and data loading
- RESTful Services and API management
04Interactive reports and grids5 topics
- Creating interactive reports
- Report columns and filters
- Pagination and sorting
- Highlighting and computations
- Interactive grids and editing
05Forms and data entry5 topics
- Creating forms and form pages
- Form regions and items
- Validations and error handling
- Dynamic actions and events
- Master-detail forms and relationships
06Navigation and page flow5 topics
- Navigation menus and lists
- Breadcrumbs and page branches
- Tabs and tab sets
- Modal dialogs and popups
- Controlling page access and security
07Themes and templates5 topics
- Built-in themes and styles
- Customizing theme attributes
- Page and region templates
- Template options and conditions
- Creating custom themes and templates
08Application logic and processing5 topics
- Page processing and computation
- Application processes and computations
- Branches and redirects
- Validations and error handling
- Debugging and error logging
09Security and authentication5 topics
- Authentication schemes and methods
- Access control and authorization
- Session management and timeouts
- Secure coding practices
- Auditing and monitoring
10Deployment and management5 topics
- Application export and import
- Application migration and promotion
- Workspace management and administration
- Performance tuning and optimization
- Best practices for APEX development
01Advanced APEX components5 topics
- Interactive Grids and editable reports
- Charts and data visualizations
- Maps and geospatial data
- Calendar and scheduling
- Tree and hierarchical data
02Dynamic actions and client-side interactivity5 topics
- Dynamic action types and events
- Client-side conditions and functions
- JavaScript and jQuery integration
- AJAX and server-side processing
- Animation and visual effects
03APEX APIs and plugins5 topics
- APEX JavaScript API and widgets
- Plugin architecture and development
- Custom item and region types
- Dynamic actions and processes
- Integrating third-party libraries and plugins
04Integration and web services5 topics
- Consuming REST and SOAP services
- Exposing APEX data as web services
- Integration with external databases and systems
- Single sign-on and federation
- Webhooks and event-driven integration
05Mobile app development with APEX5 topics
- Responsive design and mobile templates
- Mobile-specific components and actions
- Touch events and gestures
- Offline data and progressive web apps
- Hybrid mobile apps with Apache Cordova
06Performance tuning and scalability5 topics
- Application and page performance analysis
- Database and SQL optimization
- Caching and session management
- Asynchronous processing and background jobs
- Load testing and performance monitoring
07Debugging and error handling5 topics
- APEX debug mode and console
- Error handling and exception management
- Logging and monitoring
- Debugging dynamic actions and JavaScript
- Troubleshooting and issue resolution
08Version control and team development5 topics
- Version control systems (Git, SVN)
- Branching and merging strategies
- Collaborative development and code reviews
- Continuous integration and deployment
- Agile development methodologies
While Oracle APEX provides a powerful and comprehensive platform for rapid application development, integrating foundational web technologies like HTML, CSS, and JavaScript is crucial for elevating your applications beyond standard capabilities. These skills unlock advanced customization, dynamic interactivity, and a polished user experience, transforming functional APEX apps into sophisticated and engaging solutions.
</>HTML
Structuring Custom Content
Learn to leverage HTML to build custom components, intricate layouts, and integrate external content seamlessly within your APEX pages, providing a robust structural foundation.
{ }CSS
Styling and Visual Refinement
Master CSS to brand your APEX applications, customize themes, and implement modern UI/UX designs. Achieve pixel-perfect control over the visual presentation, aligning with corporate identity or contemporary web aesthetics.
( ) =>JavaScript
Dynamic Interactivity and Logic
Utilize JavaScript to introduce dynamic behaviors, client-side validation, complex user interactions, and integrate with external APIs. Push the boundaries of APEX's native capabilities to create truly responsive and interactive applications.
By combining the declarative power of Oracle APEX with the flexibility of HTML, the aesthetic control of CSS, and the dynamic capabilities of JavaScript, you will be equipped to develop highly customized, feature-rich, and visually appealing web applications. These combined skills are essential for any full-stack Oracle developer aiming to deliver top-tier solutions.
CapstoneApply Your Skills: Capstone Project
- 01
Project Selection
Students and the instructor work together to choose a project relevant to their interests and skill level.
- 02
Design and Development
Students apply their Oracle APEX knowledge to design, build, and deploy a real-world application.
- 03
Presentation and Evaluation
Students showcase their completed project and receive feedback from the instructor and peers.
