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.
Welcome back for part 2 of the podcast about databases. In this half, we discuss several of the things we believe that developers should know about databases. From joins to unions, group by’s and indexing, we try to touch on a lot of the items that most developers should at least be familiar with when working with database systems. [Read more…]
Part one of our two part database podcast starts with choosing the RDBMS (Relational Database Management System) and what to do when you run into deficiencies in that particular database system. First and foremost, what’s with the title?! Are these guys grammatically challenged? If that was your first thought, then you should check out this link: http://en.wikipedia.org/wiki/All_your_base_are_belong_to_us Others who have been around a little while (longer than us three 21 year olds), we hope you got a kick out of the title. [Read more…]
I’ve been toying with writing an application that would be a review engine of sorts. This would be useful on my headphone review site www.headphonereviewhq.com and I have ideas of other places I could use this. It would also allow me to do some meaningful coding that I could use for examples on this site so it’s a win-win-win situation. In thinking of this design though, I’ve been trying to come up with a flexible database design that would work without creating massive amounts of overhead to manage. So, let’s get started with my thoughts… [Read more…]