Using AI with SQL Databases
Published by O'Reilly Media, Inc.
Intelligent database management using ChatGPT with Oracle 26ai and SELECT AI
What you’ll learn and how you can apply it
- 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 to have natural language queries with a non-Oracle database
Course description
Modern AI models are revolutionizing how data is leveraged inside and out of the database. With ChatGPT, SQL, and Oracle Database 26ai, users gain powerful capabilities to enhance, extract, transform, and load data flows and to migrate, transform, and clean data while adhering to schema constraints. The Oracle Database 26ai includes advanced features and capabilities that enable users to perform natural language queries to 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.
Join Bruce Hopkins to unlock new capabilities in automation and insight generation and gain practical skills to integrate AI into your workflows with minimal input. Through practical exercises and real-world use cases, you’ll discover how to leverage AI for intelligent database management, including AI-driven query optimization, automated schema generation, document search capabilities, and regulatory compliance best practices.
This live event is for you because...
- You’re a data scientist, database administrator, developer, or analyst who’s looking to integrate AI best practices into your database workflows to improve efficiency and automate processes.
- You’re a software engineer interested in leveraging AI to generate schemas, optimize queries, and enhance database interactions.
- You're a technical manager or team lead who wants to see how AI can accelerate data flows in your business and aid in decision-making.
- You’re 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’re a beginner or mid-level professional looking to upskill yourself in AI-powered database solutions without needing extensive prior AI experience.
Prerequisites
- A free developer account with Oracle is highly recommended to complete exercises
- An API key for OpenAI
Recommended preparation:
- Data sets provided in the course repo
- Explore Data Science Made Easy (on-demand course)
- Explore SQL for Any IT Professional (on-demand course)
Recommended follow-up:
- Read Real-World Data Mining for Databases (book)
Your Instructor
Bruce Hopkins
Bruce Hopkins is a technical writer, an AI expert, an Intel Software Innovator for AI, and an Oracle Java Champion. He’s also the author of ChatGPT for Java and the coauthor of Beginning ChatGPT for Python.
Skills covered
- SQL
- Apache Spark