Breadcrumb

This tutorial shows you how to create a Notebook and run it in Oracle Machine Learning. This is the second tutorial in the series Getting Started with Oracle Machine Learning. Read the tutorials in sequence.

1. Creating Projects and Workspaces in Oracle Machine Learning
2. Creating and Running Notebooks in Oracle Machine Learning
3. Collaborating in Oracle Machine Learning
4. Creating SQL Scripts in Oracle Machine Learning
5. Running SQL Statements in Oracle Machine Learning

SQL or Structured Query Language is the language standard for relational database management systems. You can use SQL statements to perform tasks such as retrieving data from a database, update data on a database and so on. Some examples of SQL statements are SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP. In this OBE, we will look at how to create a SQL script.

This is the fourth tutorial in the series Getting Started with Oracle Machine Learning. Read the tutorials in sequence.

1. Creating Projects and Workspaces in Oracle Machine Learning
2. Creating and Running Notebooks in Oracle Machine Learning
3. Collaborating in Oracle Machine Learning
4. Creating SQL Scripts in Oracle Machine Learning
5. Running SQL Statements in Oracle Machine Learning

This tutorial shows you how to run SQL statements in Oracle Machine Learning. This is the fifth and the last tutorial in the series Working with Oracle Machine Learning. Read the tutorials in sequence.

1. Creating Projects and Workspaces in Oracle Machine Learning
2. Creating and Running Notebooks in Oracle Machine Learning
3. Collaborating in Oracle Machine Learning
4. Creating SQL Scripts in Oracle Machine Learning
5. Running SQL Statements in Oracle Machine Learning

This tutorial shows you the steps to create a project and a workspace in Oracle Machine Learning. This is the first tutorial in the series Getting Started with Oracle Machine Learning.

This OBE explains the steps to create your own project, and optionally your workspace. Read the tutorials in sequence.

1. Creating Projects and Workspaces in Oracle Machine Learning
2. Creating and Running Notebooks in Oracle Machine Learning
3. Collaborating in Oracle Machine Learning
4. Creating SQL Scripts in Oracle Machine Learning
5. Running SQL Statements in Oracle Machine Learning

This tutorial shows you how to collaborate and share notebooks with other users in Oracle Machine Learning. This is the third tutorial in the series Getting Started with Oracle Machine Learning. Read the tutorials in sequence.

1. Creating Projects and Workspaces in Oracle Machine Learning
2. Creating and Running Notebooks in Oracle Machine Learning
3. Collaborating in Oracle Machine Learning
4. Creating SQL Scripts in Oracle Machine Learning
5. Running SQL Statements in Oracle Machine Learning

This tutorial covers the development and use of Analytic Views to perform dimensional and hierarchical analysis

This tutorial covers Oracle Database 12c attribute clusters and zone maps, features designed to offer significant IO reduction for queries that would otherwise perform full table scans.

There are several features in Oracle Database 12c Release 1 of which you can take advantage
when it comes to Data Warehousing and Business Intelligence (BI).

• You can use multipartition maintenance operations which enable adding multiple partitions to a table, dropping multiple partitions, merging multiple partitions into one partition, splitting of a single partition into multiple partitions, and truncating multiple partitions using a single SQL data definition language (DDL) statement.
• You can also recognize patterns in a sequence of rows by using the MATCH_RECOGNIZE clause in native SQL which executes efficiently.
• The new Synchronous Refresh feature will always keep a base table in sync with a Materialized View (MV) that is built on it.
• You can also improve query performance against OLAP cubes.
• Finally, local and global indexes can now be created on a subset of the partitions of a table. This feature provides more flexibility in index creation. Global index maintenance can now be delayed and decoupled using DROP and TRUNCATE partition without making a global index unusable. This new feature provides faster DROP and TRUNCATE partition operations. Index maintenance can be delayed to off-peak time.

This podcast is the first in a series of podcasts that will look at the core concepts behind Oracle’s in-database SQL analytics and examine, in detail, some of the key features and functions.

In this podcast we review some of the key concepts around the way data sets are processed by SQL analytics

In this podcast we continue our review some of the key concepts around the way data sets are processed by SQL analytics

In this simple demo we explore how to calculate the average 90 day stock balance using SQL analytics.

In this podcast we review some of the optimizations included in the database to support the SQL analytics

In an earlier podcast we introduced the concepts of windows in this podcast we are going to look a little deeper at how analytical windows work.

In this podcast we explore some examples of how to use SQL analytics to answer some typical business questions.