Machine Learning from your browser with SQL Notebooks

Photo by Mika Baumeister on Unsplash

Database administrators have managed more data than anybody else in our field. The more I know about managing data in production, the more I realise how complex it is.

This is me paying back for all the time I saw DBAs as obstacles on deploying my applications. They were actually looking after me.

The ubiquitous SQL language is a nice way to explore Machine Learning. SQL is close to where the data lives. And the experts on that data already knows the language.

SQL Notebook is a browser-based application where you can run SQL queries, create reports, analyse data, and even run Machine Learning algorithms. You don’t really need to learn other language or deploy new infrastructure.

Oracle Machine Learning for SQL (OML4SQL) gives you in-database algorithms through PL/SQL functions to apply prediction models, and this is how.

Try it out

You can try it out in just a few minutes — no need to install or configure anything on your computer. Create an Oracle Autonomous Database for free on Oracle Cloud. You can execute all the SQL statements with SQL Developer Web.

Do you have an Oracle Cloud Account? If not, you can create one here:

Remember, Oracle Cloud does not charge you anything unless you explicitly request the upgrade to pay as you go. No problem.

Oracle Cloud Sign-up for free

As soon as you have access to your account, create an Autonomous Database like in the video (no need for SQL Developer Web but it is a nice trick, check it out):

Create OML User and log-in

Follow the steps on this 50-second video to create a new user for Oracle Machine Learning (OML).

After the steps on the video, you will be logged in and ready for the action.

ML Regression model example

Oracle Machine Learning comes with pre-packaged examples that can give you an idea of what this technology can do.

Click on Quick Actions > Examples.

For example, let’s try OML4SQL Regression. This notebook shows how to predict numerical values using multiple regression. I love notebook examples because they are self-explanatory by using markdown language.

This is a fragment of what you can see in the Regression example. The steps are: create the data set, split 60/40 for training and test, build and configure the model, and make some predictions—all of this by showing tabular data, graphics, etc.

Want to learn more?

If you like what you’re reading and interested in taking on some of these challenges with our team, do check out our free training sessions on many topics like Spatial and Graph, Document database, APEX, Digital Assistant, etc.

Check the next training on Oracle Cloud

There are periodic free training sessions, around 1 hour long, done by experts and Oracle Cloud Advocates. These are instructor-led training. You can follow along with our team to solve your questions on the spot.

And keep tuned for more articles about the amazing things you can build with Oracle Cloud.

I am Victor Martin, a Software Developer. I deploy on Oracle Cloud Infrastructre.

Feel free to get connected with me on LinkedIn.

I am also interested on Scuba diving and space engineering. Happy to help, everything is easier than rocket science!

Principal Cloud Engineer. All opinions are my own. @OracleCloudInfrastructure