Joins is always a good topic, it took me awhile to really get a good understanding of those. Thanks for the refresher!
Thanks for the suggestion!
Thanks for another helpful post. Indexing would be a great topic to cover in the future!
The best topic would be: how to create a relational database from scratch, say an RDBMS about a school having students, teachers, classes, courses etc.
I would give 10 thumbs up for such a post! (I'll borrow the 8 other thumbs from other people!)
Love joins. So much they're getting their own post really soon. In the meantime, this is my favourite resource for all things joins - techonthenet.com/sql/joins.php
Joins, inner, outer, etc. Also subqueries are a fun topic.
Subqueries are fun! I couldn't get my head around how to make them work until I stumbled on this video - youtube.com/watch?v=uAWWhEA57bE (@ 3:30)
They can be fun, but also a mental twister the first time seeing them.
Joins are done!
and CTEs rather than subqueries :)
thanks for this☺
I find it refreshing that you wrote the SQL code downcase. I always felt afraid of SQL and seeing it downcase makes it more pleasant. Thanks.
One record in relational database is a basic relation.
Yeaaaah SQL! This is my jam! Thanks for this post. I may use relational databases every day, but I do struggle to understand the definition and explain it to people.
Love the enthusiasm! I'm drafting posts about indexes, joins, subqueries and CTEs (all with a T-SQL flavour) and my observations when dabbling in Postgres. Stay tuned :)
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.