RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

Want to know how to prepare for a job interview? Here’s a step-by-step guide and a number of practical, effective interviewing tips. If you want to improve your job interview skills and get the job ...

Everybody dreams of having a great job. But to land your dream job, you first have to convince the hiring manager that of all the candidates who’ve applied for the position, you fit best for the role.

If you’re the interviewer, there’s a lot you should already know: The candidate’s resume and cover letter should tell you plenty, and LinkedIn and Twitter and Facebook and Google can tell you more.