At a Glance

Name: Talk to MySQL using Natural Language Query (NLQ) with AI
Price: Free CAD
Rating: 4.8 (16 reviews)
Author: karan_goswami, ricky_shi, joseph_santarcangelo, kunal_makwana, wojciech_fulmyk

Learn how to use AI-powered Natural Language Queries (NLQ) to interact with MySQL databases using plain English. You'll discover how to count, join, describe tables, and perform grouping operations - all without writing SQL code. This lab demonstrates how AI can transform data analysis by making it more intuitive and accessible. By enabling users to simply ask questions in everyday language, teams can quickly gain valuable insights from their data without needing SQL expertise.

In this guided project, you will learn how to leverage AI-powered Natural Language Queries (NLQ) to interact with databases, like MySQL and MariaDB, using plain English. Through hands-on examples, you'll discover how to count records, describe table structures, join multiple tables, and perform grouping operations - all without writing SQL code. This lab demonstrates how AI can transform data analysis by making it more intuitive and accessible. By enabling users to simply ask questions in everyday language, teams can quickly gain valuable insights from their data without needing SQL expertise. In just 30 minutes, you'll set up a system that empowers business users and stakeholders to directly query databases, democratizing access to data-driven decision making.

Natural language query (NLQ)

"How many employees are there"
AI-generated Structured Query Language (SQL)
SELECT COUNT(*) FROM Employee

-------------------------------------------------------------------------------------------------------------------------
Natural language query (NLQ)

"How many Albums are there in the database?"
AI-generated Structured Query Language (SQL)
SELECT COUNT(*) FROM Album

-------------------------------------------------------------------------------------------------------------------------
Natural language query (NLQ)

"Can you left join table Artist and table Album by ArtistId? Please show me 5 Name and AlbumId in the joint table."
AI-generated Structured Query Language (SQL)
SELECT Artist.Name, Album.AlbumId FROM Artist LEFT JOIN Album ON Artist.ArtistId = Album.ArtistId LIMIT 5;
--------------------------------------------------------------------------------------------------------------------------------------
Natural language query (NLQ)

" Which country's customers spent the most by invoice?"
AI-generated Structured Query Language (SQL)
SELECT Customer.Country, SUM(Invoice.Total) FROM Customer

INNER JOIN Invoice ON Customer.CustomerId = Invoice.CustomerId
GROUP BY Customer.Country
ORDER BY SUM(Invoice.Total) DESC LIMIT 1;
--------------------------------------------------------------------------------------------------------------------------------------

**Natural Language Query (NLQ):** Describe the PlaylistTrack table

**Response:**

**Natural Language Query (NLQ):** How many employees are there

**Response:**

**Natural Language Query (NLQ):** Can you left join table Artist and table Album by ArtistId? Please show me 5 Name and AlbumId in the joint table.

**Response:**

What You'll Learn

After completing this project, you will be able to:

- **Integrate natural language processing**: Use AI tools to interpret natural language queries.

- **Execute SQL queries from natural language**: Translate natural language questions into SQL queries to fetch relevant data from the MySQL database.

What You'll Need

Before starting this guided project, you should have:

- An understanding of natural language processing concepts is beneficial but not required.

- Access to a modern web browser such as Chrome, Edge, Firefox, Internet Explorer, or Safari.

Offered By: IBMSkillsNetwork

Talk to MySQL using Natural Language Query (NLQ) with AI

At a Glance