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!
Source code is the digital product of bazillions of decisions made by any number of people. There aren’t a lot of clear cut answers in the world of software development so many of these decisions end up getting made on the basis of past experiences, future projections, and…hangry-ness.
I’m a software craftsmanship enthusiast. I try to follow best practices and I try to strike the balance between principles and pragmatism. I try to make good decisions, but it’s difficult to keep perspective as the size of the projects and sheer number of decisions grow.
How do you track your progress?
How are you doing, really?
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.
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…]
In some environments, using dependency injection (DI) and inversion of control (IoC) are not only a nice-to-have, but an expected requirement. And while DI and IoC can provide a nice abstraction away from your concrete classes, there are times, when working in a brownfield application for example, that you might find yourself in the position of simply not having the luxury of time to wire in one of these frameworks. However, that does not mean that we can not strive to accomplish what these frameworks aim to provide for us: loose coupling.
So with that in mind, I want to share a method of loosely coupled classes by way of reflection. And in the spirit of three letter acronyms (TLA), I call this pattern reflection of control (RoC).