DEV Community

Cover image for SQL concepts from A to Z

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. Many have just started using SQL, have co...
Collapse
 
rhymes profile image
rhymes

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!

Collapse
 
helenanders26 profile image
Helen Anderson

Thanks rhymes

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

Collapse
 
luckyarthas profile image
LuckyArthas

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 💝 )

Collapse
 
buinauskas profile image
Evaldas Buinauskas

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 😊

Collapse
 
toddtoddowens profile image
Todd M Owens

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:

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

Excellent compilation

Collapse
 
pubudusj profile image
Pubudu Jayawardana

OMG This is gold 😍

Collapse
 
hottabxp profile image
Sergey • Edited

Thank you! Can this be applied to sqlite3? I am using python3 with sqlite3.

Collapse
 
jamesmh profile image
James Hickey

Fantastic! I'm looking forward to the upcoming query plan and window function posts 👌

Collapse
 
helenanders26 profile image
Helen Anderson

Thanks for your encouragement James :D

Collapse
 
williamxlr profile image
williamxlr

Really nice this post, thank you for sharing it!

Collapse
 
savvinovan profile image
Alexandr Savvinov

thank you, great article.
I can't find article about 'Year'

Collapse
 
maeve70 profile image
LJ

Thank you for this article, it's very helpful!
I especially liked the CTE vs. subqueries section. My brain works better with CTEs.

Collapse
 
helenanders26 profile image
Helen Anderson

Thank you! Glad you found it useful.

Collapse
 
brunotdantas profile image
Bruno Dantas

What a great article, congratz =)

Collapse
 
bhatnagaranshika02 profile image
Anshika Bhatnagar

This was needed.. Thank you ma'am..

Collapse
 
helenanders26 profile image
Helen Anderson

You're very welcome

Collapse
 
manuelbrs profile image
Juan Manuel Bello

Thank you, this article is useful. 👍🏽