Build Web Apps using APEX & Autonomous Database

Cost $2000

Course Code
D107346GC10

Duration
1 day

Format
Live Virtual Class

What you will learn

This course will help you in migrating on-premises database apps to Oracle Cloud and develop the RESTful web services. As part of the hands-on labs, you will create an Autonomous Transaction Processing database and use APEX Web to create the applications.

In this course, you will learn to:

  • Describe Oracle Autonomous Database and APEX Web
  • Accessing and using APEX Web on Autonomous Database
  • Migrate a database app to Oracle Cloud Infrastructure (OCI)
  • Develop RESTful Web Services with APEX Web

 

Prerequisites

  • Working knowledge of Oracle SQL Basic of knowledge of Oracle Database Basic knowledge of developing applications using Oracle Database

Audience

  • Developers
  • Cloud Developers
  • Database Developers

Objectives

  • Describe Oracle Autonomous Database and APEX Web
  • Accessing and using APEX Web on Autonomous Database
  • Migrate a database app to Oracle Cloud Infrastructure (OCI)
  • Develop RESTful Web Services with APEX Web

Topics

1. Getting Started with Oracle APEX on ADB

  • Describe Oracle APEX
  • Explain the key features of Autonomous Database
  • Describe low-code application development
  • Discuss Oracle APEX : Use Cases
  • Log in to Oracle APEX
  • Install and run a packaged app

2. Creating a  Database Application

  • Explain App Builder concepts
  • Describe the types of applications you can build using Application Express
  • List the components of a database application
  • Create a database application based on existing tables
  • Create a database application from a file
  • Create a mobile web application

3. Creating and Managing  Database Objects 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 SQL using Quick SQL
  • Generate DDL statements

4. Migrating Database Applications  Between Environments

  • 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

5. Developing RESTful Web Services

  • Explain the principles of RESTful web services
  • Develop RESTFul web services with Application Express

Enroll for OCI CLI for Oracle Database Cloud Service

OCI CLI for Oracle Database Cloud Service

$2,000.00

Clear
SKU: D107346GC10 Categories: ,

Additional information

Schedules

Aug 2 2021 (1 day) 9:00AM – 5:00PM US-Pacific, Dec 20 2022 (1 day) 9:00AM – 5:00PM US-Eastern, Apr 12 2022 (1 day) 9:00AM – 5:00PM US-Eastern

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “OCI CLI for Oracle Database Cloud Service”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0