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

Hello hackers! Did you know that the world runs on Oracle Database?

94% of Fortune Global 100 use Oracle Database, and 14 of the top 15 banks in the Fortune Global 500 list use Oracle Database on their Exadata platform. 

By completing the challenges below, you’ll gain hands-on experience with the same technology behind some of the world’s most innovative companies.

It’s a chance to build valuable skills, tackle real-world challenges, and set yourself apart as you prepare for your future career.

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 LiveLabs 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

Autonomous Database 15 Minute Quick Start (15 minutes)

Objectives:

Deploy an Autonomous Database optimized for data warehousing workloads, integrate that warehouse with a data lake, and then gain meaningful business insights – all within 15 minutes!

Steps to Complete:

• Choose your platform
  • Select whether to run your challenge on Oracle Cloud or Livelabs Sandbox. (An Oracle Cloud or LiveLabs account is required to participate)
• Complete the challenge
  • Oracle Cloud Challenge (Run on your Oracle Cloud Tenancy)
    OR
    
  • Livelabs Sandbox Challenge (Run on an Oracle-owned pre-configured tenancy)
• Share a screenshot of your LiveLab completion on our submission form!

Coding Challenge 2

Converting your Spreadsheet into a Cloud App using Oracle APEX (45 minutes)

Watch the live workshop of this challenge on Dec 6th, 12PM-1pm EST

Objectives:

By of the end of this challenge, you will create a fully featured, responsive web app using Oracle APEX, the world’s most popular enterprise low-code application development platform.
You will transform a spreadsheet into a beautiful, fuctional web app exploring NYC high schools – all in 45 minutes

Steps to Complete:

• Choose your platform
  • Select whether to run your challenge on Oracle Cloud or Livelabs Sandbox. (An Oracle Cloud or LiveLabs account is required to participate)
• Complete the challenge
  • Oracle Cloud Challenge (Run on your Oracle Cloud Tenancy)
    OR
    
  • Livelabs Sandbox Challenge (Run on an Oracle-owned pre-configured tenancy)
• Share a screenshot of your LiveLab completion on our submission form!

Coding Challenge 3

Fraud Detection in Real Time with Graph Studio (60 minutes)

Watch the live workshop of this challenge on Dec 9th, 11am-12pm EST

Objectives:

In this challenge, you will learn key graph data modeling and analysis concepts and the interactive Graph Studio for working with graphs in an Autonomous Database. It shows you how to use graph queries to find circular payments, i.e. potentially fraudulent transactions. You will be using data containing Account and Transaction information. Then create a graph and finally query it and visualize the results.

Steps to Complete:

• Choose your platform
  • Select whether to run your challenge on Oracle Cloud or Livelabs Sandbox. (An Oracle Cloud or LiveLabs account is required to participate)
• Complete the challenge
  • Oracle Cloud Challenge (Run on your Oracle Cloud Tenancy)
    OR
    
  • Livelabs Sandbox Challenge (Run on an Oracle-owned pre-configured tenancy)
• Share a screenshot of your LiveLab completion on our submission form!

Coding Challenge 4

Build a Social Media App Using Oracle APEX! (60 minutes)

Objectives:

Ready to create a Social Media app where users can upload images, like other users' posts, and delete the uploaded images? While building this application, you will also learn to create pages, regions, customize the UI and create dynamic actions. Optionally, you will also learn to get user device location by implementing Map region.

Steps to Complete:

• Choose your platform
  • Select whether to run your challenge on Oracle Cloud or Livelabs Sandbox. (An Oracle Cloud or LiveLabs account is required to participate)
• Complete the challenge
  • Oracle Cloud Challenge (Run on your Oracle Cloud Tenancy)
    OR
    
  • Livelabs Sandbox Challenge (Run on an Oracle-owned pre-configured tenancy)
• Share a screenshot of your LiveLab completion on our submission form!

Coding Challenge 5

Introduction to Oracle SQL (30 minutes)

Objectives:

This challenge provides an introduction to the Structured Query Language (SQL), learn how to create tables with primary keys, columns, constraints, indexes, and foreign keys.

Steps to Complete:

• Complete the challenge
  • Oracle Cloud Challenge (Run on your Oracle Cloud Tenancy)
  • Note: Sign up for an Oracle Cloud here. This challenge is not available on LiveLabs Sandbox yet.
• Share a screenshot of your LiveLab completion on our submission form!