Learning Oracle Application Express ( Oracle Apex ) Training

Create a database-based application in Oracle Apex using the wizard, exploring home page setup, desktop and mobile interfaces, and building a report in form with a movie table.

Explore the types of Oracle Application Express applications, generate pages with interactive reports and forms, reuse shared components, set authentication, themes, and saved reports, and customize your app quickly.

Create a database-based web application quickly with Oracle Application Express wizards, which generate plumbing code to maintain transactional consistency in a stateless environment, though it may require tweaks for production.

Explore creating a new Oracle APEX app using the wizard, leveraging shared components, authentication options, and themes; generate PL/SQL code and a fully functional interactive report with edit and sort.

Learn how to customize pages and regions in Oracle APEX, beyond the wizard, using page rendering, dynamic actions, and various region types (forms, reports, charts) to build production-quality apps.

Explore Oracle Application Express wizards, build and customize regions and forms from the movie table, and understand how simple or complex wizards generate code and support future edits.

Explore how the wizards in Oracle Application Express let you quickly add and rearrange regions, forms, and charts, including a 2D column chart of movie ratings.

Go beyond apex wizards by editing generated pages, adjusting regions and items, and hiding fields like sales rep id to finalize a production-ready application.

Learn how to customize the notes field in Oracle Application Express by switching to a text area and watching automatic page redraws, with wizard-driven form work and P3 item naming.

Explore Oracle Application Express page rendering, create a new app with the wizard, and compare treeview and component view for placing computations before header or after footer.

Explore page rendering in Oracle APEX part 2 by building branches, computations, and before-header processes, with desktop or mobile routing, ad redirects, and an audit log using substitution strings app_user.

Learn how Oracle Application Express page rendering fires an audit process on every page access, writing the logged-in user to the movie audit table and tracking header, regions, and footers.

Learn to build a form region in Oracle apex using the form wizard to base a page on a table and manage primary keys (two columns or rowid).

Discover how Oracle Apex forms hide primary keys, select visible columns and buttons, and generate a functional page; learn to add lists of values for valid, user-friendly data entry.

Create and apply shared lists of values in Oracle Apex forms to convert text fields into select lists, using static values, display values, and cascading lists.

Create a master-detail form in Oracle APEX by granting the movie schema access to HR tables, then configure a page linking departments to employees with primary keys department_id and employee_id.

Explore forms in Oracle Application Express by building master-detail regions with departments and employees, using existing triggers to populate IDs, and configuring master-detail pages and tabular forms without programming.

Explore building and configuring tabular forms in Oracle Application Express (APEX), including update, insert, and delete operations, primary key handling, value lists, and exporting data to CSV.

Learn to create and customize interactive reports in Oracle Apex, build queries with a wizard, configure columns and sorting, save user-specific report versions, and export via CSV or email.

Explore configuring interactive reports in Oracle Application Express by editing page regions, region attributes, and display conditions. Learn how to enable security, customization, and saved reports for end users.

Manage apex reports by deleting saved reports, configuring print attributes, and setting up a report server in the internal workspace to streamline production deployment and explore interactive reports.

Learn to create and arrange classic reports in Oracle APEX by editing pages, adding regions, and using the query builder for the movie audit.

Explore apex regions and the interactive, classic, and wizard report types, including cross-schema data access via the query builder and HR and movie schema privileges.

Master charting in Oracle APEX by creating a chart region and choosing a chart type. Use the build query wizard to format data with aliased columns: link, label, and value.

Learn to customize oracle apex charts by editing the chart query, joining orders and HR employees to show last names, and using wizard-based attributes to switch looks and format axes.

Explore Oracle Application Express maps by using the HR locations data and the state province field to build a country and state map, counting locations per state.

Explore how Oracle Apex trees visualize hierarchies such as an org chart using a self-referencing employees table, aided by a wizard to build and display relationships.

Create an apex calendar driven by the employees hire date, displaying last names and dates with the easy calendar wizard.

Explore Oracle Application Express Apex regions other types, including blank pages, wizard pages, data loading, and feedback pages, and learn how global pages differ from templates for consistent applications.

Learn how Oracle Apex shared components enable reusability across an app by creating application items and computations, configuring page and application level processes, and integrating web services for enhanced functionality.

Master Oracle Apex shared components and build options to include or exclude deployment pieces, reuse data loading rules (Excel to Oracle Database), and leverage globalization, navigation, and reports.

Explore dynamic actions in Oracle Apex, turning page events into JavaScript-like logic to create master-detail interactions, with examples like a lose focus alert and multiple actions based on conditions.

Learn how to use tabs and tab sets in Oracle Application Express to organize pages, assign default pages, and provide visual navigation clues for end users.

Learn to create links between pages in Oracle Apex by using the f procedure and URL parameters such as application ID, page, session, and debug to drive navigation.

Design an Oracle APEX app that links pages via a calendar and an employee form, turning names into links that open the edit page with prefilled data.

Explore how Oracle Application Express uses themes and templates to define page visuals. Copy and customize templates, preview changes, and assign them to pages via substitution strings and CSSA file.

Explore how Oracle Application Express manages themes and templates, including selecting, creating, exporting, and importing themes, customizing templates, and the impact on active themes and other developers.

Learn to apply and manage themes and templates across your Oracle APEX application, switching themes, validating compatibility, and making global UI changes through pages, regions, and items.

Explore how to customize the Oracle Application Express login template by uploading an image, modifying the Chris login template, and using logo substitution to display a logo across pages.

Learn how users customize their interface in Oracle Application Express by using dynamic actions to change region styles, such as background colors, via color buttons.

Learn the differences between mobile and desktop development in Oracle APEX, covering gestures like swipe, long press, and drag-and-drop, and how jQuery Mobile enables mobile widgets and themes.

Explore how to add a mobile smartphone theme to an Oracle Application Express app and adapt desktop interfaces to mobile using templates and list view and interactive report.

Create a mobile page in Oracle Application Express using the mobile smartphone interface, with a form on the movies table and select lists built from lists of values.

Learn to enhance Oracle Application Express (Apex) mobile applications with ThemeRoller and PhoneGap, using a graphical editor to customize templates and access device features, noting these tools are not Oracle-supported.

Explore authentication schemes in Oracle Application Express, from application express and database accounts to custom schemes, app directory, and no authentication, with setup steps and gallery options.

Create and use user groups in Oracle APEX to conditionally display page regions, using a current user in group check to hide or show content for power users.

Enable and review debug information in Oracle APEX to identify page bottlenecks, using view identifiers and the debug tab to examine load times, queries, and session data.

Explore Oracle Application Express team development features that enable collaboration, including feedback from end users, milestones, features, to-dos, and bugs, with role-based access for developers and administrators.

Explore three Oracle APEX deployment options—the embedded gateway, an Apache-backed web server, and the APEX listener—highlighting production readiness and how REST Data Services enables web services for APEX applications.

Explore how Oracle Application Express creates and consumes web services, using REST and SOAP architectures, to build composite applications by referencing and reusing weather and forecast operations.

Master Oracle application express, a browser-based development environment, by exploring workspaces, applications, pages, regions, and forms, reports, and charts, plus templates, themes, and basic administration.