You will be able to:

• Work with the core ML processes that all ML projects employ
• Understand and explore our Anomaly Detection (AD) system and its components
• Explain why an anomaly was or was not detected using numbers and pictures
• Explain how AD fits into a broader and existing monitoring and alerting strategy
• Use the industry standard ML Python libraries, various notebooks and project methodologies
• Use AWR and v$ Oracle Sysmetric performance data in your ML models
• Explore multiple unsupervised ML algorithms
• Use Google's free Colaboratory ML environment for immediate ML work
• Leverage your existing Oracle DB skills into the applied ML world
• Launch into ML performance prediction (our ML2 class) once you complete this class

Class Pricing:

• $449 USD for Free members
• $359 USD for Essential & Advantage members (ask for your coupon code)
• FREE for Prime members (just ask to be registered)

Class Outline:

Session 1. Core ML and Pre-processing

• Core ML for the Oracle Professional
  • Why ML is essential for the modern Oracle professional
  • How we use ML in our work
  • Industry-standard ML tools
  • Supervised and Unsupervised learning
  • Process overview for building and deploying ML
  • Anomaly detection strategies and algorithms (clusters and support vector machines)
  • Distance measurement in multi-dimensional space
• Loading Oracle Sysmetric Data
• Pre-processing Introduction
  • Data denormalization
  • Data cleansing
• Model Building
  • K-Means Cluster
  • Support Vector Machine

Session 2. Core Anomaly Detection and Feature Selection

• Pre-processing Necessities
  • Feature scaling
  • Principal Component Analysis
• Feature Selection (FS)
  • Why FS is critically important
  • Why FS is an information destroyer
  • Using Principal Component Analysis
• Anomaly Detection
  • Our process to detect anomalies
  • Threshold detection options
  • Threshold analysis and tuning
• Simulated Realtime Anonymous Detection System
  • Setup options
  • How to use your extracted Sysmetric data
  • Interpreting the results

Session 3. Advanced Pre-processing & Anomaly Analysis

• Advanced Pre-processing
  • The never-ending world of pre-processing
  • Engineering moving average features
  • Engineering datetime-based features
  • Engineering historical knowledge (stepping/windowing) features
  • Manually setting features
  • Detecting and removing highly correlated features
• Cluster And Anomaly Detection Analysis
  • Understanding why an anomaly was detected using plots and statistics
  • Cluster characteristics
  • Dimensionality reduction analysis challenges
• Simulated Realtime Anomaly Detection System
  • Additional options
  • ​​​​​​​Interpreting the results

Details: 

Class Hours: There are 6 hours of live, interactive hands-on class training divided into three 2-hour sessions.

Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations, lots of Q&A time and lots of hands-on action! If you miss a session, you are free to attend that session when the class is offered again.

Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!

Class Requirements:

You will need:

• Experience with any programming language, such as PL/SQL. If you are familiar with Python, that will be helpful, but in no way is it required. Craig has built an interactive "Python Primer" to quickly introduce Oracle professionals to Python. You can download the interactive Python Primer here: https://www.orapub.com/members > Tools - Presentations > Tools > Python Primer
• The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone. Craig Shallahamer (Viscosity's Applied AI Scientist), your teacher, is usually the only one that speaks, but all students are able to type their questions, answers, and comments... it can be very lively and a lot of fun!
• A Gmail account with the ability to connect to the internet using the Chrome web browser. All your hands-on work will be done in Google's free Colabratory web-based environment.