This hands-on lab will introduce you to the Simple Oracle Document Access (SODA) APIs for Node.js and Oracle Autonomous Transaction Processing (ATP) database service. SODA is a set of NoSQL-style APIs that let you manage collections of documents (in particular JSON) in Oracle Database without needing to know Structured Query Language (SQL). ATP delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical transaction processing and mixed workload applications.
You will work to complete a three-tier todo tracking application. The front-end app is based on TodoMVC (a simple demo app for learning front-end frameworks). The mid-tier will be a Node.js based REST API that uses the SODA APIs included with node-oracledb (the database driver for Oracle Database) to work with data. For the application's persistence layer, you will use an instance of the ATP service.
- Create an ATP instance
- Securely connect to ATP from SQL Developer Web and Node.js
- Use SODA APIs in Node.js to fetch and persist data in ATP
- Use JSON functions in SQL to work with JSON data
| # | Module | Est. Time |
|---|---|---|
| 1 | Create an ATP instance | 5 min |
| 2 | Create a DB user with SODA privileges | 5 min |
| 3 | Package the Todo App to Run Locally | 20 min |
| 4 | Use SODA APIs for CRUD operations | 30 min |
| 5 | Use SQL features for JSON | 15 min |
-
If you already have an Oracle Cloud trial account (or regular account), you may skip to the next part.
-
Please click this link to create your free account. When you complete the registration process you'll receive an account with a $300 credit that will enable you to complete the lab for free. You can then use any remaining credit to continue to explore the Oracle Cloud.
-
Soon after requesting your trial you will receive the following email. Once you receive this email you can proceed to Part 2.
-
Click here to navigate to Module 1. Alternatively, you can click the navigation menu icon in the upper-left corner of the browser window to see a list of modules in the lab.
-
Click Module 1: Create an ATP instance.
