Skip to Main Content
Run SQL queries on PowerPoint slides and notes

About This Workshop

Youtube Video

About This Workshop
Wouldn't it be awesome to query PowerPoint presentations using SQL to find some information in the slides or the notes? Oracle Database can access data from any source, structured or unstructured. You must find a way to ingest those sources into the database and understand their format. This workflow can be built and deployed on Oracle Cloud Infrastructure, where you have all the resources you need at a click. Even a free cloud account can do the job if we consider a simple task like this. For example, this challenge requires an autonomous database, the most basic compute instance and some object storage space. Run this hands-on workshop to find out more.

Workshop Info

2 hours

Lab 1: Provision cloud resources
Task 1: Provision Virtual Cloud Network (VCN)
Task 2: Provision object storage buckets
Task 3: Provision compute instance
Task 4: Install XQ to convert XML to JSON
Task 5: Mount object storage buckets on compute
Task 6: Upload PPTX file to presentations bucket
Task 7: Provision Autonomous JSON Database (AJD)

Lab 2: Deploy file processing components
Task 1: Create OCI credentials to access files in bucket
Task 2: Create processing status table and view
Task 3: Create unprocessed presentations procedure
Task 4: Write and execute PPTX to JSON conversion script

Lab 3: Process JSON files in collections
Task 1: Create collections and cleanup procedure
Task 2: Write and run document processing procedure
Task 3: Create presentation structure, slides and notes views
Task 4: Conclusions and workflow summary
Task 5: Remove presentations from the repository

  • Access to Oracle Cloud Infrastructure
  • Basic knowledge of Oracle Cloud resources
  • Basic knowledge of Linux Bash programming
  • Advanced Oracle SQL and PL/SQL experience

Other Workshops you might like