This ain’t your Jessie J, Ariana Grande, Nicki Minaj JavaScript. No, it may not have the body of an hourglass, but it might have a little something in common with it! Want to find out what in the world this nonsensical talk is about and actually earn some knowledge about !! in JavaScript, then follow the link to get your learn on.
Got Any Hot Stacks?!
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | TuneIn | RSS
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…]
Right Outer Join, Full Outer Join, Cross Join
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!
SQL Joins Explained – Inner Join, Left Outer Join and Right Outer Join
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.
Databases the SQL [see-kwuhl]
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | TuneIn | RSS
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…]
All Your Database Are Belong to Us
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | TuneIn | RSS
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…]
Database Schema for Multiple Types of Products
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…]
LINQ Lazy Loading
Probably the coolest (and most frustrating) thing about LINQ is the fact that it supports lazy loading in certain situations, like Linq2Sql and in Entity framework. We discussed this in our Podcast regarding Linq. So let’s explore what we mean here… [Read more…]
Picking the Right Javascript Library for your Project
Since the advent of “Web 2.0”, Javascript libraries have grown like wildfire. Often, it’s not entirely evident as to why you should pick one over the other. Are you creating a custom design and want a highly stylized and bespoke interface, or are you going for functionality that’s plug and play? Answering these questions are key in deciding what exactly which framework you want to go with. Inside this article I’m going to focus on some of the leading Javascript libraries (at least for right now) and give some insights as to what you should pick for your project. [Read more…]
Steps to Understanding Boxing and Unboxing
I could start by telling you that wrapping a value type in an Object is boxing. There, we’re done right? I mean, you now know what that means, yeah?! So, you could probably then deduce that unboxing would be taking that variable back out of the object?! SIMPLE! Cool…so then…why do we care? Good question. Let’s see if we can go ahead and answer that! [Read more…]
