Schema and data types

Introduction to SQL with AI

Jasmin Ludolf

Senior Data Science Content Developer

Schema

Every table
Relationships
Fields
Data types

Schema example

Schema

Usually not visible to an AI assistant
Review it before writing prompts
Found in documentation
AI assistant in the course knows relevant information
⚠️ Check for permission before providing schema to an AI assistant

Schema example

Schema

Database schema

Schema

Database schema

Schema

Database schema

Schema

Database schema

Schema

Database schema

Introduction to data types

Assigned when the table is created
Depends on the information in the field and operations

AI robot with question marks indicating they don't know

Field operations

SELECT unit_price * 2
FROM products;

...
1299.98
...

Green check mark

SELECT product_name * 2
FROM products;

...
Error!
...

White cross in red circle

Integer

Integer field

Integer

Integer field

Integer

Interger field

Values from approx. negative to positive 2 billion

String

VARCHAR

A sequence of letters, numbers, or symbols

String

VARCHAR

String

VARCHAR

Holds long or short text values

Decimals

Numeric

Decimals

Numeric

Decimals

Numeric

NUMERIC precision sufficient for a few decimals

Understanding data types with AI

Interpret and verify the results ourselves
Guide AI to better answers
AI assistants rarely see schema
Specify fields in our prompts

Person on a laptop learning to code with an AI assistant

Let's practice!

Introduction to SQL with AI