Overview
RESTful web services have become the de facto standard in application to applicationcommunication. This course is designed to give the participants the required knowledge to be able to build and consume RESTful services using the Oracle infrastructure. Although no previous knowledge of RESTful services is required, a basic understanding of Oracle SQL, PL/SQL, APEX and JSON is assumed.
Building RESTful services with ORDS
- REST – Representational State Transfer
- TTP – Hypertext Transfer Protocol
- ORDS – Oracle REST Data Services
- ORDS – AutoREST
- ORDS – REST Resources
- ORDS – REST Authentication
- ORDS – REST Authorization
- ORDS – REST Parameters as bind variables
- ORDS – REST Hyperlinks
- ORDS – REST Resource Type Examples
Consuming RESTful services with APEX and PL/SQL
- APEX – Creating REST Sources
- APEX – Creating Reports, Forms and Charts
- SQL and PL/SQL Operations
Technical Requirements
Nothing is required for labs (workshops). SkillBuilders will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class. Detailed specs can be found here.
Also, we strongly recommend using two monitors for this class. This will allow to you to view the instructors display on one monitor and your code on the second.
Course Features
- Lecture 0
- Quiz 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
Building RESTful services with ORDS
- REST – Representational State Transfer
- Basics
- Architecture
- Constraints
- HTTP – Hypertext Transfer Protocol
- Characteristics
- Request methods
- Method usage
- Essential tools to design, debug and test REST APIs
- ORDS – Oracle REST Data Services
- Basics
- Architecture in relation to APEX
- In relation to REST resources
- ORDS REST Enabled SQL
- ORDS – AutoREST
- Enabling Database schema objects
- Schema object path
- Tables and Views
- Filtering and sorting
- Inserting and updating data
- Batch load of table data
- Auto PL/SQL – procedures and functions
- ORDS – REST Resources
- Resource path
- Modules
- Templates
- Handlers
- Parameters
- ORDS – REST Authentication
- Basic
- OAuth2
- ORDS – REST Authorization
- Roles
- Privileges
- Modules
- URI Patterns
- ORDS – REST Parameters used as SQL and PL/SQL bind variables
- URI template
- Query string
- HTTP header variables
- Request body JSON
- Implicit IN and OUT parameters
- ORDS – REST Hyperlinks
- Basics
- Primary key hyperlinks
- Arbitrary hyperlinks
- Hyperlink paths
- ORDS – REST Resource Types
- HTTP GET – Collection query
- HTTP GET – Collection query item
- HTTP GET – Media resource e.g. image, complex JSON
- HTTP POST – PL/SQL – Table INSERT
- HTTP PUT – PL/SQL – Table UPDATE
- HTTP DELETE – PL/SQL – Table DELETE
Consuming RESTful services with APEX and PL/SQL
- APEX – Creating REST Sources
- Simple HTTP
- ORDS
- ORDS REST Enabled SQL
- APEX – Creating Reports, Forms and Charts
- Report and Form Using ORDS AUTORest
- Report using “flat” JSON
- Report using “real world” nested JSON
- SQL and PL/SQL Operations
- Calling RESTful services
- ○ Parsing and selecting JSON data
- ○ Storing selected data in the database
- ○ Sending database data to REST endpoints
