From the course: Build with AI: SQL Agents with Large Language Models

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Red30 sales dataset

Red30 sales dataset

- [Instructor] In the previous video, we introduced the AI agent architecture. In this video, we'll review the Red30 Tech sales dataset. Throughout this course, we'll use this dataset to simulate the work with the database by sending SQL queries generated by the agent. As the name implies, this dataset represent the Red30 Tech online sales data. So with that, let's jump to VS Code and take a look at the data. This dataset is available in the course repository under the data folder. We're going to use in this demo this Jupyter Notebook named 01_02, and it's available under the chapter_1 folder. Let's start by loading the required libraries. We're going to import the pandas and duckdb libraries. Next, we will load the dataset using the read_csv function from the data folder. Let's take a look at the header of the table. Each row in this dataset represent an online sale, and it includes the following information. The date…

Contents