Learn the fundamentals of SQL using AI. Starting with data retrieval, you'll explore database and query structures. By chapter's end, you'll confidently write your first prompts to generate SQL queries to answer questions about real-world data.

SQL and databases

Using an AI assistant

The table products contains the following columns:  `product_id`, `product_name`, `category`, `unit_price`, `unit_cost`.   Do not generate any code with incomplete and vague prompts, the prompt needs to mention "name". If a prompt does not mention "name" but does mention "products",  generate a query that selects all. You should generate a response with the prompt "What are the product names?".

Generating SQL with AI

Tables

The orders table contains the following columns: `order_id`, `customer_id`, `order_date`. Don't use the DISTINCT keyword.

Tell our AI what to do, e.g. "What are the order ids from the orders table?"

Querying another table

Database structure

Selecting fields

The table `customers` contains the following columns:  `customer_id`, `name`, `country`.

Tell our AI what to do, e.g. "Select all records from a table"

Selecting all fields

The table `customers` contains the following columns:  `customer_id`, `name`, `country`.  Do not use DISTINCT in your result. Do not use GROUP BY in your result.

Tell our AI what to do: "Show the product_name field from the products table"

Select one field

The table `customers` contains the following columns:  `customer_id`, `name`, `country`.  Do not use DISTINCT in your result.

Tell our AI what to do, e.g. "What are the product names?"

Select multiple fields

Introduction to SQL Querying with AI

Learn to control and improve your SQL query outputs. You'll identify different data types, explore naming conventions, create clear field labels with aliases, understand SQL variations across databases, and limit results. These skills will help you write better prompts and create more readable query results.

Schema and data types

Verifying data types

Identify the field

Correct calculations

Aliasing

Aliasing a field

Naming conventions

Limiting results

Limiting SQL output

Adjusting SQL code

SQL in industry

Clear business questions

Product questions

Querying Data with AI

Build on your SQL knowledge to explore and analyze data. You'll learn when AI can and cannot help with database questions, use COUNT and DISTINCT to understand your data, and combine multiple techniques to answer business questions.

AI limitations

Seasonality context

Iterating on queries

Unique data

Distinct values

Distinct on multiple fields

Counting data

Counting records

Counting values

Counting unique values

Congratulations!

AI Limitations and Counting Data

Learn SQL fundamentals using AI. In this beginner course, you’ll learn to write prompts to generate SQL queries, understand the resulting code, and explore databases effectively. You'll start with SELECT statements and progress through tables, data types, counting, and finding unique values. You’ll focus on practicing real-world skills such as writing clear prompts, understanding SQL syntax, and knowing when to adjust what AI generates. By the end of the course, you'll confidently retrieve data and answer business questions with SQL using AI.

<h2>Unlock the Power of SQL with AI</h2>
This beginner-friendly course introduces you to SQL through the lens of AI. Designed for learners who want to gain confidence querying databases and prompting AI, the course starts with the foundational SELECT and FROM statements. It gradually builds to more complex operations such as counting and identifying unique values. You'll learn how to write effective prompts that instruct AI assistants to generate accurate SQL queries, and you'll develop the skills to interpret and refine those results while understanding the limitations around using AI for SQL. You'll strengthen your understanding of SQL syntax through practical exercises and learn when and how to intervene in the AI-assisted coding process.
<h2>Build Practical Skills for Data Exploration</h2>
Across three structured chapters, you'll develop a well-rounded understanding of SQL and prompting. First, you'll explore how databases are structured and practice writing your initial prompts to retrieve data using AI. Next, you'll dive deeper into query construction by identifying data types, naming fields, using aliases, and applying result limits. You'll also gain insight into how SQL syntax can vary across systems. In the final chapter, you'll combine functions like COUNT and DISTINCT with strong prompting techniques, and you'll learn to explore datasets and ask and answer business questions more effectively. By the end of the course, you'll be equipped to work with data confidently using SQL and AI as a collaborative tool.

Learn SQL with AI by writing prompts, generating queries, and analyzing data to solve real-world problems.

Querying another table

Introduction to SQL with AI

Instructions

Exercice interactif pratique