Learn ORDS (Oracle REST Data Services) for VBCS from scratch

Focused View

SKILL MANOR

1:17:02

8 View

1. Introduction

1. Introduction.mp4

05:23

2. Getting started with ORDS (Oracle REST Data Services)

1.1 Docs.html

1.2 employee detail tbl.zip

1. Create your first ORDS REST API and fetch data from browser.mp4

09:51

2. Use POSTMAN to test ORDS API.mp4

03:08

3. Getting started with ORDS (Oracle REST Data Services)

1.1 docs.html

1.2 ortest-1.0.zip

1. Consume ORDS REST API in Oracle Visual Builder.mp4

12:46

2.1 docs.html

2.2 ortest-1.0.zip

2. Enable security to ORDS APIs with OAuth credentials.mp4

10:30

3.1 new 10.txt

3. Delete ORDS privilege, mappings, module, OAuth client.mp4

03:58

4.1 notes.txt

4.2 ortest-1.0.zip

4. Enable ORDS API security with SQL developer.mp4

07:40

4. Use Case Creating ORDS APIs with SQL script

1.1 simple query.txt

1. Create simple API to fetch data from a table.mp4

03:09

2.1 query with where condition empid.txt

2. Create an API with path parameter or bind variable in SQL.mp4

02:10

3.1 create table.zip

3.2 module handler query.zip

3.3 xx cmn logging pkg.zip

3.4 xx cmn logging pkg.zip

3. Create an API to accept JSON array collection in request body (POST).mp4

06:46

4.1 post simple object with response in json.txt

4. Create an API to accept JSON object in request body (POST).mp4

04:43

5. Create ORDS REST API for table with SQL PLSQL.html

5. Use Case Existing PLSQL procedure expose as ORDS API

1.1 notes.txt

1. Expose procedure with custom object table type IN parameter.mp4

06:16

6. Congratulations

1. Congratulations!!! and Thank You for completing this course successfully.mp4

00:42

Description

Learn to develop ORDS REST APIs for your database tables / procedures and consume them in your VBCS app

What You'll Learn?

Learn ORDS basics for Oracle Visual Builder development
Learn to develop ORDS REST APIs with SQL Developer
Learn to develop ORDS REST APIs with SQL scripts
Learn ORDS REST APIs with use cases

Who is this for?

Beginners in ORDS for Oracle Visual Builder

What You Need to Know?

Students must already have a database with ORDS setup done before enrolling to this course

This course is designed for Oracle Visual Builder Developers only

More details

Description
About Oracle REST Data Services
Oracle REST Data Services (ORDS) is the HTTPS Web Gateway for your Oracle Database, which includes features such as Oracle Database Actions, Oracle APEX access, REST APIs for your data and databases, Oracle Database API for MongoDB, and much more. Oracle REST Data Services is a Java EE-based alternative for Oracle HTTP Server and mod_plsql. The Java EE implementation offers increased functionality including a command-line based configuration, enhanced security, file caching, and RESTful web services. Oracle REST Data Services also provides increased flexibility by supporting deployments using Oracle WebLogic Server, Apache Tomcat, and a standalone mode.
The Oracle APEX architecture requires a web server to proxy requests between a web browser and the Oracle APEX engine. Oracle REST Data Services Meets the requirement but its use goes beyond that of Oracle APEX configurations. Oracle REST Data Services simplifies the deployment process because there is no Oracle home required, as connectivity is provided using an embedded JDBC driver.

Features of Oracle REST Data Services
This section lists the features of Oracle REST Data Services (ORDS).
Database Actions
Database Actions, is a web-based interface that provides development, data tools, administration, and monitoring features for Oracle Database. Additionally, ORDS is provided as a managed feature of the Oracle Autonomous Database Cloud Services.

REST-Enabled SQL
REST-Enabled SQL is a REST API that allows for ad-hoc SQL and SQL Scripts to be executed. You can POST one or more SQL statements to the service. The service then runs the SQL statements against Oracle Database and returns the results and output to the client in a JSON format.

Database REST APIs
ORDS includes a collection of more than 500 REST APIs for performing operations such as monitoring and maintaining your Oracle Database, including PDB lifecycle management, performance, security, data dictionary, data pump.

REST APIs
Provides the ability to define the REST APIs with SQL and PL/SQL. ORDS marshals SQL and PL/SQL types to and from JSON, auto-paginates the results of your SQL queries, supports GeoJSON for spatial, handles common database errors with appropriate HTTPS responses and much more. Users can also choose to REST enable tables, views, and stored procedures to take advantage of the AutoREST feature.

PL/SQL Gateway
Oracle REST Data Services is a Java EE-based alternative for Oracle HTTP Server and mod_plsql. An Oracle HTTP Server mod_plsql application can be migrated to ORDS by defining the new ORDS configuration files. The mod_plsql database resources such as before procedures, after procedures, request validation functions, owa_custom packages, document upload procedures and document tables require no change when you are migrating to ORDS. PL/SQL gateway enables you to access your APEX applications from an application server such as WebLogic or Tomcat.

RESTful Web Services
Auto REST for tables and views, RPC for PL/SQL
Custom services built with SQL & PL/SQL
{json} responses
Paged results
Open API Documentation
Full dev support (GUI, CLI, API)
SQL Developer Web
Web application hosted by ORDS
SQL Worksheet
REST Development Environment
JSON Workshop
Management and Performance Tuning
Database Management API
500+ endpoints for managing your Oracle Database
PDB management
Data Pump
Data Dictionary
Performance
Monitoring
Who this course is for:
Beginners in ORDS for Oracle Visual Builder

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Database

SKILL MANOR

Instructor's Courses

Skill Manor is a instructor for Oracle Cloud and other related cloud concepts. We create content to help students and professionals to learn Oracle Cloud, Oracle Integration Cloud (Integration, Process, Visual Builder, ...etc.) and others, enroll to our courses and sharpen your skill and gain the knowledge to take up your next assignment confidently.- Imaginations Simplified with Skill Manor

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.