SQL doubts with other languages

Question

I've just finished the SQL fundamental course. Where can I head over to learn the intermediate and advanced SQL lessons so that I can build my own portfolio of databases? Also, is another language required in order to get a job as a DBA or data analyst? Like PHP or Python?

Answer 1

I would look at www.w3schools.com, and Google other advanced SQL tutorials. For the data analyst bit, I’m not sure, but I think that Kuba Siekierzyński (who is a data scientist) will be able to help.

Answer 2

For relational database handling SQL is enough in most setups. It is good to learn the syntax and subquerying good in order to be able to draw data as you need. Also, each SQL variant of SQL has its own features and functions which might not be transferrable between them, so it's good to study deeply your SQL of choice.

Python or R really helps when dealing with statistical analysis of your data, as you can do a lot more transformations easier than with SQL. Plus, thanks to multiple libraries accesible to both languages, you can apply some algorithms for detecting patterns and/or anomalies, visualize your data and much more.

But it all depends on what your task as a data analyst is :)