Oracle Sales and Partner Academy

PaaS
Building an App from a Spreadsheet using Oracle APEX

Oracle APEX is a low-code application platform for Oracle Database. APEX Application Development, Autonomous Data Warehouse (ADW), Autonomous Transaction Processing (ATP), and Autonomous JSON Database are fully managed services, pre-integrated and pre-configured with APEX, for rapidly building and deploying modern data-driven applications in Oracle Cloud. Business users, citizen, and application developers can create enterprise apps 20X faster with 100X less code — without having to learn complex web technologies with just a browser. There are many ways in the Oracle Cloud to create APEX workspaces. Through ATP, ADW, directly on apex.oracle.com, or from the OCI Console in the Developer section. We will use the Developer section in OCI. This lab will show you how to create a robust APEX application with data imported from a common business spreadsheet. Many customers are wasting enormous amounts of time and energy keeping their business workflows and critical data in unmanageable spreadsheets. It's a common fact, spreadsheets don't scale. What if your customer could create a secure, scalable, multi-user application out of that spreadsheet that could save time and money? That's what you'll be learning in this lab! Build a secure, scalable application using uploaded spreadsheet data. Improve application by managing and changing the filters through APEX’s powerful faceted search. Improve the Interactive Report and form pages to add better usability features. Add maps region and install PWA. Link pages. Build confidence in demonstrating the APEX application to customers! Cloud sales and engineering. Database cloud sales and engineering. Database developers. Basic cloud familiarity. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. August 2022.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
Migrate an Application to OCI with WebLogic Kubernetes Toolkit

In this lab, you will learn how to migrate a WebLogic application to Kubernetes using the WebLogic Kubernetes Toolkit. Learn how to create a WKT project, create the container image of the WebLogic domain, register the container and deploy it on Kubernetes. Finally, carry out couple of administration task by scaling the cluster and upgrade WebLogic server. Estimated Lab Time: 120 minutes. Upon completion of this Lab you will be able to: Create a model of the WebLogic domain. Create a Linux container image to run the domain. Deploy the domain to the Kubernetes cluster. Scale the WebLogic cluster. Upgrade WebLogic Server version. This lab is intended for: Advanced technical learners. Anyone interested to learn about migrate and modernize custom and third-party apps. Anyone interested to learn about application development. Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox and Internet Explorer 11. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. April 2022 - Initial version.

Time Limit
6 hours
Oracle Sales and Partner Academy
Dev
Application Development DevOps lifecycle

An introduction to the OCI DevOps Cloud Service. Oracle Cloud Infrastructure DevOps service is a complete continuous integration/continuous delivery (CI/CD) platform for developers to simplify and automate their software development lifecycle. The OCI DevOps service enables developers and operators to collaboratively develop, build, test, and deploy software. In this lab, setup DevOps service to build and deploy a polyglot application with Graal VM running on Kubernetes. Estimated Lab Time: 90 minutes. Upon completion of this Lab you will be able to: Create a DevOps Service project. Define artifacts. Define the environment. Create the build and deployment pipeline. Understand the build and deploy YAML scripts. Automate and re-deploy the application. This lab is intended for: Intermediate technical learners. Wish to learn about Oracle Cloud Infrastructure DevOps service. Anyone interested to learn about application development (AppDev). Access to Oracle Oracle Cloud Infrastructure DevOps service. Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox and Internet Explorer 11. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. April 2022 - Initial version.

Time Limit
4 hours
Oracle Sales and Partner Academy
Dev
VB Studio CI/CD Automation

Visual Builder Studio provides capabilities for continuously integration and continuous deployment (CI/CD) for building low-code applications. This lab is a typical use case highlighting team collaboration (issue tracking, sprint planning) and code lifecycle management with Git repositories. Estimated Lab Time: 60 minutes. Upon completion of this lab you will be able to: Sign in to Visual Builder Studio. Create a project. Import the mobile application. Create the issue ticket. Resolve the issues. Publish and test the application. This lab is intended for: Beginner/Intermediate technical learners. New to cloud. New to Oracle Cloud Infrastructure. Anyone interested to learn about application development (AppDev). Access to Oracle Visual Builder Cloud Service and Visual Builder Studio. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. Feb 2022 - Initial version.

Time Limit
4 hours
Oracle Sales and Partner Academy
PaaS
Helidon Basics

In this lab you will learn how to write Java microservices application using. . This lab covers both programming models: Helidon SE reactive and. Helidon MicroProfile (MP) APIs. Using Eclipse you will build and configure a Helidon SE application and a Helidon MP application. Estimated Lab Time: 120 minutes. Use the config component Java API to load and process configuration properties from various sources. How to creating custom metrics and use Prometheus to monitor those metrics. How to implement applications health checks and to expose health statuses. How to call services within your application. How Helidon support tracing through the OpenTracing APIs and the Zipkin tracer. How to modify the application to support fault tolerance better. Using Helidon to serve static content such as web pages. Anyone interested in application development (AppDev). Basic Java software development knowledge. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. July 2021 - Initial version. Jan 2022 - Updated for new OSPA standards.

Time Limit
4 hours
Oracle Sales and Partner Academy
PaaS
Verrazzano Basics

Verrazzano is an end-to-end enterprise container platform for deploying cloud-native and traditional applications in multi-cloud and hybrid environments. It is made up of a curated set of open source components – many that you may already use and trust, and some that were written specifically to pull together all of the pieces that make Verrazzano a cohesive and easy to use platform. In this lab you will learn how to install Verrazzano platform on a single Kubernetes cluster and deploy sample application using Verrazzano concepts. Bob’s Books sample application consists of three main parts: A back-end “order processing” application, which is a Java EE application with REST services and a very simple JSP UI, which stores data in a MySQL database. This application runs on WebLogic Server. A front-end web store “Robert’s Books”, which is a general book seller. This is implemented as a Helidon microservice, which gets book data from Coherence, uses a Coherence cache store to persist data for the order manager, and has a React web UI. A front-end web store “Bobby’s Books”, which is a specialty children’s book store. This is implemented as a Helidon microservice, which gets book data from a (different) Coherence cache store, interfaces directly with the order manager, and has a JSF web UI running on WebLogic Server. Estimated Lab Time: 90 minutes. Set up an Oracle Kubernetes Engine instance on the Oracle Cloud Infrastructure. Install and explore the Verrazzano platform. Deploy Bob’s Books sample application. Modify and redeploy application component. This lab is intended for: Anyone interested in the Verrazzano platform. Anyone interested to learn about application development (AppDev). Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox and Internet Explorer 11. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. July 2021 - Initial version. Jan 2022 - Updated for new OSPA standards.

Time Limit
4 hours
Oracle Sales and Partner Academy
IaaS
OCI Class of Learning Path

This learning path contains the two labs that are presented in the OCI Overview section for new SE's in the Class Of training program. The courses included in this learning path are listed below. Here’s some basic guidance about which course you should take first and how long the path might take. Click on the Labs tab next to Overview to get started on this path. OCI Basics. OCI Advanced - VCN Peering. This lab is intended for: Class Of students attending the OCI Overview instructor led training. Basic computer skills, some command-line experience with Linux, and general networking concepts. July 2021 LP creation.

2 labs
PaaS
WebLogic Basics

During these labs we will be using the latest WebLogic Server console that runs outside of the context of the Admin Server. It will run on the desktop of the Administrator. It is called WebLogic Remote Console and it is a lightweight, open-source console that you can use to manage your WebLogic Server domain running anywhere, such as on a physical or virtual machine, in a container, Kubernetes, or in the Oracle Cloud. The Remote Console does not need to be co-located with the WebLogic Server domain. You can install and run the Remote Console anywhere, and connect to your domain using WebLogic REST APIs. You simply launch the desktop application and connect to the Administration Server of your domain. Or, you can start the console server, launch the console in a browser and then connect to the Administration Server. The Remote Console is fully supported with WebLogic Server 12.2.1.3, 12.2.1.4, and 14.1.1. Estimated Lab Time: 90 minutes. Upon completion of this Lab you will be able to: Configure WebLogic Server instances. Configure WebLogic Server services, such as database connectivity (JDBC), and messaging (JMS). Deploy and Un-deploy applications. Start and stop servers and applications. Monitor server and application performance. This lab is intended for: Anyone interested in Weblogic. Anyone interested in learning about application development (AppDev). Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox and Internet Explorer 11. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. Jun 2021 - Initial version. Jan 2022 - Updated for new OSPA standards.

Time Limit
4 hours
Oracle Sales and Partner Academy
PaaS
Oracle Integration (Application Integration)

The purpose of this lab is to familiarize yourself with the Application Integration capability of Oracle Integration (OIC) so you can represent the product in customer sessions, deliver demonstrations and develop skills to build proof-of-concept (POC) projects for customers. You will use the Integration component of Oracle Integration (OIC) to build an integration for a RESTful process application to connect to Autonomous Transaction Processing (ATP) database to create a new order based upon an approved order request. Estimated duration is around 1 hour. After this lab, you are also highly recommended to attempt another lab (Oracle Integration - Process Automation) which demonstrates the way to build an process automation application to give you a complete picture of the end-to-end solution for this use case. Upon completion of this Lab you will be able to: Explain the business and technical architectures of the proposed solution for Mama Maggy. Build connections using OIC's prebuilt adaptors (REST and ATP adaptors). Use connections to build a new integration that accepts order data via a REST POST and creates a new order row in the ORDERS table in the ATP database. Activate the integration. This lab is intended for: Anyone interested in application integration. Nil. May 13th, 2021.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
WebLogic on Kubernetes

This lab shows you how to deploy and run a WebLogic domain container-packaged web application on a Kubernetes cluster using Oracle WebLogic Server Kubernetes Operator (the "operator"). The application is a simple JSP page that shows WebLogic Server domain MBean attributes to demonstrate the operator features. Estimated Lab Time: 60 minutes. Set up an Oracle Kubernetes Engine instance on the Oracle Cloud Infrastructure. Install the WebLogic Server Kubernetes Operator. Install a Traefik software load balancer. Deploy a WebLogic domain. Scale a WebLogic cluster. Update a deployed application by a rolling restart of the new image. This lab is intended for: Anyone interested in OCI, Kubernetes, and Weblogic. Anyone interested to learn about application development (AppDev). Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox, and Internet Explorer 11. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. May 2021 - Initial version. Jan 2022 - Updated for new OSPA standards.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
Working with ERP Cloud Business Events in OCI Integration

The purpose of this lab is to familiarize yourself with the SaaS connectivity features of OCI Integration (OIC) so you can represent the product in customer sessions, deliver demonstrations and develop skills to build proof-of-concept (POC) projects for customers. This lab will cover the recommended steps to complete an end-to-end use case based on ERP Cloud Business Events in OCI Integration. It will leverage the pre-built Oracle ERP Cloud Adapter, which enables you to create an integration with Oracle Enterprise Resource Planning (ERP) applications. One of the key differentiators of this adapter is support for subscribing to business events raised by various modules in Oracle ERP Cloud and Oracle Supply Chain Cloud. This lab will showcase the event subscription capabilities to create an App Driven orchestration i.e., real-time integration, with updates in ERP Cloud sent immediately to Oracle Autonomous Database using orchestration with OCI Integration. The steps outlined in this workshop and the walk-through demo videos can be used to showcase the event-driven capabilities of the ERP Cloud adapter in OIC. Estimated workshop time: 1 hour. Upon completion of this Lab you will be able to: Create and activate an integration that subscribes to an ERP Cloud Purchase Order (PO) event. Create a PO in ERP Cloud and a PO event is triggered. Retrieve the PO information through Oracle Autonomous Database table. This lab is intended for: Anyone interested in connecting SaaS applications and database. None. Authored by Ravi Chablani, March 2022. Last updated by - Wallence Wong, March 2022.

Time Limit
5 hours
Oracle Sales and Partner Academy
PaaS
Oracle Cloud Event Notification

Notifications should be an important part of any customers cloud infrastructure as they can save a lot of time and money. Notifications from applications can send emails or alerts to their users when something happens. For example: a file or order has been processed. The Oracle Cloud Infrastructure Notifications service broadcasts messages to distributed components through a publish-subscribe pattern, delivering secure, highly reliable, low latency and durable messages for applications hosted on Oracle Cloud Infrastructure and externally. Use Notifications to get messages whenever alarms, service connectors, and event rules are triggered. Upon completion of this Lab you will be able to: Setup a notification and verify that it works. Configure an Oracle Cloud Topic. Configure an Oracle Cloud Subscription. Configure and test an event and notification. This lab is intended for: Anyone interested in using Oracle Cloud. Basic computer experience. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. Dec 2021 updates.

Time Limit
1 hour
Oracle Sales and Partner Academy
PaaS
Modernize WebLogic with Helidon

Learn how to Modernize WebLogic with Helidon. Running your microservices alongside WebLogic Server. Oracle WebLogic Server provides a modern development platform for building applications, a runtime platform for high performance and availability, and rich management tooling for efficient and low-cost operations. Helidon SE is a compact toolkit that embraces the latest Java SE features: reactive streams, asynchronous and functional programming, and fluent-style APIs. The REST framework for Helidon SE is the Helidon WebServer. It’s built on top of Netty and uses a straight forward request routing API. Estimated Lab Time: 90 minutes. Upon completion of this Lab you will be able to: Seamlessly integrate an application running on WebLogic with a Helidon SE microservice. Build a Helidon SE Microservice using Maven Archetype for Helidon. Run a Helidon Microservice. This lab is intended for: Anyone interested in OCI and WebLogic. Anyone interested to learn about application development (AppDev). Oracle Cloud Infrastructure supports the latest versions of Google Chrome, Firefox, and Internet Explorer 11. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. Jan 2021 - Initial version. Jan 2022 - Updated for new OSPA standards.

Time Limit
4 hours
Oracle Sales and Partner Academy
PaaS
APEX - Creating an App From a Spreadsheet

Oracle Application Express (APEX) is a low-code development platform that enables customers to easily build stunning, scalable, secure apps with world class features, that can be deployed anywhere. It's also included free in all current versions of the Oracle Database, including Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) services. This lab will show you how to create a robust APEX application with data imported from a common business spreadsheet. Many customers are wasting enormous amounts of time and energy keeping their business workflows and critical data in unmanageable spreadsheets. It's a common fact, spreadsheets don't scale. What if your customer could create a secure, scalable, multi-user application out of that spreadsheet that could save time and money? That's what you'll be learning in this lab! Build a secure, scalable application using uploaded spreadsheet data. Improve application by managing and changing the filters through APEX’s powerful faceted search. Improve the Interactive Report and form pages to add better usability features. Improve the Calendar page to reflect business objectives. Link pages. Build confidence in demonstrating the APEX application to customers! This lab is intended for: Cloud sales and engineering. Database cloud sales and engineering. Basic cloud familiarity. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. July 2022.

Time Limit
2 hours
Oracle Sales and Partner Academy
PaaS
Analytics

Connect to the right data, at the right time. Leverage the most complete platform in the cloud analytics market. Choose your own journey to the cloud. Deliver the technology your business stakeholders need to become innovators with Oracle Analytics Cloud. Collaborative, providing a efficient methods to interact and share information. Upon completion of this Lab you will be able to: Get started with Oracle Analytics. Understand the core features of Oracle Analytics. Blend Data, Visualize and Narrate using data. Use Machine Learning within Oracle Analytics. This lab is intended for: Anyone interested in Oracle Analytics. Oracle Analytics supports the latest versions of Google Chrome, Firefox and Internet Explorer 11. July 2nd, 2020 - Initial version.

Time Limit
2 days
Oracle Sales and Partner Academy
PaaS
Oracle Integration (Process Automation)

In this lab, you’ll use the Process component of Oracle Integration (OIC) to build a process automation application Mama Maggy’s store managers use to enter order requests. Regional managers use the application to evaluate order requests from store managers. If the requests are approved, orders will be created in the ATP database using an imported integration. Estimated duration: 1-2 hours. Upon completion of this Lab you will be able to: Model an order submission and approval process using OIC’s Process Automation component; Create a process application enabling store managers to submit requests and regional managers to approve/disapprove them; Import a pre-built integration into the process model to add a new order to the ATP database. This lab is intended for: Anyone interested in application integration. Nil. May 20th, 2021.

Time Limit
3 hours
Oracle Sales and Partner Academy
IaaS
OCI Advanced - VCN Peering

OCI VCNs are distinct and by default cannot communicate with each other. This lab will show you how to create a local peering connection so that two OCI networks in the same region can communicate securely, without passing traffic on the public internet. You will create two VCNs, each with a deployed Linux instance. Then you'll connect the two together with a Local Peering Gateway to create a private connection that is not exposed to the internet. Upon completion of this Lab you will be able to: Create a secure private peering connection between two VCNs. This lab is intended for: Oracle Cloud Architects. Solution Engineers. Anyone interested in OCI network architecture. None. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. August 9, 2022 - Updated shape information.

Time Limit
8 hours
Oracle Sales and Partner Academy
PaaS
Provisioning Autonomous Database

This lab is a brief introduction to Oracle Autonomous Database on Oracle Cloud. You will provision an Autonomous Data Warehouse instance, connect to it, and view sample data using the Oracle SQL Developer web tool. Upon completion of this Lab you will be able to: Provision an Autonomous Data Warehouse on OCI. Connect to ADW via the Oracle SQL Developer web tool. Run a query on sample data. This lab is intended for: Executive and management level audience interested in the basics of the Oracle Autonomous Database. Basic computer operation experience. Familiarity with basic database concepts. June 24, 2022 - refresh. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback.

Time Limit
1 hour
Oracle Sales and Partner Academy
IaaS
OCI Basics

In this lab, you will deploy a single instance development environment. You will create a compute instance with a pre-installed development environment, set up a web server, attach block volume storage, and install a simple application that will utilize the block volume storage. Then you'll create a second compute instance that will re-use the boot volume of the first compute instance. And you'll move the application block volume to the second compute instance. The goal of this lab is to demonstrate the basic functionality of OCI, starting with a simple network. Then add an instance with pre-installed developer tools. Eventually, everyone needs more storage so you'll learn how to add that. And you'll learn to move storage around to where it might be needed. Upon completion of this Lab you will be able to: Create a VCN. Launch a Compute Instance. Create and mount a Block Volume. Install a Web Server. Move boot and block storage to different instances. This lab is intended for: Anyone interested in OCI. New to OCI and already have some familiarity with IT and Cloud concepts. OCI technical. - Basic overview training to help acquaint those new to OCI with a complete overview of terms and technology. Basic network, compute, and data storage knowledge. Entry-level knowledge of command-line Linux/Unix. Having an issue with the lab? Have an idea on how it could be made better? Want to tell us how awesome the lab is? Click the icon below to contact the team and let us know your feedback. August 9, 2022.

Time Limit
1 hour
Oracle Sales and Partner Academy