DEV Community

SQL concepts from A to Z

Helen Anderson on February 06, 2019

It's time for some jargon-busting. A big part of my role is to onboard and support junior data analysts. A lot of them have just started using SQL...

Read full post

rhymes • Feb 6 '19

Great "SQL vocabulary" you have here. Also, thanks for quoting me!

Stay tuned for a post dedicated to a deep dive on this topic

Can't wait, window functions are my favorite "modern SQL" feature and I think many devs don't know how much they are missing :D I wanted to write about them eventually but it would definitely be better if you do it!

Helen Anderson • Feb 6 '19

Thanks rhymes

You had such a perfect explanation I had to include it :)

LuckyArthas • May 9 '21

Wonderful topic.

There was a spark in my head.
I have an lack of knowledge with relational and non-relational database. In some cases, please post about what can I choose and why it is convenient.
Thanks a lot. ( 💝 I will follow you all the time 💝 )

Evaldas Buinauskas • Feb 12 '19

A foreign key is a column that matches a primary key in another table so we can join the data in each together.

This is partially true. Foreign keys can also reference unique (alternate) keys. 👌

Also foreign key is not required to join data. It just enforces integrity. But you know that 😊

Todd M Owens • Jun 30 '20

Kudos. This is sorely needed and fairly well done. My only real critique is there is not enough context or priority for each entry. But I understand there is a trade-off.

Now for my not serious critique, if you non-American anglophones could only learn:

to use a "z" in words like "normalize"; show "z" some love.
to not overuse "u" and make words like "favor" and "color" too long.
stop doubling consonants in unaccented terminal syllables; it's "modeling" not "modelling".