Welcome to Oracle Database's GHW: Open Source Week Challenges!

Hello hackers! This week, we're going to learn how to leverage several of Oracle's database technologies through a series of fun and interactive challenges!

Getting Help

• If you have any questions about Oracle or their Global Hack Week challenges, head to the MLH Discord and find the #ask-oracle channel!
• Each coding challenge is accompanied by a LiveLab tutorial that will walk you through each challenge step by step

Registration Challenges

Registration Challenge 1

Sign up and download 23ai VirtualBox

Head over to the Sign up and download 23ai VirtualBox to get set up with a new account.

• Share a screenshot of your account signup on our submission form!

Registration Challenge 2

Create an account and Sign in for LiveLabs

Create an Oracle LiveLabs account so you can leverage Oracle's LiveLab tutorials and complete the rest of their coding challenges!

• Share a screenshot of your account signup on our submission form!

Coding Challenges

Coding Challenge 1

Start Polyglot Development with Autonomous Database

Objectives:

This LiveLab will demonstrate how to provision an Oracle Autonomous Database and develop applications in multiple programming languages.

• Provision an Oracle Autonomous Database
• Develop Node.js Applications for Oracle Autonomous Database
• Develop Python Applications for Oracle Autonomous Database
• Develop Java Applications for Oracle Autonomous Database
• Develop .NET Applications for Oracle Autonomous Database
• Share a screenshot of your LiveLab completion on our submission form!

Documentation:

• Polyglot Development with Autonomous Database
• PLEASE NOTE: An Oracle LiveLabs account is required to start this coding challenge.

Coding Challenge 2

SQL, JSON, and MongoDB API: Unify worlds with Oracle Database 23ai Free

Objectives:

In this workshop, you will experience Oracle's JSON capabilities using both relational and document-store APIs, namely the Oracle Database API for MongDB. The workshop loosely follows the Moviestreams theme, a series of workshops that demonstrate Oracle converged database capabilities. You will work on our movies library throughout the workshop.

• Store, query, and process JSON documents in collections using MongoDB API and SQL/JSON
• Use SQL to query, generate, and process JSON data
• Configure the Mongo API to query or manipulate data in the Oracle Database
• Learn the newest SQL Enhancements to work with JSON data
• Share a screenshot of your LiveLab completion on our submission form!

Documentation:

• SQL, JSON, and MongoDB API: Unify worlds with Oracle Database 23ai Free
• PLEASE NOTE: An Oracle LiveLabs account is required to start this coding challenge.

Coding Challenge 3

Develop with Oracle Database 23ai and GraalVM using Micronaut

Objectives:

This workshop will walk you through the basics of developing with Oracle Database and GraalVM using Micronaut in order to get you up an running quickly with a data-driven microservice that connects to Oracle’s famous Autonomous Database.

• Explore the OCI console page of a, pre-provisioned, Oracle Autonomous Database (ADB/ATP)
• Use the OCI console Cloud Shell terminal
• Download the wallet used to connect to the ATP instance
• Clone the Micronaut application source and configure the application to connect to the ATP instance
• Install/configure GraalVM
• Build the application and native-image and run it to demonstrate connectivity to the database from the Micronaut application.
• Develop new functionality of your own using this basic application/microservice
• Share a screenshot of your LiveLab completion on our submission form!

Documentation:

• Develop with Oracle Database 23ai and GraalVM using Micronaut
• PLEASE NOTE: An Oracle LiveLabs account is required to start this coding challenge.

Coding Challenge 4

Develop with Oracle Database 23ai and GraalVM using Spring Boot

Objectives:

This workshop will walk you through the basics of developing with Oracle Database and GraalVM using Spring Boot in order to get you up an running quickly with a data-driven microservice that connects to Oracle’s famous Autonomous Database.

• Explore the OCI console page of a, pre-provisioned, Oracle Autonomous Database (ADB/ATP)
• Use the OCI console Cloud Shell terminal
• Download the wallet used to connect to the ATP instance
• Clone the Spring Boot application source and configure the application to connect to the ATP instance
• Install/configure GraalVM
• Build the application and run it to demonstrate connectivity to the database from the Spring Boot application.
• Develop new functionality of your own using this basic application/microservice
• Share a screenshot of your LiveLab completion on our submission form!

Documentation:

• Develop with Oracle Database 23ai and GraalVM using Spring Boot
• PLEASE NOTE: An Oracle LiveLabs account is required to start this coding challenge.

Coding Challenge 5

Develop with Oracle Database 23ai and GraalVM using Helidon

Objectives:

This workshop will walk you through the basics of developing with Oracle Database and GraalVM using Helidon in order to get you up an running quickly with a data-driven microservice that connects to Oracle’s famous Autonomous Database.

• Explore the OCI console page of a, pre-provisioned, Oracle Autonomous Database (ADB/ATP)
• Use the OCI console Cloud Shell terminal
• Download the wallet used to connect to the ATP instance
• Clone the Helidon application source and configure the application to connect to the ATP instance
• Install/configure GraalVM
• Build the application and native-image and run it to demonstrate connectivity to the database from the Helidon application.
• Develop new functionality of your own using this basic application/microservice
• Share a screenshot of your LiveLab completion on our submission form!

Documentation:

• Develop with Oracle Database 23ai and GraalVM using Helidon
• PLEASE NOTE: An Oracle LiveLabs account is required to start this coding challenge.