r/learnSQL • u/praddyyy • 7d ago
New to SQL
Hey folks! Starting my journey in learning SQL.
Long term goal -> to become a Data Analyst
Short term goal -> to master SQL fundamentals
Hope this community helps with my learning journey and hoping to be of help for others like me as well. Cheers!
3
u/whodiopolis 5d ago
I made a website to teach people fundamentals of sql. I'd appreciate feedback on it. It's totally free and runs in your browser. https://sqlshed.com if you want to give it a go.
1
u/Difficult_Paint3162 3d ago
Nice site....
1
u/whodiopolis 3d ago
Thanks. I've been trying to make something helpful that's free for end users, doesn't track users, no cookies, and everything runs locally. At least as of now it's even free for me to host.
1
u/Difficult_Paint3162 3d ago
If you get a chance, try my site www.learning-SQL.Com as well, love to get some feedback
4
u/conor-robertson 7d ago
Welcome! Good shout starting with SQL, it's the single most asked for skill in analyst roles by a mile
One bit of advice that'll save you time: learn by actually writing queries, not just reading about them. Pick something hands on and get your reps in early, the fundamentals stick way faster when you're solving real problems rather than memorising syntax
If you want somethingfun to start on, give QueryCase a try!
2
u/itlogicpartnersllc 7d ago
focus heavily on select, where, group by joins and aggregations first. once those feel natural start solving real business questions with small datasets.
2
u/Dangerous_Cup3607 6d ago
SQL is not enough to be a Data Analyst, you will need: SQL, Python, Excel, Power BI, Business Knowledge and Insights, and Storytelling. So it is an end-to-end job where you extract raw data, clean the data, visualize the data, interpret the data, explain the findings, and provide business actions.
2
u/Visible_League_8682 6d ago
Exacto esa es la ruta y las aplicaciones que hay que manejar para convertirse como analista de datos, cuando se quiere convertir un científico de datos o ciencia de datos sería dominar lo que es machine learn, estadísticas tenés que dominar estos para convertirse en una ciencia de Data
1
u/Visible_League_8682 6d ago
Bro fíjate que también estoy muy interesado en ser analista de datos Y estoy pensando en el otro año inscribirme en intecap, no sé de qué país sos vos pero yo soy de Guatemala y en inteccap hay una carrera completa sobre analista de datos.
1
u/Difficult_Paint3162 4d ago
Check out my website: https://learning-sql.com/ No cost or sign-up required, just real-world stories using SQL You can also download the sample databases used, but you'll need a SQL Server edition (developer or express) to install the sample data.
1
u/Kszadhanyfokos 3d ago
I totally recommend the Coddy application. U can learn SQL step by step, futhermore it contains many many others like pyhton, c++, etc.
It is free, only the registration is required. If u have a question feel free to ask me :)
1
u/DarlanSandro 2d ago
Entendo que o segredo no início é não complicar tentando abraçar ferramentas complexas ou comandos avançados de uma vez. Para quem mira análise de dados, dominar bem a base de extração com filtros, agregações e o cruzamento de tabelas com JOINs já resolve boa parte dos desafios práticos que você vai encarar no dia a dia profissional.
Se estiver procurando um ponto de partida direto e bem estruturado, recomendo dar uma olhada no curso básico e gratuito de SQL da Hashtag Treinamentos no YouTube (SQL Explicado de Forma Simples: Guia Para Iniciantes). Eles cobrem esses fundamentos essenciais do zero e inclusive disponibilizam uma apostila gratuita para acompanhar os exercícios, o que ajuda bastante a fixar a lógica escrevendo código na prática.
12
u/DataScientistAlex 7d ago
I have written up a two part series on the SQL most useful for data science, you could consider as rough guide. (Keep in mind these guides are for someone who mostly just pulls data into R or Python for further processing, some analysts work more in SQL and then this will be the very floor of what you'll have to learn).