Usage of MySQL - Joins,String/Date functions,aggregation concepts,conditional queries,subqueries,Window functions