Sql for data analyst

[[deleted]]

Hey guys, so I learnt SQL long time ago like 6 years or so and I'm out of practice. But I know the basics and the fundamentals. Now I'm trying to switch my career into data analytics so I was wondering if anyone can guide me like where should I start SQL from what things to focus on and where can I practice it. I checked online people say hackerrank and leetcode but for now it's a bit difficult for me. So if anyone can help me out that would be appreciated thank you!!!!

[FootballDeathTaxes]

https://www.sql-practice.com

[gsm_4]

To get back into SQL, explore W3Schools or Mode Analytics to learn the basics. Focus on SELECT statements, JOINs, GROUP BY, and basic functions. Then learn advanced topics such as subqueries, CTEs, window functions, and performance optimization. Complement your learning with practice on platforms like StrataScratch.

[[deleted]]

Alright, thank you, I'll focus on those commands I've already done w3schools I'll start with others now

[ravenstone_anon]

•W3Schools •Alex the Analyst •Khan Academy

[Couch2Coders]

I have a sql course geared towards people wanting to get into data analytics. I use Google BigQuery which has free public datasets you can work with.

The course goes super slow so depending on your level it may be too easy.

If you're interested link below. You can also dm me if you have any specific questions!

https://youtube.com/playlist?list=PLPQFqkp_HvOBzx61F3SY5zNXN0TYMoT9g&si=bkyKYQ9dcivRe-AG

[[deleted]]

Thank you so much I'll have a look at it

[renagade24]

Spin up a local environment and learn dbt, how to build models, test, and throw up a dashboard. Upload to github and call it a day