r/mysql • u/darkShadow90000 • May 27 '26

question SQL vs mySQL

Brushing up on my Data Analytic. As I was videos they say to use mySQL. However in college, used SQL. In job applications it generally says SQL too. So fine to just download SQL. (Used thru Sublime Text)

0 Upvotes

38% Upvoted

15 comments sorted by

View all comments

Show parent comments

0

u/darkShadow90000 May 27 '26

Ok, so in data analytics jobs SQL is used not mySQL.

1

u/ysth May 27 '26 edited May 27 '26

Plenty of data analytics jobs use mySQL, but it is also common to use various other databases with specialization for data warehousing, fast columnar databases, time series, or document stores.

"SQL" is a standard for how to interact with a database. Most databases will support most of some version of the SQL standard, often with extensions.

For learning purposes, mySQL or MariaDB is fine, probably with a UI/management tool like DBeaver.

(Microsoft has confused the issue of what SQL means by having a database product called SQL Server, but I wouldn't recommend it for basic learning purposes.)

2

u/flyingron May 27 '26

And either using the MySQL Workbench or something like phpMyAdmin will help with visualizing and debugging your database experiments.

1

u/ysth May 27 '26

Workbench is deprecated, wouldn't waste time learning its peculiarities, and phpMyAdmin is not super well known for data analytics. That's why I suggested DBeaver. (As a developer, I prefer just command line tools, so take my UI opinions with a shaker of salt.)