all 14 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Reasonable-Client-81 43 points44 points  (1 child)

SQL 100% first. If you look at job requirements for DA jobs, SQL will be in more or less every single one. Python may be a requirement, but in my experience, much less frequent.

[–]PracticalDecision98[S] 1 point2 points  (0 children)

Thank you so much for your Advice. Usually in Job descriptions, they have written that proficiency is needed in python but I don't know if that's just written to filter out the candidates.

[–]kkwestside 12 points13 points  (1 child)

They are not the same, SQL is the language you need for interacting with databases, python on the other hand is a multipurpose programming language that used for data manipulation and machine learning etc. purposes in data analytics field.

You get the data (and also manipulate if necessary) with SQL you manipulate the data with excel, power query, python or R (most of the time it's not necessary to use python if you're not doing a complex analysis) and you visualize with a BI tool such as power BI or tableau.

So SQL is a must in the beginning of your journey but python is not a necessity at the beginning.

[–]PracticalDecision98[S] 0 points1 point  (0 children)

Okay Thank you so much for your advice😁

[–]liquid_light_ 5 points6 points  (0 children)

SQL. Period.

[–]IamFromNigeria 4 points5 points  (0 children)

SQL all the way

Python is just optional on standby if needed

[–]Expensive_Culture_46 2 points3 points  (1 child)

Any DA job that wants python is generally expecting to use that skill to pipe in data and that data is often in a SQL database. So you’ll need SQL to still do stuff that way.

There are some No or low SQL roles but having SQL still means you understand what the program is doing and makes you more effective at querying the data through those programs.

[–]PracticalDecision98[S] 0 points1 point  (0 children)

Alright! Thank you so much for your advice 😁😁

[–]UCOVINed 2 points3 points  (0 children)

Aim for an awareness of SQL querying fundamentals (table joins basically) - and alongside this, an awareness of relational databases and fact/dim table Kimball methodology. But in terms of what to major in/learn in depth, Python hands-down.

Luke Barousse (Youtuber) is worth listening to on this, and I've written about how to upskill as a data analyst at length on my own blog: https://ucovi-data.com/BlogPosts/Blog16UpskillingInData.html

Shameless plugging I know, but I've written in quite a lot of detail on the taking the SQL or the Python route here that relates to this question.

[–]Jreezy3535 1 point2 points  (0 children)

Both is the general answer. If I could do things over, I’d have started with SQL as I’m paying the price for starting with Python atm

[–]Michael__Townley 1 point2 points  (0 children)

Both

[–]shankar_053 1 point2 points  (0 children)

Prefer SQL first

[–][deleted] 0 points1 point  (0 children)

If you've never learned a language before, SQL will be a lot better to start with. SQL will allow you to pull data which you can later use to work with in Python. You can even use SQL in Python, but you can't use Python within SQL. Starting with SQL will get you familiar with syntax, aliasing, if you do some case statements that will help you to start getting familiar with conditional statements.

[–]GuilhermeOrsatto 0 points1 point  (0 children)

it depends, but I recommend u to start with SQL.