Kursplan
Introduction
- Overview of Oracle APEX features and architecture
- Understanding database applications
- Introduction to APEXlang: The human-readable application definition language
Getting Started
- Installing Oracle APEX
- Accessing the development environment
- Exploring the UI and tools
- Setting up external tooling: Oracle SQL Developer for VS Code and SQLcl for APEXlang
Creating an Application
- Setting up the workspace
- Using the Create Application wizard
- Adding and removing application features
- Creating a database app from a file
- Using an application blueprint
- Copying an existing database application
- Creating an application for mobile devices
- Generative AI Development: Building apps from structured APEXlang specifications
- Configuring application attributes
- Managing application groups
- Using application and workspace utilities
Managing Pages
- Adding pages to an application
- Creating dialog pages
- Branching with dialog pages
- Copying database application pages
- Deleting database application pages
- Locking and unlocking pages
- Programmatic team development: Using APEXlang locking and working copy APIs
Using Page Designer
- Navigating the Page Designer UI
- Managing page attributes
- Running a page from Page Designer
- Using the runtime developer toolbar
- Copying and deleting an application page
- Co-developing UI: Synchronizing App Builder workflows with APEXlang text files (.apx)
Building Reports and Forms
- Creating a report using the wizard
- Managing cards in a page
- Creating and editing faceted search pages
- Customizing interactive grids and reports
- Managing classic reports
- Viewing and printing reports
- Understanding form types
- Creating a form using the wizard
- Creating master details forms
- Validating user inputs
- Working with BLOBs
Customizing Application Controls and Navigation
- Managing page-level items
- Adding dynamic actions, buttons, and trees
- Creating navigation menus, breadcrumbs, and tabs
- Using computations, validations, and processes
- Working with shared components
- Extending application functions (e-mail, plug-ins, globalization, etc.)
Managing Application Security and Performance
- Security best practices
- Controlling access to applications, pages, and components
- Configuring user identity (authentication and authorization)
- Identifying performance issues
- Logging and reporting
- Creating custom reports
- Testing and debugging applications
Deploying Applications
- Understanding the deployment process
- Creating, managing, and upgrading custom applications
- Building the applications and components
- Publishing the database application URL
- Exporting applications as APEXlang packages (structured .apx files, native SQL, and assets vs. monolithic SQL scripts)
- Source Control integration: Managing APEXlang in Git and automating CI/CD pipelines
- Importing and installing exported files
- Targeted updates: Executing File-Level Imports from an APEXlang package
- Managing environment configurations using APEXlang Deployment Files
- Deploying an application remotely
Troubleshooting
Summary and Next Steps
Krav
- Erfarenhet av apputveckling
- Kännedom om Oracle SQL Database
Målgrupp
- Utvecklare
Vittnesmål (4)
Det var en till en-situation, så jag kunde visa honom min existerande miljö och diskutera mina verkliga problem
Virendra Miglani - Westfraser Mills
Kurs - Developing Applications with Oracle Application Express (APEX)
Maskintolkat
Att skapa mitt eget program och lära mig grunderna i Oracle Apex
Jamie - Northern Ireland Water
Kurs - Developing Applications with Oracle Application Express (APEX)
Maskintolkat
Ämnet var intressant, och utbildaren var väldigt vänlig och har omfattande kunskap i ämnet.
Jacqueline - Tribal Grou[
Kurs - Developing Applications with Oracle Application Express (APEX)
Maskintolkat
Sättet som tränaren demonstrerade allt
Manveen - Tribal Grou[
Kurs - Developing Applications with Oracle Application Express (APEX)
Maskintolkat