Breadcrumb for learning path

Main Parent

Learning Path Details Parent

Information

Oracle Application Express: Developing Database Web Applications

This series of hands-on labs are part of the course Oracle Application Express: Developing Database Web Applications. The labs are designed to teach you how to build applications using Oracle Application Express. The primary vehicle for teaching is a single use case which is expanded on with each lab.

Enroll the User-Public

Learning_path_filler

Learning_path_icons

Beginner
350 Min
17 Modules

Learning Path Contents

Module Sections Topics and more

  • About this Course
      5 Min

    Before you begin this course, be sure to read the Hands-on-labs guide by clicking Show.

    • To view the Lab Guide source, go to the github oracle repository.
    • To log issues, go to the github oracle repository and log an issue first.
    • Steps to contribute translated material:
      1. Go to the github oracle repository and log an issue first. See Contributing guidelines. Alternatively, you can send an email to the mailing list: oracle-application-express_ww@oracle.com with the subject "Oracle APEX-GitHub Request".
      2. You are then added as a contributor to this GitHub repository.
      3. Upon acceptance, these contributions are pulled and merged with the github oracle repository.
    • Steps to contribute translated slide decks for the lessons in the course material:
      1. Go to https://apex.oracle.com/education and accept the Creative Commons and UPL License Agreement for Oracle Application Express Curriculum. Download the apex-curriculum-3681867.zip file and then extract the apex-curriculum-ppts folder.
      2. Translate the PPTs and then send an email to the mailing list: oracle-application-express_ww@oracle.com with the subject "Oracle APEX-Curriculum Request".
      3. Upon review and acceptance, the translated material is hosted on https://apex.oracle.com/education
     
    Show
  • Unit 1: Getting Started with Oracle Application Express
      10 Min
    To log in to Oracle Application Express, you need a Workspace name, username, and the password created for that Workspace. In this hands-on-lab, you log in to your Oracle Application Express Workspace. Once logged in, you navigate through the major components of Oracle Application Express. This lab also covers installing and running a packaged application.
     
    Show
  • Unit 2: Using SQL Workshop
      20 Min

    This unit includes two hands-on-labs.

    HOL 2-1: Loading the Tables and Data: In this lab, you use SQL Workshop to create the underlying database objects and data required for you to build the Demo Projects application.

    HOL 2-2: Creating a Lookup Table: In this lab, you create a tabled named HARDWARE and load data in to the table. Then, you create a lookup table.

     
    Show
  • Unit 3: Creating a Database Application
      20 Min

    This unit includes three hands-on-labs.

    HOL 3-1 Creating a Database Application from Scratch: In this hands-on-lab, you create a database Web application, Demo Projects. You will extend and improve this application later.

    HOL 3-2 Creating a Database Application from a Spreadsheet: In this hands-on lab, you use a spreadsheet to create a database Web application, Budget App. You do not extend this application but will use in a later exercise.

    HOL 3-3 Creating a Websheet Application: In this hands-on lab, you create a Websheet application for the Tech Sales Team daily reporting.

     
    Show
  • Unit 4: Managing Pages in Page Designer
      15 Min
    In this lab, you create a dashboard by adding a new component to the Home page of the Demo Projects application. You open the home page in page designer, navigate through and review the page designer panes, add a chart region and edit the chart attributes.
     
    Show
  • Unit 5: Developing Reports
      15 Min

    This unit includes three hands-on-labs.

    HOL 5-1 Creating a Classic Report: In this hands-on-lab, you create a classic report region on the home page of the Demo Projects application.

    HOL 5-2 Creating an Interactive Report: In this hands-on lab, you create a new database application and then using the Create Page wizard, you add an interactive report page.

    HOL 5-3 Creating an Interactive Grid: In this hands-on lab, you use the Create Page wizard and add an interactive grid page in the Budget App application.

     
    Show
  • Unit 6: Managing and Customizing Interactive Reports
      25 Min

    This unit includes two hands-on-labs.

    HOL 6-1: Using an Interactive Report: In this lab, you customize and use an interactive report as an end user.

    HOL 6-2: Customizing an Interactive Report as a Developer: In this lab, as a developer, you customize an interactive report for your end users.

     
    Show
  • Unit 7: Managing and Customizing Interactive Grids
      30 Min

    This unit includes six hands-on-labs.

    HOL 7-1: Customizing the Team Members Interactive Grid: In this lab, you modify the source query, and customize the Demo Proj Team Members interactive grid.

    HOL 7-2: Customizing the Projects Interactive Grid: In this lab, as a developer, you modify the source query, create a new column link, and customize the display of the Demo Projects interactive grid.

    HOL 7-3: Customizing the Milestones Interactive Grid: In this lab, you modify the source query, and customize the Demo Proj Milestones interactive grid.

    HOL 7-4: Customizing the Tasks Interactive Grid: In this lab, you customize the display of the Demo Proj Tasks interactive grid.

    HOL 7-5: Customizing an Interactive Grid as a Developer: In this lab, you customize the Project Budget Interactive Grid for your end users.

    HOL 7-6: Customizing an Interactive Grid as an End User: In this lab, you use and customize the display of your Project Budget Interactive Grid.

     
    Show
  • Unit 8: Creating and Using Forms
      20 Min

    This unit includes two hands-on-labs.

    HOL 8-1 Updating the Form Pages in the Demo Projects Application: In this hands-on-lab, you update the default form pages in the Demo Projects application.

    HOL 8-2 Creating a Form on a Table and Linking a Report: In this hands-on lab, you create a form on the PROJECT_BUDGET table. Then, you create a classic report on the PROJECT_BUDGET table and link this report to the form. This lab utilizes the Budget App application.

     
    Show
  • Unit 9: Creating Application Page Controls
      20 Min

    This unit includes four hands-on-labs. The labs cover creating and updating page items, adjusting button properties, and making the form pages visually appealing. You also create and use Dynamic and Static List of Values.

    HOL 9-1 Updating the Team Members Pages: In this hands-on lab, you update the page items on the form, and create a new collapsible sub-region to include the audit details.

    HOL 9-2 Updating the Projects Pages: In this hands-on lab, you update the page items on the form, and create a new collapsible sub-region by copying it from another page in the application. You also create and use dynamic list of values.

    HOL 9-3 Updating the Milestones Pages: This hands-on lab covers updating item properties, creating and using dynamic and static list of values.

    HOL 9-4 Updating the Tasks Pages: In this hands-on lab, you create a new page item, update existing items on the form, and create a collapsible sub-region. You also use the list of values created as shared components.

     
    Show
  • Unit 10: Adding Computations, Processes, and Validations
      25 Min

    This unit includes four hands-on-labs.

    HOL 10-1 Implementing Validations on the Maintain Project Page: In this lab, you create and use validations on the Maintain Project page.

    HOL 10-2 Creating and Using a Computation: In this lab, you create a computation that changes the value of a field entered using the form to uppercase after the page is submitted

    HOL 10-3 Creating and Using a Process: This lab covers creating an After Submit process on the Project Budget form page

    HOL 10-4 Creating and Using Validations: In this hands-on lab, you create a not null validation and a validation to ensure that the item is numeric.

     
    Show
  • Unit 11: Implementing Navigation in your Application
      15 Min
    In this hands-on lab, you implement navigation in the Demo Projects application.
     
    Show
  • Unit 12: Using Themes and Theme Styles
      25 Min

    This unit includes three hands-on-labs.

    HOL 12-1 Updating the Navigation List: The Demo Projects application uses the Universal Theme. In this lab, you update the navigation list and while creating a list entry, specify user defined attributes.

    HOL 12-2 Updating the Team Members Pages: In this hands-on lab, you create a Classic Report region and update the report template to use Cards. You specify template options.

    HOL 12-3 Creating and Using Theme Styles: In this hands-on lab, you use the Budget App application. You use the Theme Roller to save the changes made to the Theme Style and then enable users to apply this Theme Style in the running application.

     
    Show
  • Unit 13: Implementing Security in your Application
      25 Min

    Application security is very important in the majority of applications, except for "Public" applications. You must ensure users enter valid credentials, generally username and password (Authentication), and that once logged in that each user has appropriate rights within the application (Authorization).

    This unit includes three hands-on-labs.

    HOL 13-1 Creating and Using an Authorization Scheme: In this lab, you create an authorization scheme to ensure only people entered as Team Members can log into the Demo Projects application. You create a user and verify if the user can access the application.

    HOL 13-2 Creating and Using an Authentication Scheme: In this hands-on lab, you create an Open Door Credentials authentication scheme and make it current. You test the authentication scheme and then switch back to the default Application Express Authentication scheme.

    HOL 13-3 Controlling User Access by Using the Access Control Administration: In this hands-on lab you create three different users as Administrator, Developer and End User. You create an Access Control Administration page, set the application mode to restrict access and add these users to the Access Control list. Finally, you apply the authorization scheme to pages and verify if users are allowed or denied access.

     
    Show
  • Unit 14: Adding Additional Pages to your Application
      30 Min

    This unit includes five hands-on-labs and uses the Demo Projects application.

    HOL 14-1 Creating and Customizing a Calendar: In this lab, you add a Calendar in the Demo Projects application. Later, you edit the calendar attributes and enable the drag and drop functionality.

    HOL 14-2 Adding the Project Tasks Chart: In this hands-on lab, you first create a blank page named Reports. You select Reports as the Parent Navigation Menu Entry when you create all the three charts and the Project Tree page in this application. This lab covers creating the Project Tasks chart to review the completed and incomplete tasks.

    HOL 14-3 Adding the Project Milestones Chart: In this lab, you create the Project Milestones chart to depict past milestones and future milestones. You create a copy of the Project Tasks chart and then edit the chart attributes including the source query.

    HOL 14-4 Adding the Project Leads Chart: In this hands-on lab you create the Project Leads chart to depict the completed and incomplete tasks for each of the team members.

    HOL 14-5 Adding the Project Tree: In this hands-on lab you create a blank page and then create a Tree region. This lab also covers updating the Demo Projects application navigation menu. To perform the steps in this lab, you need the Project_Tree.sql file which is included in the apex-course-labs.zip.

     
    Show
  • Unit 15: Creating and Using Dynamic Actions and Plug-ins
      30 Min

    This unit includes five hands-on-labs and uses the Demo Projects application.

    HOL 15-1 Creating and Using a Dynamic Action on the Maintain Project Page: In this lab, you add a dynamic action on the Maintain Project page to show or hide the Completed Date based on the value of Status.

    HOL 15-2 Creating and Using a Dynamic Action on the Maintain Task Page: In this lab, you add a dynamic action on the Maintain Task page to populate the Due Date whenever the Milestone is changed.

    HOL 15-3 Creating and Using Dynamic Actions on the Project Tree Page: This lab covers creating two buttons that you use to expand and contract the project tree nodes. You create a dynamic action on each of these buttons. Then, for each of the button, you set the action as defined by the dynamic action.

    HOL 15-4 Creating and Using a Plug-in: In this hands-on lab you create a copy of the Badge List Plug-in from the Sample Charts packaged app. Then, on the application home page, you create a badge list region. On this region, you display three different badges: Open Projects, Upcoming Milestones, and Open Tasks.

    HOL 15-5 Updating the Home Page: In this hands-on lab you create a dashboard by adding new components to the Home page of the application. You replace the Project Tasks chart with the Recent Projects classic report region. Then, you adjust the Recent Projects and My Outstanding Tasks regions so that they are placed horizontally next to each other. Finally, you modify the Summary region (Badge) attributes to enable the colorful display of the badges.

     
    Show
  • Unit 16: Migrating Application Development Between Environments
      20 Min

    This unit includes two hands-on-labs and uses the Demo Projects application.

    HOL 16-1 Importing an Application: In this lab, you import an application along with the underlying database objects and seed data.

    HOL 16-2 Migrating your Application Development Between Environments: In this lab, you export an application and then use SQL Workshop to export database objects and seed data.

     
    Show