We’re talking databases, indexes, search engines, and why they’re basically microwaves in this episode while Joe wears a polo, Allen’s quick brown fox jumps over whatever, and Michael gives out fake URLs.
It’s that time again.
This week we answer a question, Allen registers for school, Joe reads some numbers, Michael breaks out the survey results, and Joe cringes at the thought of bidets. It’s time for episode 29! And we thought, what better to talk about than to continue our discussion on hierarchical data solutions.
So, how DO you persist hierarchical Data? We discuss two common solutions to this age-old problem: Adjacency Lists and Nested Set Models. Also, Build Atlanta, technical problems, multi-monitor vs ultra-wide, and utilizing gaming mice to up your game.
Picking up where we left off with part one of the video on SQL Joins, we need to continue on with another example of a RIGHT OUTER JOIN, and then follow up with a FULL OUTER JOIN and when you’d want to use something like that. And lastly, we wrap up with the CROSS JOIN and how that may come in handy. This is a fairly short video but it demonstrates each type of join mentioned above and why you’d want to use them. As always, if you have any questions or comments, definitely click into the article (if you’re not already there) and leave your thoughts there.
Also, don’t forget to check out the podcast on iTunes or Stitcher, or any number of your favorite podcast platforms which you can find on our About Us page. Please also use the share buttons below to share this on your favorite social media platform if you found this helpful!
If you listened to Episode 14, Databases the SQL and you thought it was great information but it was hard to picture some of what was being discussed, then you should check out our video for SQL Joins Part 1. In this particular video tutorial, we explain the basics of an inner join, a left outer join, and a right outer join. And with this, you’ll be able to see what exactly happens when you execute the code. This is a great primer for anyone getting started with database programming as these are the building blocks to fundamental querying.
If you liked this content and would like to see more like it, please leave us a comment below and let us know your thoughts. Also, don’t forget to check out the podcast on iTunes or Stitcher, or any number of your favorite podcast platforms which you can find on our About Us page.
Also, if you’d like to receive programming advice, tips and tricks, please subscribe to our newsletter.