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.
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
- 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
- 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
- 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
- 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
- Developing RESTful Web Services
- Explain the principles of RESTful web services
- APEX Web ile RESTful Web Servislerini geliştirme