sql queries on window functions, adf activities, triggers and IR, pyspark, dataframes, window functions, delta tables, optimization techniques, adls, project description, sql indexing, data warehouse concepts, cache, broadcast, delta tables optimization