Webinar Description

In this workshop you will create a 2-node Oracle Real Application Clusters database in the Oracle Cloud. Oracle Cloud Infrastructure offers 2-node RAC DB systems on virtual machines. When you launch a virtual machine DB system, you choose a shape, which determines the resources allocated to the DB system. After you provision the system, you can change the shape to adapt to new processing capacity requirements.

Agenda

• Generate SSH Keys
• Build a DB System
• Clusterware and Fencing
• Fast Application Notification
• Install Sample Schema
• Services
• SQL and PL/SQL - Sequences
• Parallel Execution
• Oracle Scheduler
• PL/SQL Packages
• Q & A

Prerequisites

• Familiarity with Oracle Database RAC concepts and the Oracle Database
• Working knowledge of vi editor (or vim)
• Some understanding of cloud and database terms is helpful
• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.

NOTE: In order to access the session landing page, you will need to sign in with your oracle.com account. If you do not have one, you can create one here. A Join button will appear on the landing page 15 minutes prior the session (you may need to refresh the browser).

This curriculum is part of Cloud Customer Connect's series of live Workshops for OCI users, where architects and product managers provide technical deep dives, answer your questions, and deliver the latest updates.

Webinar Description

The labs in this live virtual hands-on workshop cover an introduction to Oracle Cloud Infrastructure (OCI) Core Services, including virtual cloud networks (VCN), compute and storage services.

Agenda

• Introduction to Oracle Cloud Infrastructure (OCI) Core Services
• Hands-on Labs include:
• Create SSH Keys Using Oracle Cloud Shell
• Identity and Access Management
• Virtual Cloud Networks
• Create a Compute Service
• Create and Attach a Block Volume Service
• Create an Object Storage Service
• Q & A

Prerequisites

• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.

NOTE: In order to access the session landing page, you will need to sign in with your oracle.com account. If you do not have one, you can create one here. A Join button will appear on the landing page 15 minutes prior the session (you may need to refresh the browser).

This curriculum is part of Cloud Customer Connect's series of live Workshops for OCI users, where architects and product managers provide technical deep dives, answer your questions, and deliver the latest updates.

Webinar Description

This workshop focuses on Creating Active Data Guard 19c in Oracle Cloud Infrastructure using the Oracle Cloud. Explore fundamentals of Active Data Guard on 19c. Perform switchover, failover, DML Redirection and more!

Agenda

• Create primary database
• Create standby database
• Connect to the database
• Perform a switchover
• Perform a Failover
• Enable Active Data Guard DML Redirection
• Automatic block media recovery
• Restore point propagation
• Change the SYS password using the tooling
• Q & A

Prerequisites

• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.

NOTE: In order to access the session landing page, you will need to sign in with your oracle.com account. If you do not have one, you can create one here. A Join button will appear on the landing page 15 minutes prior the session (you may need to refresh the browser).

This curriculum is part of Cloud Customer Connect's series of live Workshops for OCI users, where architects and product managers provide technical deep dives, answer your questions, and deliver the latest updates.

Webinar Description

Explore the latest features in Database 23ai. Oracle Database 23ai is the new long term support release version of the database, packed with hundreds of new features. Each lab in this workshop can be run individually or in any order you choose.

Agenda

• Introduction
• Get Started
• Database Setup
• Application Development
• Lab: AI Vector Search
• Lab: JSON Duality Views
• Lab: Property Graphs
• Lab: SQL Domains
• Lab: Annotations
• Lab: JSON Schema
• High Availability
• Security
• Lab: SQL Firewall
• Lab: Schema Level Privileges
• Lab: Developer Role
• Performance & Database Lifecycle Management
• Lab: Shrink Tablespace
• Lab: Error Message Improvements
• Lab: SQL Analysis Report
• SQL Enhancements
• Lab: Boolean
• Lab: IF Exists for DDL
• Lab: New Table Value Clause
• Lab: Direct Joins for Updates and Deletes

Prerequisites

• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.

NOTE: In order to access the session landing page, you will need to sign in with your oracle.com account. If you do not have one, you can create one here. A Join button will appear on the landing page 15 minutes prior the session (you may need to refresh the browser).

This curriculum is part of Cloud Customer Connect's series of live Workshops for OCI users, where architects and product managers provide technical deep dives, answer your questions, and deliver the latest updates.

Webinar Description

The main purpose of this workshop is to teach you how you can implement a RAG (Retrieval Augmented Generation) chatbot using vector similarity search and Generative AI / LLMs.

In today’s data-driven world, effectively managing and utilizing information is crucial for any organization. Whether dealing with customer support data, product documentation, or internal knowledge bases, organizing and retrieving relevant information from vast collections can be challenging. This tutorial demonstrates a comprehensive approach to processing, storing, and leveraging textual data using vectorization and retrieval techniques. By the end of this tutorial, you’ll understand how to transform raw documents into structured data, store them efficiently, and utilize advanced AI models to generate contextual responses.

Agenda

• Introduction
• Get Started
• Lab 1: Setup the vector database (Oracle Database 23ai)
• Lab 2: Setup the Python Environment
• Lab 3: Generate vector embeddings
• Lab 4: Vector retrieval and Large Language Model generation
• Lab 5: Next Steps

Prerequisites

• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.

NOTE: In order to access the session landing page, you will need to sign in with your oracle.com account. If you do not have one, you can create one here. A Join button will appear on the landing page 15 minutes prior the session (you may need to refresh the browser).

This curriculum is part of Cloud Customer Connect's series of live Workshops for OCI users, where architects and product managers provide technical deep dives, answer your questions, and deliver the latest updates.

Webinar Description

Oracle Application Express (APEX) is a low-code application development environment that creates database-centric applications. Analytic views are a dimensionally oriented semantic layer in the Oracle Database that can serve as a foundation for business intelligence applications. Analytic views mask the underlying complexity of tables and views, define aggregation rules, include analytical expressions to create calculated measures and provide rich descriptive metadata.

This Live Lab will teach you how to use both to build a powerful, interactive analytic application. You will learn how analytic views enhance the capabilities of APEX applications with aggregations and rich calculations while simplifying SQL generation at the same time. More power, less work. What could be better?

Agenda

• Lab 1: Provision an Autonomous Database
• Lab 2: Open SQL Worksheet
• Lab 3: Create a Database User
• Lab 4: Install Sample Data
• Lab 5: Explore the Data Tables
• Lab 6: Create an Analytic View
• Lab 7: Examine Analytic Queries that Select from Tables
• Lab 8: Examine Lookup Queries
• Lab 9: Examine Hierarchies and Analytic Views
• Lab 10: Examine Analytic Queries that Select from the Analytic View
• Lab 11: Create a New APEX Application
• Lab 12: Add Queries that Select from the Analytic View
• Lab 13: Add Data Selectors to the Sales Dashboard

Prerequisites

• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.

NOTE: In order to access the session landing page, you will need to sign in with your oracle.com account. If you do not have one, you can create one here. A Join button will appear on the landing page 15 minutes prior the session (you may need to refresh the browser).

This curriculum is part of Cloud Customer Connect's series of live Workshops for OCI users, where architects and product managers provide technical deep dives, answer your questions, and deliver the latest updates.

Webinar Description

This workshop focuses on working with Property Graphs in Oracle AI Database Free. You will create a graph from two tables, one containing bank account information, and another containing bank transactions information. You will then run graph pattern queries in SQL on this graph. You will find circular payment chains, multi-hop paths between accounts, and more.

In Oracle AI Database Free - Developer Release the GRAPH_TABLE function and MATCH clause of the new SQL:2023 standard enable you to write simple SQL queries to follow connections in data. This workshop illustrates how you can model your data as a graph and run graph queries in SQL to quickly see relationships in your data that are difficult to identify otherwise.

Agenda

• Overview of Oracle AI Database
• Create a Property Graph from relational tables
• Run graph pattern queries in SQL, using the new syntax from the SQL:2023 standard implemented in Oracle AI Database
• Q & A

Prerequisites

• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• All attendees need to have an Oracle account to be able to login to the workshop portal. Attendees who don't have one are advised to create an account at www.oracle.com before joining the workshop session. Please note that you only need to create an oracle account and NOT a cloud account.