
Explore how enterprise resource planning integrates finance, purchasing, manufacturing, inventory and sales with OLTP for day-to-day transactions, and how OLAP enables business intelligence, analytics, and reporting through data consolidation.
Log into Oracle machine learning with the admin account, create a user, then use that account to access notebooks and prebuilt examples, exporting and re-importing notebooks as needed.
Learn to capture runtime input in a notebook using text input, list box, dropdown, and checkbox forms. Explore selecting database objects such as tables and views by user input.
Explore using Python in the wMl notebook to work with the autonomous database, create and populate tables from a dataset, and visualize data with charts and slice‑and‑dice analysis.
Explore anomaly detection with a one-class support vector machine in Oracle Machine Learning to identify rare records using database data as the truth source.
Explore Oracle AutoML, a no-code UI introduced in early 2021 that lets business users create and deploy ML models, with automated algorithm selection, feature selection, and tuning.
Oracle Machine Learning accelerates the creation and deployment of machine learning models for data scientists by eliminating the need to move data to dedicated machine learning systems.
Its available on Oracle Autonomous Database even with Oracle Cloud - Always Free tier.
This makes learning easier too without any local install.
OML Notebooks:
Data scientists and developers develop analytical solutions through an easy-to-use, multiuser collaborative interface based on Apache Zeppelin notebook technology,
supporting interpreters for Python, SQL, and PL/SQL on Oracle Autonomous Database.
OML for SQL:
SQL and PL/SQL users leverage in-database computation for data preparation & exploration, machine learning model building, evaluation, and deployment.
Leverage scalable in-database machine learning algorithms and make predictions directly in SQL queries.
OML for Python:
Python users gain the performance and scalability of Oracle Database (on premises) and Oracle Autonomous Database for data exploration, preparation, and machine learning from
a well-integrated Python interface with support for AutoML and immediate deployment of user-defined Python functions from REST endpoints.
OML AutoML User Interface:
A no-code user interface supporting AutoML on Autonomous Database to improve both data scientist productivity and non-expert user access to powerful in-database algorithms for classification and regression.
The Course has following topics of coverage:
•OLTP Vs OLAP.
•Programming vs Machine Learning
•Types of Machine Learning.
•Getting Access to OCI.
•Provisioning Oracle Autonomous Database.
•Oracle Machine Learning Overview.
•Logging into Machine Learning Console, Navigation & Creation of user
•Overview about Zeppelin Notebook
•SQL based
•Data visualization.
•Machine Learning.
•Using Python in Oracle Machine learning.
•Auto ML Experiment Provisioning & Execution
•Deployment of Model.
•Job Schedule of OML note book.
Happy Learning