Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Free module

Text to SQL with checks

Learn text to SQL hands on: describe a schema for a language model, check its SQL by reading and running it, keep it read only and score it.

6 lessons405 min lessonSoftware engineering

The lessons

Each lesson is free to read in full. Create a free account to run its commands in a live lab and to sit its quizzes and tasks.

  1. 1 · Container lab

    Putting a database schema in the prompt

    I can describe a database schema briefly enough for a model to write SQL from it.

    Read the lesson

  2. 2 · Container lab

    Reading SQL a language model wrote

    I can read a model's query and say whether it answers the question asked.

    Read the lesson

  3. 3 · Container lab

    Checking model SQL by running it

    I can check a model's query by running it on data with a known answer.

    Read the lesson

  4. 4 · Container lab

    Running model SQL read only, with limits

    I can run a model's query so that it can only read, a little at a time.

    Read the lesson

  5. 5 · Container lab

    An evaluation set for text to SQL

    I can score candidate queries against a set of questions with known answers.

    Read the lesson

  6. 6 · Container lab

    Explaining a text to SQL answer

    I can write a reply that shows the query, admits doubt and asks when a question is vague.

    Read the lesson

Worked in a real lab

Every lesson of this module is worked in a lab started for you alone. The labs it uses:

Teaching a class? Set this module for your students with a teacher guide, marked assignments and a lab for every student.