Machine Learning
for Oracle Professionals
Performance Engineering 2
Jump into the future of performance monitoring, alerting and analysis!
Machine Learning Can Be A Complex Venture
"Unless you have a Data Scientist or related background, learning and/or understanding Machine Learning can be a complex venture. Fortunately for those of us with an Oracle background, Craig has designed a course that makes it both appealing and comprehensible in such a way that it makes for a fascinating learning experience...
Machine Learning Is A Must-Have Skill
"As an Oracle database professional, it is my opinion that ML is a must-have skill to add to our arsenal, simply because the volume of systems and performance data that we must analyze is ever-growing, and we simply can’t scale to meet this demand unless we use creative thinking and available algorithms that allow us to be ahead of the game, rather than playing catch up...
This Course Will Not Disappoint
"If you’re interested in Machine Learning, have dealt with solving Oracle performance issues, and are looking to evolve your career, this course will not disappoint. I strongly recommend it."
Lennin A. Tabora
Principal Performance Engineer
Salesforce, Inc.
Why should I attend this class?
It's a career changer
Powerful Machine Learning (ML) is now available to Oracle professionals. Leverage your Oracle expertise while stepping into the data science world of machine learning. It's a game changer!
Learn by building two ML projects
With the Oracle performance-minded professional in mind, you will build two ML systems based on industry standard methods and tools. You can say, "I've built two powerful ML models that I use at work!"
Do "impossible" performance analysis
Current systems have limited perception and analytical capabilities. ML provides a variety of advanced learning algorithms we can train using AWR/ASH and business focused data.
Detect complex pending performance incidents
Once you have built the ML model, near instantaneous and complex analysis occurs. And, the accuracy of your models keeps improving.
You will be taught how to:
Class Pricing:
Class Outline:
Session 0. Pre-class ML Sandbox Environment Setup HERE.
Session 1. Your Future With ML! Oracle Activity Anomaly Detection Basics
Session 2. Oracle Activity Anomaly Detection Advanced Topics
Session 3. Supervised Learning, Models And Accuracy
Session 4. Supervised Learning, Advanced Accuracy Determination
Session 5. Supervised Learning, Incorporating ASH & Model Improvement Strategies
Session 6. Supervised Learning, Feature Reduction, Model Tuning & Prediction
Some Of The Topics Covered:
Jupyter notebooks, DBAs as Data Scientists, working with Python dataframes and arrays, combining datasets, pivoting and/vs one-hot-encoding (OHE), selecting data, supervised vs unsupervised models, supervised models (dummy/naive, decision trees, artificial neural networks, etc.), accuracy determination, checking multiple models quickly, using sysmetric and ASH data, one hot encoding (manual and automatic and saving/using model), grouping samples, filtering out sample rows, recursive feature evaluation, feature correlation analysis, feature importance analysis, center and scaling, cross validation, confusion matrix, rare event problems and solutions, upsampling, SMOTE, label pre-processing, label threshold analysis and determination, dataset split and stratification, validation data, hyper parameter optimization with tuning grid, kmeans algorithm and strategies, time shifting, how to find "labels", deployment challenges and solutions, two very different anomaly detection strategies, the entire process, final model validation, cluster evaluation, anomaly detection process and deployment, cluster data point distance measurement in multi-dimensional space, dimensional reduction techniques, principle component analysis (PCA), independent component analysis (ICA) and more!
Details:
Class Hours: There are 15 hours of live, interactive webinar training divided into six 2.5-hour sessions. To maximize learning and to work with your busy schedule, there will be a 1-3 day gap between 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 and lots of Q&A time. Craig uses Jupyter Notebooks throughout the class, presentation slides and simply typing notes into a text file! All this is available after each session. 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!
After Class Activation/Homework: After each live session, an "activation" (think: homework) will be available for you to download. The activation is project based, uses the exact same Jupyter Note Craig used during the session, focusing on what Craig demonstrated and taught during class, plus some additional analysis. Any slides presented during the sessions will also be available for you to download.
Class Requirements:
You will need:
Certificate of Mastery:
An additional Certificate of Mastery project is available for those who demonstrate they have successfully completed both class projects. Once you complete the certificate project, it is reviewed by the instructor (Craig Shallahamer). Once you receive a passing grade, a signed/authorized/numbered certificate (PDF) is available at no additional cost, i.e. it's FREE!
Welcome OraPub Members!
Enter the member portal and be ready to be transformed in your Oracle DBA work.
© Copyrights by OraPub, Inc. All Rights Reserved.