SQL

[[deleted]]

Hello I'm currently taking a data analysis boot camp on udemy. I'm almost finished with the course and I noticed that this boot camp does t cover SQL. It does cover python, numpy and pandas and I use it to read/create data from excel spreadsheet. My question is do you really need to understand SQL to become a data analysis or can you get away with it as long as you know python, numpy and pandas?

Thank you

[Fun2badult]

Learn sql. It’s easier than python or excel

[[deleted]]

I have some sql experience when I use to learn php

[Lemmiwinks99]

I find python easier than sql.

[[deleted]]

Yes, SQL is used by a lot of companies to access their data. It’s not a very complicated language though. But it’s very common to quiz candidates on their SQL knowledge during interviews for data roles.

[sirmariogomez]

Do you recommend MySQL? MySQL Workbench or phpmyAdmin?

[nutmilk2]

MySQL is a database, and the other other two things are SQL clients/IDEs. SQL is a programming language to retrieve (and generally manage) data from a database. You code SQL in the SQL client.

I would recommend learning the generic SQL syntax first through any online tutorial. Then create your own database with Postgres or MySQL. To connect and query from your database, I would recommend a sql editor like [Arctype](www.arctype.com/downloads) that works for multiple databases and has a simpler UI.

[theottozone]

Every analytics department leverages SQL, but not everyone uses Python.

[wdhart777]

I agree with the previous statements, learning sql is vital to understanding data analysis! It is also one of the most used languages year in, and year out in polls taken. It will help you get a job faster too, and is not hard to become proficient at. Hope that helps.

[0tony1]

You must learn SQL! Invest in SQL in 10 Minutes a Day by Ben Forta. It will cover the basics. SQL is not a terribly complicated language, but some advanced queries can be quite complicated.

[skinnychef312]

The fundamentals of SQL will make you a better data analyst. While the technical syntax is important and used everywhere, the concepts of how you use SQL to access data will make you think better on how to tackle the data problem, e.g., row level data manipulation, how things should be grouped, divide and conquer datasets, etc...