ML Engineer @PayPal | SDE @Microsoft | 21k+ @Linkedin | Mentor @Scaler | Instructor @GrowthSchool | SDE, AI, ML, Tech, Data Content | Top 1% @TopMate | DM for Collaborations
𝐒𝐐𝐋 𝐌𝐚𝐬𝐭𝐞𝐫𝐲 : 𝐀 𝐂𝐨𝐦𝐩𝐫𝐞𝐡𝐞𝐧𝐬𝐢𝐯𝐞 𝐆𝐮𝐢𝐝𝐞 𝐟𝐫𝐨𝐦 𝐍𝐨𝐯𝐢𝐜𝐞 𝐭𝐨 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝟏. 𝐒𝐐𝐋 𝐁𝐚𝐬𝐢𝐜𝐬 First, you will start by learning the SQL basics commands which include SELECT, WHERE, JOINS, Aggregate Functions (Count, Sum, AVG, etc.), and table commands such as (create, delete, insert, etc.) There are many resources to learn these basics but I recommend SQL Bolt. 𝐋𝐢𝐧𝐤: https://sqlbolt.com/ 𝟐. 𝐈𝐧𝐭𝐞𝐫𝐦𝐞𝐝𝐢𝐚𝐭𝐞 & 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐒𝐐𝐋 Now it is time to learn more advanced SQL concepts such as Subqueries, Window functions, SQL for data wrangling, and more. A great place to learn these concepts is Mode SQL. 𝐋𝐢𝐧𝐤: https://lnkd.in/dUVyGKwV 𝟑. 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐟𝐨𝐫 𝐃𝐚𝐭𝐚 𝐒𝐜𝐢𝐞𝐧𝐜𝐞 After studying SQL commands and statements it will be important to have a basic understanding of databases and their main characteristics and concepts. My recommendation is the Stanford Databases: Relational Databases and SQL Course. 𝐋𝐢𝐧𝐤: https://lnkd.in/dsq_4Cac 𝟒. 𝐒𝐐𝐋 𝐂𝐚𝐬𝐞 𝐒𝐭𝐮𝐝𝐢𝐞𝐬 Now you are ready for practicing. I would recommend starting with practicing real case studies. A great place to do so is the 8-week SQL challenge by Danny Ma. 𝐋𝐢𝐧𝐤: https://lnkd.in/d22aWUmw 𝟓. 𝐒𝐐𝐋 𝐏𝐫𝐚𝐜𝐭𝐢𝐜𝐞 Finally, you can start to solve SQL questions that you will expect to meet in a data science interview and also in practice. There are a lot of resources to do so. Here are a few good options: ✅ 𝐋𝐞𝐞𝐭𝐜𝐨𝐝𝐞: https://lnkd.in/dEEhGu6F ✅ 𝐒𝐭𝐫𝐚𝐭𝐚𝐬𝐜𝐫𝐚𝐭𝐜𝐡: https://lnkd.in/dMdzZVwD ✅ 𝐃𝐚𝐭𝐚𝐋𝐞𝐦𝐮𝐫: https://datalemur.com/ 𝟔. 𝐁𝐞𝐜𝐨𝐦𝐞 𝐒𝐐𝐋 𝐄𝐱𝐩𝐞𝐫𝐭 If you would like to build more knowledge you can start studying from more advanced resources. I recommend three books: ✅ 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐒𝐲𝐬𝐭𝐞𝐦𝐬: The Complete Book https://lnkd.in/dYSF2qvc ✅ 𝐒𝐐𝐋 𝐂𝐨𝐨𝐤𝐛𝐨𝐨𝐤: Query Solutions and Techniques for Database Developers https://lnkd.in/dZ8Se4Rj ✅ 𝐇𝐢𝐠𝐡-𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐌𝐲𝐒𝐐𝐋: Optimization, Backups, and Replication https://lnkd.in/dDFbqSHB #sql #fresher #novice #advanced #beginner #expert #linkedin #datascience #dataanalyst #dataengineer #softwareengineer #jobs
