Module 3
Asking questions of data: select, filter, count, group and sort
Spreadsheets are fine for small tables and for looking. To ask the same question of a large table, again and again and reliably, lawyers who work with data learn a query language. The most widespread is SQL, which was designed so that its commands read almost like English: select these columns from this table where these conditions hold. It takes an afternoon to learn the core, and it is the skill behind nearly every dashboard. This module teaches the core in a safe subset, and you will practise in the Query Playground, a small, read-only table of invented legal matters that runs in your browser. Nothing you type can break anything, and nothing leaves the page.
Module 1 of this course is free, and this is not it. Unlock the whole course below, or go back to the course page.
Two Ways In
Introductory PriceLegal Data and Dashboards: buy it on its own, or get it with All-Access
Unlock all of Legal Data and Dashboards on its own with a one-time purchase, or get it as part of an All-Access Membership, which also covers every course and the other paid tools. A member never needs to buy it separately.
This is an early, introductory price for a brand-new product — it’s expected to rise as we add more content. Buy now and it’s yours at today’s rate, forever.
No account needed: you pay, and we email you a one-click sign-in.
All-Access is $19.99 a month or $149 a year, and covers every course and most tools, this one included. Create a free account to subscribe.
Look first, then buy. Free previews on every product page. Secure payment by Stripe. Pay once, keep it forever. Details
See what is included in All-Access →General education on legal data and analytics, using invented organisations, datasets and figures. It is not legal advice. Duties about client confidentiality, data protection and the use of data about employees differ between countries and employers: check the rules that apply to you.
Teaching? Share this with your class
Free to use in class. The free parts open for everyone, no account needed.