As a machine learning engineer who mainly deals with vision-based projects, I have little opportunity in my work to actually use SQL (Structured Query Language.). Even when I need it, I often just ask the data engineers for a favor.
However, I thought it would be an essential skill to learn even if I do not need it for now.
It really depends on what kind of data you are dealing with. If you are doing traditional machine learning, for example, recommendation, ranking, the raw data will probably be stored in databases, and you will need SQL for data wrangling.
If you are working on computer vision, audio signal recognition etc., you may not need to know SQL, but it depends.
Ref:
When it comes to the actual SQL databases, there are a lot of SQL databases out there.
All these different databases support some of the common SQL syntax, but they may have their own extended syntax.
If you like open source, PostgreSQL and MySQL is a good choice. According to the DB ranking, Postgres and MySQL are ranked 4th and 2nd in the RDBMS. Postgresql seems to support more standard SQL syntax than mysql, but much of the knowledge is transferable between the two.
Practically, we can learn MySQL or PostgreSQL, but it seems that Postgres have more detailed documentations. I also give some links discussing the differences between different databases below.
ref:
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。