If you are interested to learn SQL for data analytics purpose and clear the interviews, just cover the following topics 1)Install MYSQL workbench 2) Select 3) From 4) where 5) group by 6) having 7) limit 8) Joins (Left, right , inner, self, cross) 9) Aggregate function ( Sum, Max, Min , Avg) 9) windows function ( row num, rank, dense rank, lead, lag, Sum () over) 10)Case 11) Like 12) Sub queries 13) CTE 14) Replace CTE with temp tables 15) Methods to optimize Sql queries 16) Solve problems and case studies at Ankit Bansal youtube channel Trick: Just copy each term and paste on youtube and watch any 10 to 15 minute on each topic and practise it while learning , By doing this , you get the basics understanding 17) Now time to go on youtube and search data analysis end to end project using sql 18) Watch them and practise them end to end. 17) learn integration with power bi In this way , you will not only memorize the concepts but also learn how to implement them in your current working and projects and will be able to defend it in your interviews as well. Like for more Hope it helps :)