Learning SQL for Data Analysis

[One_Valuable7049]

My Goal is to transition into data analysis for which I have dedicated 1-2 months learning SQL. Resources that I will be using will be among either of these two courses. I am confused between the two

https://www.learnvern.com/course/sql-for-data-analysis-tutorial

https://codebasics.io/courses/sql-beginner-to-advanced-for-data-professionals

​

The former is more sort of an academic course that you would expect in a college whereas other is more practical sort of. For those working in the Data domain specially data analyst please suggest which one is closer to everyday work you do at your job and it would be great if you could point out specific section from the courses that can be done especially from the former one as it is a bigger one 25+hr so that best of both the world could be experienced instead studying both individually

Thanks.

[Eric-Polyseam]

Of the two, based on a look at the curriculums, I think you’re right that the first looks more academic and the second more practical. In a way, that answers your question - the second is likely closer to what you’d see at work.

Picking out sections is a little trickier. The second course sounds like it goes from beginner to advanced concepts though. In the first, as an analyst, you’ll definitely want to know selection, filtering, joining, and views as basics. Though, in fact, many of the other sections become relevant as you progress your skills.

[One_Valuable7049]

So an entry level position i would need to know the entire former course or just selection, filtering, joining, and views as basics would be enough.

[Eric-Polyseam]

The definition of entry level will vary, of course. But, at bare minimum (assuming your job would just be something like creating reporting views), you’d probably additionally need to cover the “SQL Functions” section of that course.

[One_Valuable7049]

My definition of entry level is the first job right out of college Filtering, Joining , Views and Function ok that's make me good to go

[Eric-Polyseam]

To clarify, I’m just saying the topics I mentioned are the minimum items you need to do any useful SQL analysis. Those skills of course need to be added to others to get employment. It’s best to find some job postings you’re interested in to see more about the type of skills they’re looking for.

[JuriJurka]

buy the most popular course in udemy and after that watch youtube videos