I figured this title was appropriate considering it’s been a month since our last episode. We’ve all been incredibly busy so we hope you’ve been patient waiting and maybe, just maybe it was worth the wait! We’ve crammed quite a bit into this episode which is all about testing. Follow the more link to see the show notes for this particular episode and don’t forget to click one of the share buttons there to let all your friends know about the podcast! [Read more…]
In this episode, we have a discussion about what type of technology stack you should choose when you go to create your own project whether it be for profit or an open source type of deal. As programmers, we often struggle with balancing our ADHD tendencies to code in every language known to man, or actually trying to accomplish something and create a finished product! With that in mind, check out the show notes for Episode 17 to go see all the things we mentioned in the show. [Read more…]
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…]