What you'll learn:
- Hosting Oracle APEX in Oracle Cloud
- Build a RESTful Service with Oracle APEX
- Learn in detail about ORDS
- Understand the API programming in Oracle APEX
- Learn about protecting the web services
- Understand OAUTH to access the protected web services
- Learn about implementing REST Enabled SQL Service
- Learn how to consume the external API in Oracle APEX
This is a very practical video course about how to build a RESTful Service in Oracle APEX.
Though this course is at an intermediate level, it explains the basics of a RESTful Service starting from ORDS (Oracle REST Data Service) in detail.
You will learn about setting up the Autonomous Database in Oracle Cloud and also how to use Postman which acts as the REST Client.
You will get to know how to enable the ORDS schema for RESTful Access in Oracle APEX.
Using the ORDS principles, you will learn how to build a RESTful Service from scratch.
Once a RESTful Service is created, you will understand how to protect it using the ORDS concepts, which block free access.
Following that, you will be clear on how to access the protected web services using OAUTH which is a recommended method nowadays.
You will learn about the REST Enabled SQL Service and how to implement it in Oracle APEX by consuming the service in another database.
You will get to know the advantages of using REST-enabled SQL Service over the standard RESTful Service.
Finally, you will get a brief idea about the REST Data Sources in Oracle APEX and the Legacy Apex Web Service PL/SQL API as well.
