Skip to Main Content
MySQL Heatwave Lakehouse: Realtime Asset Maintenance

About This Workshop

Youtube Video

About This Workshop
This workshop offers a hands-on experience with a Manufacturing Lakehouse, demonstrating how to leverage OCI services such as ObjectStore, MySQL Heatwave, OCI Streaming, Functions, Data Flow, Machine Learning, Data Catalog, and OAC for real-time asset maintenance

Workshop Info

Lab 1: Create Demo Compartment and ObjectStore Buckets and upload Data
Lab 2a: Create VCN and Compartment for workshop
Lab 2b: Create Compute instance for workshop and configure MySQL Shell
Lab 2c: Create MySQL Database System in Oracle Cloud
Lab 2d: Enable Lakehouse and Create MFG_SENSOR Database/Table in MySQL Database System
Lab 3: Build ML model API to evaluate the probability of device failures
Lab 4a: Set up OCI Stream service & Execute Sensor Data Simulator
Lab 4b: Setup Dynamic Group for function to manage stream/objects
Lab 5: Set up and Deploy OCI function and connect to service connector Hub
Lab 6a: Set up OCI Dataflow and deploy a Pyspark Application and load the datasets from demo-events-silver-mysqlhw to Heatwave
Lab 6b: Load the datasets from demo-events-silver-mysqlhw to MYSQL HW
Lab 7: Design and Develop OAC Dashboards
Lab 8: Set up OCI Data Catalog
 

  • Familiarity with using OCI MYSQL HW, Streaming data, functions ,dataflow and Oracle Analytics Cloud.

  • Familiar with Python programming for SDK usage is strongly recommended.

  • Familiar with Machine Learning is recommended, but not required.

Other Workshops you might like