SQL and databases

Introduction to SQL with AI

Jasmin Ludolf

Senior Data Science Content Developer

Learning SQL with AI

Learning SQL with AI

Learning SQL with AI

Learning SQL with AI

$$

⚠️ AI can make mistakes!

$$

Understand SQL to:

• Spot issues
• Ask the right questions
• Trust the results

$$

Learning SQL with AI

$$

🏆 Course goals:

• Explore databases
• Query data using SQL and AI
  • Count, limit, label, and more
• Write effective prompts
• Analytical workflow

$$

Structured Query Language

$$

• Popular language for communicating with data in databases

$$

• Database: electronic collection of data

$$

Databases

$$

• Structured in tables
• Store massive data

Databases

$$

• Structured in tables
• Store massive data

$$

Storage:

• Live on servers (powerful computers)
• Ideal for collaboration

$$

SQL in industry

$$

• Hospitals treatment outcomes
• Bank fraud
• Customer behavior
• Analysis across industries

$$

SQL with AI

$$

• Describe wants in everyday language

$$

• AI generates the SQL code

$$

• AI adapts to different SQL variations

$$

SQL queries

$$

• Uses commands called queries

$$

• Instructions telling the server what we want from the database

$$

SQL with AI

Prompt: What are the product names?

SELECT product_name
FROM products;

SQL with AI

Prompt: What are the product names?

SELECT product_name
FROM products;

SQL with AI

Prompt: What are the product names?

SELECT product_name
FROM products;

SQL with AI

Prompt: What are the product names?

SELECT product_name
FROM products;

SQL with AI

Prompt: What are the product names?

SELECT product_name
FROM products;

Formatting best practices:

• Capitalize keywords SELECT, FROM
• ; at the end of a query

Learning SQL with AI

$$

• Our AI assistant is connected to PoweredHomes database

$$

Let's practice!

Introduction to SQL with AI