Building Your Own Database Agent

What You'll Learn

• Interact with tabular data and SQL databases using natural language for efficient data analysis.
• Gain hands-on experience with Azure OpenAI Service, implementing RAG and function calling techniques.
• Utilize Azure OpenAI Service’s Assistants API with function calling and code interpreter features.

About This Course

This course, taught in partnership with Microsoft by Adrian Gonzalez Sanchez, provides a foundational understanding of AI-driven database agents. You'll develop an AI agent that interacts with databases using natural language, making data querying and extraction more accessible.

• Learn knowledge customization levels with Azure OpenAI Service, using RAG to build your first AI agent.
• Load and query tabular data from CSV files using natural language, with the option to analyze your data.
• Implement LangChain agents to connect with SQL databases and translate natural language into SQL code.
• Utilize Azure OpenAI’s function calling feature for secure, efficient SQL agent queries.
• Work with the Assistants API for enhanced connectivity and query capabilities with SQL databases.

By the end of the course, you’ll have the skills to deploy similar systems in your projects, enabling efficient, accessible data interactions.

Course Outline

• Introduction
  Overview of AI-driven database agents and course objectives.
• Your First AI Agent
  Building a basic AI agent with code examples to perform simple data interactions.
• Interacting with a CSV Data
  Loading CSV data and using Azure OpenAI for natural language queries.
• Connecting to a SQL Database
  Establishing a connection to SQL databases and querying them using natural language.
• Azure OpenAI Function Calling Feature
  Utilizing function calling for database interactions, enhancing security and efficiency.
• Leveraging Assistants API for SQL Databases
  Implementing the Assistants API for more advanced SQL database queries.
• Conclusion
  Recap and final thoughts on using AI agents for database interaction.

Who Should Join?

This course is ideal for those interested in using natural language to interact with databases. Basic familiarity with Python programming and database knowledge (CSV and SQL) is recommended.