(README.md) Last Updated: November 08, 2018

# Getting Started with Autonomous Transaction Processing

This workshop walks you through all the steps to get started using the Oracle Autonomous Transaction Processing. Provision a database, scale ATP, load data, configure node.js with ATP and building microservices on ATP

Goals for this workshop

• Provision an ATP Database on Oracle Cloud Infrastructure
• Configure a secure connection using Oracle SQL Developer
• Scaling an ATP Database
• Loading data into ATP Database
• Configure node.js app with ATP
• Building Microservices on ATP
• Configure OCI-CLI

How to Get Your Free Cloud Trial Account

Please click on the following link to create your Free Account, and complete all the required steps to get your free Oracle Cloud Trial Account. When you complete the registration process you'll receive a $300 credit that will enable you to complete the lab for free. Additionally, you'll have 1000s of hours left over to continue to explore the Oracle Cloud.

• Soon after requesting your trial you will receive the following email. You may begin working on Lab 1

Workshop Overview

Before You Begin

What is an Autonomous Transaction Processing?

Oracle Autonomous Transaction Processing 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.

Read on to begin your Getting Started journey with Oracle Autonomous Transaction Processing.

You are all set, let's begin!

Lab 1: Provisioning an Autonomous Transaction Processing Database

Key Objectives:

• Learn how to sign-in to the Oracle Public Cloud
• Learn how to provision a new ATP database

Click here to run Lab 1

Lab 2: Secure Connectivity and Data Access

Key Objectives:

• Learn how to configure a secure connection using Oracle SQL Developer

Click here to run Lab 2

Lab 3: Scaling an ATP instance

Key Objectives:

• Learn how to scale an ATP instance

Click here to run Lab 3

Lab 4: Data Loading into ATP

Key Objectives:

• Learn how to use the SQL Developer Data Import Wizard
• Learn how to upload files to the OCI Object Storage
• Learn how to define object store credentials for ATP
• Learn how to create tables in your database
• Learn how to load data from the Object Store

Click here to run Lab 4

Lab 5: Configure node.js app with ATP

Key Objectives:

• Learn how to build a linux node.js application server and connect it to an Oracle ATP database service

Click here to run Lab 5

Lab 6: Building microservices on ATP

Key Objectives:

• To build a docker container running node.js microservice
• Deploy it on an ATP service

Click here to run Lab 6

Lab 7: Configure OCI-CLI

Key Objectives:

• Configure Oracle Cloud Infrastructure Command Line Interface
• Run examples using OCI-CLI for Autonomous Transaction Processing database

Click here to run Lab 7

Learn More About Autonomous Transaction Processing...

Use these links to get more information about Oracle Autonomous Transaction Processing

• Oracle Autonomous Transaction Processing Cloud Website
• Oracle Autonomous Transaction Processing Cloud docs