Grow provides many tools to select exactly which data you want to analyze, and to transform your data to get the insights you need.
However, sometimes you need to do something really specific or different that we haven’t built a tool for. In these situations you or our data analysts will need to use SQL.
But what is SQL? If you don’t know what SQL is, you’re not the first (nor the last, for that matter)! Here is a brief overview of SQL and some resources for you to learn more.
SQL stands for Structured Query Language. You can pronounce it however you want; most people say the letters (“ess-que-el”) but some people also pronounce it the same was as the word “sequel.” Either is fine.
SQL is a query language that is used to communicate with databases, where you hold tables of data. You can both update and retrieve data from the database by using SQL.
SQL has a few key words that tell the database what to do and where to do it. Below are some of the basic function words.
SELECT statements tells the database to pull data from the location in the table specific in the rest of the query.
FROM specifies the table(s) to be queried.
WHERE selects the data values or rows that will be returned, based on the criteria you give it.
We have a help article here that goes through how to uses the SELECT and FROM statements in Grow.
This article here provides some good examples of SQL queries and what it would return in a sample table.
Questions? Email us at firstname.lastname@example.org or chat in on the site.