Querying

Querying is the process of asking questions of data. Querying makes use of keys primary and foreign within tables.

Useful Links

• CS50 SQL Course

In DE_Tools see:

• https://github.com/rhyslwells/DE_Tools/blob/main/Explorations/SQLite/Querying/Querying.ipynb

SQL Commands and Examples

• SELECT
• LIMIT
• ORDER
• WHERE
• NOT
• LIKE
• WITH
• INSERT, UPDATE, or DELETE

You can have parameterised queries so that you can pass in variables to it:

• https://github.com/rhyslwells/DE_Tools/blob/main/Explorations/SQLite/Querying/Parameterised_Queries.ipynb

Related terms:

• SQL Joins
• SQL Injection:=Why we should not use f-strings in queries