Oracle Academy: Application Express – Application Development Foundations (Online) 2021-2022

This 90 hour online course introduces you to the techniques and tools required to develop database driven web applications. The course teaches you how to design, develop and deploy beautiful, responsive, database-driven web applications using Oracle Application Express. Leveraging project-based learning techniques, you will create and work with projects which challenge them to design, implement, and demonstrate a database-driven web application solution for a business or organisation.

This course should be taken after Database Programming with PL/SQL

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

You should have substantial database and SQL knowledge such as that taught in:

• Database Design and Programming with SQL
• Database Programming with PL/SQL

Section 1 - Introduction

• 1-1 Course Overview
  • Course Objectives
  • Course Agenda
  • Recommended Prior Knowledge
  • More Information on Oracle Application Express – APEX
  • Describe Oracle Application Express
  • Explain the key features of Oracle Application Express
  • List and describe the components of Oracle Application Express
  • Describe Oracle Application Express architecture
  • Log in to Oracle Application Express
  • Install and run a packaged app

  Section 2 – Create a Basic Database Application

  • 2-1 Using SQL Workshop
    • Describe SQL Workshop and list its components
    • Browse through database objects using the Object Browser
    • Create and modify database objects
    • Create a lookup table
    • Run SQL commands and SQL scripts
    • Load and unload data using Data Workshop utility
    • Build a SQL query using Query Builder
    • Generate DDL statements
    • Explain App Builder concepts
    • Describe the types of applications you can build using Application Express
    • List the components of a database application
    • Determine your application user interface
    • Create a database application from scratch
    • Create a database application from a spreadsheet
    • Create a mobile web application
    • Create a Websheet application

    Section 3 – Pages, Reports, and Grids

    • 3-1 Managing Pages in Page Designer
      • Explain application page components
      • Create an application page and view its definition
      • Manage pages in page designer
      • Describe page designer UI elements
      • Add page components
      • List the type of reports that you can create in Application Express
      • Describe the different ways of creating reports in Application Express
      • Create an interactive report
      • Create an interactive grid
      • Create a classic report
      • Create a report and form
      • Describe interactive report components
      • Use and customize an interactive report as an end user
      • Manage interactive report attributes
      • Configure the display of interactive report controls as a developer
      • Manage interactive grid attributes
      • Control Interactive Grid Pagination
      • Customize the Interactive Grid Toolbar
      • Enable Users to Save Public Interactive Grids
      • Customize interactive grid as an end user

      Section 4 – Forms and page Controls

      • 4-1 Creating and Using Forms
        • Describe an application form in Application Express
        • List the different types of application forms that you can create in Application Express
        • List the different wizards you use to create forms
        • Create an editable interactive grid
        • Create a form on a table and link a report to a form
        • Create a single page master detail form
        • Create a two page master detail form
        • Modify a form
        • List different types of page-level items
        • Create and use page-level items
        • Create and use buttons
        • Explain page rendering and page processing
        • Create computations
        • Create page processes
        • Create validations
        • Create branches

        Section 5 – Navigation, Themes, and Security

        • 5-1 Implementing navigation in your Application
          • Describe the use of shared components in an application
          • Create, edit, and use the shared components that aid navigation in an application
          • Describe themes and templates
          • Create and use a new theme
          • Describe Universal Theme, Theme Roller, and Template Options
          • Use Theme Styles
          • Use Theme Roller, and Live Template Options
          • Upload and use a CSS
          • Explain how to secure your application
          • Describe authentication and authorization
          • Create and use an authentication scheme for your application
          • Create and attach an authorization scheme to your application, page, or components

          Section 6 – Adding to and Migrating an Application

          • 6-1 Adding Additional Pages to your Application
            • Create, customize and use Oracle JET Charts
            • Create, customize and use Calendars
            • Create, customize and use Trees
            • Describe Dynamic Actions
            • Create and use Dynamic Actions
            • Describe Plug-ins
            • Implement Plug-ins in your application
            • Describe the steps involved in migrating an application between environments
            • Export the application definition, underlying database objects, and data from your development environment
            • Import the application definition, underlying database objects, and data in the target development environment

            Final Project

            System requirements

            What is needed to access Oracle iLearning:

            A browser, either:

            • IE | Edge | Chrome | FireFox | Safari
            • Cookies must be enabled
            • Pop-ups must be allowed
            • Adobe Acrobat Reader

            Each course is approximately 90 hours on a self study basis, however the course should be completed within one year of enrolment.

            Related courses
            • Oracle Academy: Database Design and Programming with SQL (Online)
            • Oracle Academy: Database Programming with PL/SQL (Online) 2021-2022
            • Oracle Academy: Database Foundations (Online) 2023-2024
            • Databases
            • Programming and Scripting