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.

Job interviews are exciting and anxiety-inducing at the very same time: Landing one means you’ve made it past the initial application stage, but it also means preparing for those all-too-familiar ...

Interview questions: Everyone has them. And everyone wishes they had better ones. So I asked smart people from a variety of fields for their favorite interview question, and more important, why it’s ...

A job interview is a two-way street. The employer asks questions to determine if the interviewee is an ideal fit for the job, and the smart candidate uses the interview to assess how she would fit in, ...

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.

You’re in the hot seat. Your palms are sweaty; voice is shaky; face is flushed; and mouth is dry. Maybe you’re bouncing your knees and talking too fast. Perhaps your heart is racing or your stomach is ...