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!
If you have any questions about Oracle or their Global Hack Week challenges, head to the MLH Discord and find the #ask-oracle channel!
Head over to the Oracle sign up page to get set up with a new Oracle account.
A standard account will include up to $300 worth of credit for a new sign up.
- Remember to make your home region Chicago during sign up so that you can utilize Gen AI services!
- Learn about API Management in Oracle Cloud Infrastructure.
Whether you are an advanced developer, or just trying out your first database, Oracle Database 23c Free is a great way to started! If you have a familiarity with SQL and JSON objects, this is an ideal way for you to add another skill to your hacker toolbelt.
Check out this useful blog post on how to get started!
- Learn more about Oracle Database 23c Free and set up a free instance to get started.
- Check out Oracle's Live Labs to try out some of their featured workshops
- Check out the Oracle Database 23c documentation!
- SQL, JSON, and MongoDB API: Unify worlds with Oracle Database 23c Free.
- Oracle Databse 23c Free is a widely used and documented database solution. Check out the FAQs for more support.
- Get ready to revolutionize the application's advertising game! Join the Ad Mastery Challenge to build a dynamic ad messages API and integrate it into the application's interface.
- In this challenge, discover how Oracle makes it easier to build and deploy cloud-native applications in Oracle Cloud Infrastructure (OCI).
- Learn how to effortlessly develop applications using the code editor in OCI, and then deploy them using Kubernetes.
- And since every app needs a database, why not leverage Oracle’s managed MySQL HeatWave Database to simplify deployment and management tasks?.
- Head over to this workshop for step by step guidance on how to complete this challenge!
- Identify the best places in the North Eastern US to host a solar eclipse viewing party
- Build an application using APEX showing the cities closest to the solar eclipse path of totality. As a bonus generate a map to visualize your results.
- Given the provided datasets, load the datasets to the database and write queries to find the following:
- Find all US cities with a population > 10,000 that are within 10 miles of the center line representing the path of the total eclipse over the course of the day
- Find the cities in the states Vermont, New Hampshire, and Maine (VT, NH, ME) with a population greater than 5000 and which are less than 50 miles from the center.
- Add the GEOM column to the query above
- Display the results of these queries in your Apex application
- Sign up for an account with OpenWeatherMap and use the 5 day/ 3 hour API to provide weather predictions for your chosen location
- Set up a REST data source using the OpenWeatherMap and use the API provided to display weather predictions for given lat/lon
- Identify which cities in Northeastern US are closest to the path of totality, taking into account the weather conditions, and make a recommendation on where to host a viewing party.
- The recommendation should include a description as to why the recommendation was made.
- BONUS:
- Create a map visualizing the US with the path of the solar eclipse. Add all the cities in Ohio, Pennsylvania, New York, and Vermont (OH, PA, NY, VT) with a population greater than 10,000
- Learn how to create a REST service using Oracle REST Data Services (ORDS) on an Autonomous Database.
- You will start by creating an application user whom you will use throughout all the lab steps.
- Once created, we will load data and create a table in our database.
- Using the same UI, we will REST enable that table so that endpoints created for all major operations (create, update, query, delete). Lastly, we will use OAuth to secure the REST service endpoints.
- This challenge can be completed entirely from the Database Actions UI that is provided with all Oracle REST Data Services (ORDS) installs and with the Autonomous Database in Oracle Cloud Infrastructure.
- In this challenge, you'll dive into the world of books by creating an exciting Online Bookstore App using Oracle APEX.
- With AI and smooth API connections, you'll build a smart platform where users can search for books and receive personalized recommendations based on their reading preferences.
- You'll gain practical skills in Oracle APEX, as well as integration of AI and REST APIs while exploring how technology can enhance the experience of online book shopping.
- You can use this workshop as reference for completing this challenge!
- Note: Instead of Lab 1: For creating Rest Data Source, use this API.
- You can download 23C database for free and host your data locally using the following link: https://hackp.ac/ghwapi24-oracle-23c
- You can download Oracle's autonomous database for free with no payment information required here: https://hackp.ac/ghwapi24-oracle-adb
- You can also download an instance of Oracle Rest Data Services here: https://hackp.ac/ghwapi24-oracle-restData