In this episode, Lois Houston and Nikita Abraham are joined by Cloud Engineer Nick Commisso to talk about managing Oracle Database with REST APIs.   They also look at Autonomous Database built-in tools, which are pre-assembled, pre-configured, and pre-deployed, delivering a consistent user experience.   Oracle MyLearn: https://mylearn.oracle.com/   Oracle University Learning Community: https://education.oracle.com/ou-community   LinkedIn: https://www.linkedin.com/showcase/oracle-university/   Twitter: https://twitter.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Deepak Modi, and the OU Studio Team for helping us create this episode.   --------------------------------------------------------   Episode Transcript:   00;00;00;00 - 00;00;39;06 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we’ll bring you foundational training on the most popular Oracle technologies. Let's get started! Hello and welcome to the Oracle University Podcast. I'm Lois Houston, Director of Product Innovation and Go to Market Programs with Oracle University. And with me is Nikita Abraham, Principal Technical Editor.   00;00;39;12 - 00;01;04;12 Hello again! Last week, we discussed Oracle Cloud Infrastructure’s Maximum Availability Architecture. And in today's episode, we'll talk about managing Oracle Database with REST APIs and also look at Autonomous Database built-in tools with our Cloud Engineer Nick Commisso. Hi Nick, thanks for being back on the podcast. What is Oracle REST Data Services? What do you use it for?   00;01;04;14 - 00;01;31;07 Oracle is not just a relational database anymore. And the REST APIs can be deployed with Oracle REST Data Services or ORDS to handle all of these data format models. And you can use ORDS for application development and accessing the data and can be used as a powerful tool for automating management, lifecycle, provisioning, and data-dictionary-type use.   00;01;31;09 - 00;02;02;02 Oracle Cloud offers full REST APIs for DBAs and developers who would prefer to interact with Oracle Autonomous Database Cloud services programmatically over REST rather than log in to the cloud console and click through screens. This provides a mechanism for developing customized deployment and management scripts that can be saved and reused for deployments, setting gold standards, and storing entire application infrastructure stacks as version-controlled code.   00;02;02;08 - 00;02;35;15 I think before we move on, it's important to clarify. For anyone who doesn't already know, what is REST? How do Oracle Cloud Infrastructure APIs use REST and HTTPS? REST is combined with HTTPS, but is not a protocol. REST is an acronym for Representational Stateless Transfer. The Oracle Cloud Infrastructure APIs are typical REST APIs that use HTTPS requests and responses and support HTTPS and SSL protocol TLS 1.2, the most secure industry standards.   00;02;35;15 - 00;03;18;17 Calls to the Oracle Cloud Infrastructure using REST APIs can be written in popular scripting languages such as Node.js, Python, Ruby, Perl, Java, C#, Bash, or Curl. The way you interact with your data are the API calls via HTTP - GET to access your data and stored procedures. PUT to update your data. POST to insert your data and execute PL/SQL. And DELETE to remove your data. When making an HTTP request with Oracle REST Data Services, how does the process flow from the request to accessing data in the database?   00;03;18;17 - 00;03;46;21 A person, process, or computer gets ready to make an HTTP request. You need to tell the request where the thing or data is, and the request will get into the web tier where ORDS is running. ORDS then translates the REST request to a SQL statement and accesses the table to get the information requested.   00;03;46;24 - 00;04;13;11 The result normally comes back as a JSON, but can also return an HTML, binary, and CSV. With all of these requests, a collection