This course will guide you through how to create a database application through a variety of features offered by Oracle APEX.
- Gain a foundational understanding of App Builder Concepts
- Learn how to access App Builder and how to access the Create Application Wizard to build your APEX applications.
- Understand how to create an APEX application based on existing tables
- Understand how to create an Apex application from a file
- Learn about Progressive Web Applications and how to enable Progressive Web Application installability within your APEX application
- Anyone who wants to enhance their knowledge of Oracle APEX
We recommend that you take this course as part of our Oracle APEX: Foundations learning path.
Hello, welcome to Oracle APEX Foundations course, Creating a Database Application module, App Builder and the Create App Wizard lesson. I'm Chaitanya, Product manager on the Oracle APEX product development team. So, now you have a basic understanding of App Builder concepts. It's time to go ahead and learn how to access App Builder and how to access the Create Application Wizard to build your APEX applications. In this lesson, we learn how to access App Builder and then get started with using the Create Application wizard. We already learnt that a database application, also known as an APEX application or simply an APEX app, is a collection of pages linked together using navigation menus, tabs, buttons or hypertext links. Application pages share a common session state and authentication. To create an application, a developer runs wizards to declaratively assemble pages and navigation. In an application, individual pages are organized using containers called regions. Once created, you can modify an application by editing application attributes and add new pages using the Create Page Wizard.
You can further manage the development process by creating page groups, locking and unlocking pages, adding developer and application comments, and accessing a variety of application, page, and cross page utilities and reports. The screen shows an example of a database web application that is built using Oracle APEX. This shows the homepage of the ideas and feature request application. Now to access this particular application, go to your browser and enter apex.oracle.com/ideas. Now let's take a look at this particular application. So, I would like to go to my browser and then enter apex.oracle.com/ideas and then hit 'Enter'. This is the ideas and feature request application home page and you can navigate across this application. Now to create an application using Oracle APEX, you'll run the 'Create Application Wizard' in the App Builder. Now how do you access App Builder? After logging into your workspace on the workspace home page, you click the 'App Builder' icon. The App Builder home page displays all the applications installed in the current Oracle APEX instance. You can use the App Builder home page to create new applications, select an application to edit, import previously exported applications, you can view the Dashboard or access workspace utility.
So, on the workspace home page, click 'App Builder' and if you have any APEX applications in the current APEX instance, they are all displayed for you on the App Builder home page. On the App Builder home page, you see Create, Import, Dashboard, and workspace utilities. You click 'Create' to create new applications. You can select any of these applications to edit. You can import any of the previously exported applications, you can view the dashboard, or you can access workspace utilities. So, how do you access a particular application's homepage? All you need to do is go to App Builder and then click that particular application's name and then you are navigated to the applications home page. From within the application home page, you can run the application, you can click 'Create Page' to add additional pages to your application, you can export your application, you can copy your application, and if you don't want your application you can delete the application. You can also click the 'Edit Application Definition' to view the application definition. Now let's learn a little bit more about creating applications in App Builder. When you log into your Oracle APEX workspace for the first time and navigate to App Builder, you see two areas at the bottom of the App Builder page. Create a new app and install a starter or sample app.
Click 'Create a New App' to access the Create Application Wizard and create a new application. Click 'Install a Starter or Sample App' to access the app gallery and install a starter or a sample application. Once you create an application or install a starter or sample application, these regions no longer appear. You already learned how to install a starter or sample application. To create a new application, you can click either 'Create a New App' here or click 'Create'. Let's create a new application. So, click 'Create'. You can use the Create Application Wizard to create an application which is the blank page or a complete application containing multiple pages. On the Create an Application page, you see three different options: New Application, From a File, and Starter App. Click 'New Application' to create a fully functional application based on tables you select or by providing a valid SQL. You can add pages that include various components including calendars, cards, charts, dashboards, forms, interactive grids, master detail or editable grids and reports. You can also add application level features. Click 'From a File' to upload CSV, XLSX, XML or JSON file or copy and paste data and then create your application. Click 'Starter App' to navigate to the gallery page where you can install any starter or sample application.
There are additional options on the page; Quick SQL and Copy Application. Using Quick SQL, you can generate the SQL required to create a relational data model from an indented text document. Quick SQL is designed to reduce the time and effort required to create SQL tables, triggers, and index structures. Click 'Copy Application' to create a copy of an existing application. In this lesson we learned how to access App Builder and get started with using the Create Application Wizard. So, we now finish the App Builder and the Create App Wizard lesson. I hope you find that useful. Thank you for watching.
Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.