Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

REST Enable Oracle (Tables & PL/SQL) using ORDS

Recommended Duration:
2 Days
Version: Oracle 12c R2
Course can be taught with Oracle 12c R1 or Oracle 11g.
Benefits
Today’s service architectures increasingly depend upon REST-based APIs. Attendees will learn to REST enable Oracle database objects (tables, views, PL/SQL) using ORDS (Oracle REST Data Services). Audience Oracle developers needing to expose Oracle database data via RESTful APIs.
Audience
Oracle developers needing to expose Oracle database data via RESTful APIs.
Prerequisites
Working Oracle SQL and PL/SQL experience of at least six months or completion of Oracle SQL and PL/SQL training.
 
Exercises
There are eleven hands-on machine exercises.
Major Topics
  • Modern Service Architecture and APIs
  • What is REST?
  • RESTful API “standards”
  • REST and JSON
  • GET/PUT/POST/DELETE
  • Resources, Requests, Statelessness
  • REST Errors
  • Oracle REST Data Services (ORDS)
  • How ORDS works
  • ORDS URI mapping
  • Map URI and Bind to SQL
  • Transform SQL Output to JSON
  • JSON Overview
  • Setting up ORDS (if necessary)
    Stand-alone or not?
  • ORDS and APEX
  • ORDS and SQL Developer
  • ORDS Administration and Reports
  • REST enabling schemas
  • REST enabling tables
  • REST enabling PL/SQL
  • PL/SQL API supporting ORDS
  • Using the PL/SQL API directly
  • Security features: SSO, OAuth2, etc.
  • Accessing from code: JavaScipt, node.js, php, Python, Java, Android, and more…