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!
Check out this useful blog post for instructions on how to get set up with VirtualBox.
23ai Free and VirtualBox is a free database and virtual environment setup available through Oracle! Click the link for a step by step tutorial on how to signup and get started.
Oracle LiveLabs gives you access to Oracle's tools and technologies to run a wide variety of labs and workshops. Signing up for an account to access Oracle LiveLabs is free and requires no credit card information to get started!
Head over to LiveLabs signup page to get started.
- This workshop focuses on working with Property Graphs in Oracle Database 23ai. You will create a graph from two tables, one containing bank account information, and another containing bank transactions information. You will then run graph pattern queries in SQL on this graph. You will find circular payment chains, multi-hop paths between accounts, and more.
- In Oracle Database 23ai, the GRAPH_TABLE function and MATCH clause of the new SQL:2023 standard enable you to write simple SQL queries to follow connections in data. This workshop illustrates how you can model your data as a graph and run graph queries in SQL to quickly see relationships in your data that are difficult to identify otherwise.
- Head over to this workshop for step by step guidance on how to complete this challenge!
- This challenge will provide an introduction to the Structured Query Language (SQL), learn how to create tables with primary keys, columns, constraints, indexes, and foreign keys.
- JSON Relational Duality is a landmark capability in Oracle Database 23ai providing game-changing flexibility and simplicity for Oracle Database developers. This breakthrough innovation overcomes the historical challenges developers have faced when building applications, using relational or document models. JSON Relational Duality converges the benefits of the Relational and Document worlds within a single database. Apps can access the same data as a set of JSON documents or as relational tables and columns without data duplication. Whether you are a Relational/SQL developer, Document database developer, Java or Python App developer, gain first-hand experience building apps using Duality Views.
- Welcome to the Data Grand Slam Challenge! Are you ready to showcase your expertise in data management and analytics? Join us in this challenge where you'll tackle three key tasks:
- MySQL HeatWave Database Creation: Your first challenge is to set up a MySQL HeatWave Database Service to serve as your data warehouse. This will be the cornerstone of your data infrastructure.
- OCI Data Integration to Build Data Pipeline: Next, utilize OCI Data Integration, a powerful, fully managed, serverless, native cloud service, to construct a robust data pipeline. Your mission is to ingest data from diverse sources, perform necessary cleansing, transformations, and reshaping, and efficiently load it into your MySQL HeatWave Database Service.
- OCI Data Science: Once your data pipeline is up and running, it's time to leverage the analytical prowess of OCI Data Science and MySQL HeatWave. Dive into the data, analyze it with precision, and derive insights at lightning speed. Uncover hidden patterns, trends, and correlations that will impress even the most discerning data enthusiasts.
Join us in this challenge to push the boundaries of data management and analytics. Are you up for the challenge?
- SQL, JSON, and MongoDB API: Unify worlds with Oracle Database 23ai Free
- Simple Data Drive Applications using JavaScript in Oracle Database 23ai Free
- Machine Learning on ADB - Choose Your Journey
- Exploring JSON Relational Duality Views in Oracle Database 23ai Free with Java
- Autonomous Database 15 Minute Quick Start
- SQL Empowerment in Oracle Database 23ai: Leveraging Domains and New Features
- Implement Data Sharing with PL/SQL in Autonomous Database
- Introduction to Oracle Spatial Studio
- Analyze, Query and Visualize Graphs in Oracle Database
- Get Started with Graph Studio on Oracle Autonomous Database
- Load and Analyze Your Data with Autonomous Database