Oracle REST Data Services
Oracle REST Data Services enables users to turn their Oracle database into modern RESTful API Services. This course will teach you to install ORDS, AutoREST enabled database objects, create custom REST services, secure and deploy them on app servers.
What you'll learn
REST access to your table data for the CRUD operations is a common need for most web applications. In this course, Oracle REST Data Services, you will learn about this powerful tool that enables users to turn their Oracle databases into highly scalable and secure, enterprise-grade RESTful API Services. ORDS enables REST access to your Oracle database tables, views, and program units with literally no coding. You can easily create more complex, enterprise grade custom REST services, using just your SQL and PL/SQL skills. First, you will start off learning how to install and configure ORDS. Next, you will see how to enable database objects for REST access, as well as create custom REST services. Finally, you will learn how to secure your REST services and deploy them on standard application servers. By the end of this course, you will gain a solid foundation to get started with ORDS, which will enable you to create RESTful services rapidly against your Oracle Database. What you learn will go a long way in easing your development efforts and adoption to the cloud native apps and the micro services architecture.
Table of contents
- Module Overview 2m
- ORDS Users 5m
- Installing ORDS Using SQL Developer 9m
- Uninstalling ORDS Using SQL Developer 1m
- Installing ORDS Using Command Line 7m
- Uninstalling ORDS Using Command Line 1m
- Installing Standalone ORDS Using SQL Developer 2m
- Administering ORDS 1m
- Demo: Administering ORDS 15m
- Summary 2m
- Module Overview 2m
- REST Enabling Database Schema and Tables 4m
- Auto Generated APIs 2m
- REST Service to Get Schema and Object Metadata 5m
- REST Service to Get Table Data 5m
- REST Service to Insert, Update, and Delete Rows 6m
- REST Service for Batch Load 2m
- Demo: REST Service for Batch Load 3m
- REST Service: Sorting and Filtering Data 10m
- Demo: Sorting and Filtering Data 4m
- Summary 1m
- Module Overview 2m
- Auto PL/SQL, Its Benefits and URIs 6m
- Demo: Calling Standalone Procedure Without Parameters 5m
- Demo: Calling Standalone Procedure with Parameters 3m
- Demo: Calling Standalone Function with Parameter 2m
- Demo: Calling Packaged Procedure with Parameter 4m
- Demo: Working with Varrays and Associative Arrays 4m
- Summary 2m
- Module Overview 2m
- Organization and URIs 5m
- URI Pattern for Resource Template and Parameters 3m
- Specifying Optional Parameters 3m
- Parameters Using Payload 1m
- Demo: Creating Resource Modules, Templates, and Handlers 7m
- Demo: URI Pattern 6m
- Demo: Route Pattern and Optional Parameters 7m
- Demo: Nested JSON Output 3m
- Demo: PL/SQL Restful Services Using the POST Method 5m
- Demo: PL/SQL Restful Services Using the PUT Method 5m
- Demo: PL/SQL Restful Services Using the DELETE Method 3m
- Summary 2m
- Module Overview 2m
- ORDS: Security Overview 4m
- ORDS: Privileges and Roles 5m
- ORDS Package and Database Views for Roles & Privileges 2m
- Demo: Roles and Privileges 10m
- Demo: Generating Scripts 2m
- First Party Authentication 3m
- OAuth 2.0 1m
- OAuth 2.0 Client Credentials Flow 4m
- Demo: OAuth 2.0 Client Credentials Flow 4m
- OAuth 2.0 Authorization Code Flow 7m
- Demo: OAuth 2.0 Authorization Code Flow 5m
- OAuth 2.0 Implicit Flow 6m
- Demo: OAuth 2.0 Implicit Flow 6m
- Summary 2m
- REST Enabled SQL Service Overview 4m
- Configuring ORDS for REST Enabled SQL Service 4m
- Authenticating with REST Enabled SQL Service 1m
- Demo: Enabling ORDS for REST Enabled SQL Service 1m
- Demo: Running a Single Query 2m
- Demo: Running Multiple SQL Statements 1m
- Demo: Running PL/SQL Scripts 2m
- Demo: File Input 1m
- Demo: Running DDL Statements 2m
- Demo: REST Enabled SQL Service Using JSON Document 2m
- Demo: Using Offset and Limit Clauses 1m
- Demo: Specifying Bind Parameters 3m
- Summary 2m
About the author
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.