Module 29

Asking data questions with SQL

Advanced module (after graduation): queries, grouping, joins, injection, a safe tool

When you finish this module you can say:

I can ask a database questions with SQL from Python, bring the result into pandas, and pass user input to a query safely.

By the end of this module you will be able to ask a database questions with SQL, process the result with pandas and write the query tool of a language model safely.

Lessons

6 lessons · ≈ 63 min

1. Table, row, query10 min
2. Filtering and sorting10 min
3. Grouping10 min
4. Joining tables10 min
5. SQL injection and the parameterized query11 min
6. Project: an assistant that questions the database12 min · project

Practice exercises

Short writing exercises, independent of the lessons: Go to the exercises

1. Running low on stock
2. The biggest stores, with pandas
3. A safe author search