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...
For further actions, you may consider blocking this person and/or reporting abuse
Great "SQL vocabulary" you have here. Also, thanks for quoting me!
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!
Thanks rhymes
You had such a perfect explanation I had to include it :)
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 💝 )
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 😊
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:
Excellent compilation
OMG This is gold 😍
Thank you! Can this be applied to sqlite3? I am using python3 with sqlite3.
Fantastic! I'm looking forward to the upcoming query plan and window function posts 👌
Thanks for your encouragement James :D
Really nice this post, thank you for sharing it!
thank you, great article.
I can't find article about 'Year'
Thank you for this article, it's very helpful!
I especially liked the CTE vs. subqueries section. My brain works better with CTEs.
Thank you! Glad you found it useful.
What a great article, congratz =)
This was needed.. Thank you ma'am..
You're very welcome
Thank you, this article is useful. 👍🏽