SQL 101

by Hannah Laughton

If you're like me and you've never touched SQL (Structure Query Language) in the past, this blog post is for you!

So what is SQL? Languages are translated by drivers into SQL (which is a language that databases understand) in order to obtained/manipulate the data that is stored in the database.

Now that you know what SQL is, it's time to find out how to understand the code. To make this easy, there are 6 Key Words you need to remember (of which I will only be covering 4 as I myself haven't covered the remaining two) - yay, this makes life even easier!!

1.  Select: What I want - point to field(s).

2. From: Where am I getting info from (for example, in Snowflake it is of the format database - schema - table).

3. Where: Filter on row basis.

4. Group By: Aggregate to dimension level.

5. Having: Filter after aggregation (has to be used after Group By).

6. Order: How do I want it ordered.

See below to speak in Alteryx terms (credit to the owner of the slides used).

I hope this makes things clearer!

Avatar

Hannah Laughton

Fri 25 Nov 2022

Thu 24 Nov 2022

Wed 23 Nov 2022

Tue 22 Nov 2022