Login

Oracle Database 23ai

Vector Database & Vector Search

DBA to AI-DBA, Start your AI-DBA journey today...

  • Self-Paced Course

  • Learn at your own pace and comfort

  • Doubts clarification via discussion boards/mail/call/WhatsApp

  • Same curriculum as that of Live Training

  • Less cost compared to Live Training

  • Course Recordings with 1 year access

  • Downloadable Resources - Slides, Activity Guide

  • Recommended for busy/working professionals

Enroll Now ₹15000/$215

About the Course

A Vector Database is a specialized database designed to efficiently handle and query high-dimensional Vector data, commonly used in AI & ML applications for fast and accurate data retrieval.

Vector Databases are the next evolution in how we store and retrieve data.

Vector Search enables searching both structured and unstructured data by semantics or meaning, and by values, enabling ultra-sophisticated AI search applications.

Native AI vector search capabilities can also help Large Language Models (LLMs) deliver more accurate and contextually relevant results for enterprise use cases using retrieval-augmented generation (RAG) on business data.

Starting with the 23ai release, Oracle Database supports storing of Vector Embeddings along side with other business data. This makes Oracle Database ideally suited for traditional and AI-based storage models.

This also mandates every traditional Oracle DBA & Developer to master the Vector Database and Vector Search skills to stay up to date & relevant in their Career...

In this course, you will leverage the key capability of Oracle Database 23ai to design and manage Artificial Intelligence (AI) workloads using the new Oracle AI Vector Data type and Vector Search feature.

You will learn how to create tables with vector data type, load data, and the query them based on semantics, rather than keywords. You will learn to perform semantic search on unstructured data by combining it with your relational data in one single system. With hands-on practices, you'll be be able to reinforce the learning of the new AI Vector Search feature and its capabilities.

After completion this course, you should be able to:

  • Describe a Vector Database and the use cases for Vector databases like Oracle Database 23ai

  • Understand how Vector Databases work

  • Distinguish Vector database from the Traditional databases

  • Key Advantages of Vector Databases

  • Describe AI Vector Search features, benefits, and capabilities

  • Understand Oracle AI Vector Search Workflow

  • Run basic queries on vectors

  • Perform DML and DDL operations on vectors

  • Upload Vector Embedding Models into Oracle Database

  • Generate Vector Embeddings using AI Models

  • Store Embeddings in Oracle Tables

  • Create Vector Indexes

  • Use SQL Functions for Vector Operations

  • Perform Vector Search

After completing this course, you'll be able to equip yourself with future-proof skills in AI-powered data management, making you a valuable asset in the evolving tech landscape

Who can take this Course?

  • Oracle DBAs

  • Oracle Developers

  • AI Engineers

  • Cloud Developers

Course Curriculum

Course Overview

  • What you will Learn?

  • Audience

  • Benefits

  • Requirements

Overview of Vector Databases

  • What is Vector Database?

  • What are Vector Embeddings?

  • What is Vector Search?

  • Advantages of Vector Search

  • How does Vector Database work?

  • Difference between Vector Database and Traditional Database

  • Role of Vector Database in AI & ML application development

  • Examples of Vector Databases

Preparing the Practice Environment

  • Download and Import Pre-built VM

  • Perform Sanity Checks

  • Become Familiar with Practice Environment

Overview of Oracle Vector Search

  • Overview of Oracle AI Vector Search

  • Why use Oracle AI Vector Search

  • Oracle AI Vector Search Workflow

Becoming Familiar with Vector Data and Vector Operations

  • Creating Table with Vector Data Type Column

  • Inserting Vector Data

  • Selecting Vector Data

  • Perform DDL, DML Operations on Vector Data

  • Prohibited Operations

Generate Vector Embeddings

  • About Vector Generation

  • Import Pretrained Models in ONNX format

  • Access Third-party Models using REST APIs

Store Vector Embeddings

  • Create Tables using VECTOR Data Type

  • Insert Vectors into tables using INSERT statement

  • Load Vector Data using SQL*Loader

  • Unload and Load Vectors using Oracle Data Pump

Create Vector Indexes and Hybrid Vector Indexes

  • What are Vector Indexes?

  • Why Vector Index?

  • In-Memory Neighbor Graph Vector Index

  • Neighbor Partition Vector Index

  • Sizing the VECTOR POOL

  • Guidelines for using Vector Indexes

  • Hybrid Vector Indexes

  • When to use Hybrid Vector Index?

Use SQL Functions for Vector Operations

  • Vector Distance Functions

    • VECTOR_DISTANCE

    • L1_DISTANCE

    • L2_DISTANCE

    • COSINE_DISTANCE

    • INNER_PRODUCT

    • HAMMING_DISTANCE

    • JACCARD_DISTANCE

    • VECTOR

    • TO_VECTOR

    • VECTOR_NORM

    • VECTOR_DIMENSION_COUNT

    • VECTOR_DIMS

    • VECTOR_DIMENSION_FORMAT

  • Vector Distance Metrics

    • Euclidean and Euclidean Squared Distances

    • Cosine Similarity

    • Dot Product Similarity

    • Manhattan Distance

    • Hamming Distance

    • Jaccard Similarity

Query Data with Similarity and Hybrid Searches

  • Perform Exact Similarity Search

  • Perform Approximate Similarity Search using Vector Indexes

  • Perform Multi-Vector Similarity Search

  • Perform Hybrid Search

Course Videos

Course Materials

Slides-v2.0
Activity Guide - v5.0

General Concepts about Vector Databases

What is Vector Database?
Preview
Vector Embeddings and Vector Search
Preview
Distance Metrics and Vector Indexes

Configuring the Practice Environment

Link to download pre-built VM Image
Preparing the Practice Environment

Overview of Oracle AI Vector Search

What is Oracle AI Vector Search?

Basic Operations on Vectors - DDL, DML Operations

Overview of Performing Basic Operations on Vectors
Lab Practice: Performing DDL, DML Operations on Vectors

Vector Distance Functions and Metrics

Overview of Vector Constructors and Vector Distance Functions
Lab Practice: Vector Constructors and Vector Distance Functions

Vector Indexes

Vector Indexes and Hybrid Indexes
Lab Practice: Creating Vector Indexes

Vector Search

Overview of Oracle AI Vector Search
Lab Practice: Oracle AI Vector Search

Generating Vector Embeddings using AI Models

Overview of Generating Embeddings from AI Models
Lab Practice: Generating Embeddings from AI Models

Start your Vector Database Journey today...

Enroll Today ₹15000/$215