Skip to Content
View all events

How to Use AI with SQL Databases

Published by Pearson

Intermediate to advanced content levelIntermediate to advanced

Using ChatGPT with Oracle 26ai and SELECT AI

  • Transform database management and analysis with generative AI.
  • Learn techniques and best practices for applying AI to structured and unstructured data.
  • Gain hands-on experience with AI-driven schema generation, query optimization, and document search.
  • Use Natural Language queries in Oracle Database 26ai with “SELECT AI” to extract data from your database without SQL expertise.
  • Use Natural Language queries with MCP in order to have natural language queries with a non-Oracle database.

In this live course, we will explore how modern AI models are revolutionizing how data is leveraged inside and out of the database. By using ChatGPT, SQL, and Oracle Database 26ai, you gain powerful capabilities to enhance, extract, transform, and load (ETL) data flows to allow you to migrate, transform, and clean your data while adhering to schema constraints. You can also generate schemas, optimize queries, and extract insights from your structured data (stored in tables) and unstructured data (stored in files, BLOBs, and CLOBs). The Oracle Database 26ai includes advanced features and capabilities to enable users to perform Natural Language queries to the data in the database with SELECT AI. By integrating AI best practices within your data pipelines, developers, managers, and administrators can significantly improve efficiency and reduce manual workload.

Through practical exercises and real-world use cases, learners will develop skills to leverage AI for intelligent database management, unlocking new capabilities in automation and insight generation, covering AI-driven query optimization, automated schema generation, document search capabilities, and regulatory compliance best practices. Learners will gain practical skills to integrate AI into their workflows with minimal input.

What you’ll learn and how you can apply it

  • You’ll understand how Generative AI can be applied to databases and learn how AI can analyze both structured and unstructured data and transform it into actionable insights.
  • You’ll learn about automated schema creation techniques by using AI to generate database schemas from design wireframes and create sample datasets for your development teams.
  • You’ll learn how to perform AI-Driven document searching. Keyword searching is a thing of the past! Perform searches in natural language based upon your meaning and intent with semantic searches within documents and databases using ChatGPT and Oracle AI tooling.
  • You’ll learn the power of Natural Language Queries in Oracle Database 26ai by using “SELECT AI” to extract data and get insights from your database.
  • You'll learn how to use MCP in order to have natural language queries with a non-Oracle database.

This live event is for you because...

  • You are a data scientist, database administrator, developer, or analyst and you’re looking to integrate AI best practices into your database workflows to improve efficiency and automate processes.
  • You are a software engineer interested in leveraging AI to generate schemas, optimize queries, and enhance database interactions.
  • You are a technical manager or team lead who understands that AI can be used for code generation, and you want to see how AI can accelerate data flows in your business and aid in decision-making.
  • You are a business analyst or data scientist seeking AI-powered techniques for document search, data visualization, and compliance automation.
  • You work in data security, compliance, or governance, ensuring best practices for handling sensitive information, such as PII, while utilizing AI-driven databases.
  • You are a beginner or mid-level professional looking to upskill yourself in AI-powered database solutions without needing extensive prior AI experience.

Prerequisites

  • Basic understanding of SQL for creating tables and performing queries
  • Basic experience with any relational database such as Oracle, PostgreSQL, MySQL, or MariaDB
  • Basic experience using ChatGPT or LLMs

Course Set-up

  • A free developer account with Oracle is highly recommended in order to complete the exercises in this course since some of the exercise will focus on the Oracle Database 23ai
  • An API key for OpenAI
  • Data sets provided in the following repo: https://github.com/BruceTraining

Recommended Preparation

Recommended Follow-up

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Segment 1: Introducing Generative AI for SQL Databases (30 minutes)

  • Overview of the course objectives and key takeaways
  • Understanding how AI can be applied to structured and structured data within the enterprise
  • What to Expect from this Course? (10 minutes)

Segment 2: Automating Schema Creation with AI and ChatGPT (30 minutes)

  • ChatGPT prompts and best practices needed to create database schema from a UI wireframe
  • EXERCISE: Creating a database schema for an e-commerce site within a few seconds
  • EXERCISE: Generating realistic test data for your development teams

Q&A (5 minutes)

Break (5 minutes)

Segment 3: Working with structured data in the enterprise: ETL flows with AI (30 mins)

  • ChatGPT prompts and best practices to extract, transform, and load (ETL) data in your SQL databases
  • EXERCISE: Migrating from app version 1.0 to 2.0 - Cleaning up dirty data

Q&A (5 minutes)

Segment 4: How to manage your unstructured data, Part 1: Working BLOBs and CLOBs (30 mins)

  • Automating flows to understand what’s in an image
  • Creating derived tables from text CLOBs
  • EXERCISE: Working with unstructured data

Q&A (5 minutes)

Break (5 minutes)

Segment 5: How to manage your unstructured data, Part 2: How to Have Q&A with your files (30 mins)

  • How to Load and Search within External Files, Like Word, Excel, and PDF
  • EXERCISE: Loading and Searching within Files

Q&A (5 minutes)

Segment 6: Getting started with the Oracle Autonomous Database 23 AI (30 minutes)

  • New features and capabilities to AI-enable your workflows
  • EXERCISE: How to Chat with data in your database for Q&A

Q&A (5 minutes)

Break (5 minutes)

Segment 7: Using the Data Studio and SELECT AI with Oracle Databases (30 minutes)

  • Learn how to use SELECT AI for natural language queries into your database
  • DEMO: Practical examples of Natural Language queries with SELECT AI

Q&A (5 minutes)

Segment 8: Using MCP with your non-Oracle Database (45 minutes)

  • Learn how to configure and use an MCP server for natural language queries to your database
  • DEMO: Natural Language queries without SELECT AI using MCP

Q&A (5 minutes)

Course Wrap-up and Next steps (10 minutes)

Your Instructor

  • Bruce Hopkins

    Bruce Hopkins is a technical writer and AI expert. He is an Intel Software Innovator for AI, as well as an Oracle Java Champion. Bruce is also the author of the books, "ChatGPT for Java" and the co-author of "Beginning ChatGPT for Python".

    Xlinksearch

Skill covered

SQL