MedStar Health Interview Question

asked about previous experience. What is an index How do write stored procedures in database to populate a datawarehouse What is left join, right join, inner join