[MUSIC] In this demo, we will explore the fully managed pre configured Oracle Apex on autonomous database service. Let's get started. To open application Express or Apex from the ATPD details page, click on tools, click on the open Apex button. I will enter the admin password. I chose when I provisioned my ATP demo instance. Now it's time for me to create a workspace. I'm going to use a demo user, and enter the password for that user, and choose the same workspace name. Once I have things configured, I'll actually log into my Apex workspace as a demo user, now let's do some exploration, so I can show you guys some pretty neat stuff. This is the apex homepage. You can see some of the icons at the top, app builder, which is where you actually build your application, sequel workshop, where you can build out your schema and manipulate data Team development and more. You can see that there is one person logged in. That's me as a demo user. Let's explore a sample data set, so we can see Apex at work. We are going to install a project data sample data set. Click next to install the data set, and then hit the install button. Once the data set is installed, click, create application. Really is that easy. We can now create an application from this data set that we are going to call projects. Let's choose the look and feel for our new application that we literally created in minutes. We're going to choose an icon and a color for our application. And we'll set our application icon and let's save the changes. Okay, we're ready to add a page. Let's add a dashboard page to our newly installed application. I'm going to call this new page dashboard and create a bar chart called budget versus cost. It will be based on the EPA projects view, and the label column will be the name column, and then the value will be the budget v cost. One chart down EPV. Right? My second chart will be a pie chart. I want to look at the project status of that same table. Let's call it project status. Then I'm going to choose my table, which will be the same table that we chose before the EPA projects view. My label column will be status, and I actually want to count and represent it in a pie chart. My third chart in my dashboard, I need to look at the project leads. Let's call this chart project leads. And then I'm going to count my project leads on the EBA project view, and also, display them in a bar chart. Page one done. I know it's crazy how quick that was. So now let's add a cards page. I want to call this page projects. Let's choose the ABA projects table. And then I want to choose how I'm going to display my projects page. I'll choose grid, and then the icon initials I'd like to use are the name, and then the batch column I'd like to use is the completed date. Okay, let's add some more pages. I'm going to create an interactive Report. I'm going to name this interactive report the milestones report. So I need to select the table that this report builds off of. And I'm going to choose ABA project milestones. I want to include a form into this report. And then I want to make some adjustments to the lookup columns. Until the lookup by the project ID and then set my display column accordingly. I'll click Add Page. Let's add another type of page, and this page will be the faceted search page. The name of this faceted search, If I want to be able to search by tasks, so I'll call this the task search page. The table that I'm going to use for this is the ABA project tasks page. I'm going to click Add Page to complete it. And then I want to move things around. So I know if you notice I moved my task search up. Let's create another report. And we'll call this the tasks report page. The task report page is going to look at the same table, which is my eeba project tasks. And then I want to include a form on this particular report. And then set some lookup columns. My lookup column, of course, will be the project ID. And then once you do the lookup on that, it'll display the actual name. I want to add a few more. So let's maybe add milestone. Then we'll display the milestone name. And then let's add the page. Okay, my last page before I run my application is a calendar who doesn't love a calendar page and an application. So I'm going to call this calendar page, the tasks calendar. So I can get a global view of when my tasks are starting and stopping. So I need to select the table for this. We'll go back to our EBA project task page, but then I want to know what I need to display. And I actually want to display the name. Then choose the start date and end date. For each one of my project tasks. I'll click Add Page, and it's time to create my application. It's really just that easy. It takes a few moments to create the pages. And then that's it. In your Apex application running on autonomous database is live. You click Run application, that it is running this application inside of your OCI, tenancy on your autonomous database. Thanks for watching. Now go out and create some applications.
