Alteryx interview question

Explain SQL Joins, DataBase designs (STAR).