In Building Your Own Database Agent you will develop an AI agent that interacts with databases using natural language, simplifying the process for querying and extracting insights. Created in partnership with Microsoft and taught by Adrian Gonzalez Sanchez, Data and AI Specialist at Microsoft, this course is designed for developers, data professionals, as well as business analysts and professionals who want more sophisticated interaction with their databases through natural language instead of advanced SQL queries. What you’ll do in this course: 1. Learn about the levels of knowledge customization with Azure OpenAI Service, focusing on RAG to build your first AI agent, deploy your Azure OpenAI Service instance, test the API, and set up an orchestration engine like LangChain to enable these scenarios. 2. Load tabular data from a CSV file and perform natural language queries using the Azure OpenAI service to extract information quickly. Learn to reapply the agent to analyze your own CSV files. 3. Implement LangChain agents to connect to a provided SQL database, and how to build a DB agent that translates natural language to SQL code. 4. Use Azure OpenAI Service’s function calling feature to use pre-built functions for sending queries to databases, improving the efficiency and security of your SQL agent. 5. Work with the Assistants API and test it with the function calling and code interpreter features, which will enable you to connect to SQL databases and create your own DB agents more efficiently. By the end of the course, you’ll be equipped with the technical knowledge and practical experience to implement similar systems in your own projects or organizations, enabling more efficient and accessible data interaction and analysis.
What you'll learn
Develop an AI agent that uses natural language for database queries
Utilize the Azure OpenAI Service for handling tabular data
Implement LangChain agents for SQL database connections
Use function calling features in Azure OpenAI Service to enhance database interactions
Course objectives
Build your first AI agent for database interactions
Set up an orchestration engine and test the API
Load and analyze your own CSV files using natural language queries
Improve efficiency and security of SQL queries with pre-built functions