filmov
tv
Should I Learn SQL Server or MySQL?
Показать описание
Should I learn SQL Server or MySQL?
Microsoft's SQL Server has a big market share because it was shipped with MS servers, and it had a good graphical user interface compared to other databases.
That's like saying I should learn Microsoft Office because it is on 90% of all computers. Well, 80% today.
In the 1990s, SQL Server was one of the best database servers around.
Just because it was big in the pre-internet era doesn't mean I should learn it today, except in history class.
MySQL is better at handling multiple instances of a database kept on the same machine. MySQL runs on far more platforms, such as Solaris, MacOS and SCO.
Where did SCO go? I never hear about it anymore.
It's like LISP - only whispered and practiced by a small but dedicated core of devotees. MySQL came out with a pluggable storage engine architecture back in 2008, beating out Windows then and in some areas today.
They are both high availability. Both have stored procedures, triggers and distributed processing.
MySQL is free, so there are literally millions of instances of it to be supported.
And millions of Microsoft SQL Server installations, all of them at companies that can afford Microsoft SQL Server. That implies they can pay an admin well, too.
MySQL can run on a Windows machine, Microsoft just doesn't advertise it.
icrosoft has built in the functionality to their database.
For what you pay for it, it shouldn't need an admin. Conversely, if you have REDCap or another non-Microsoft server package, you already have MySQL because it is built into the tool.
Which one is easier to support?
Both systems have replication schemes, but MySQL's replication is limited. SQL Server has a lot more reports, but MySQL has minimal reports.
So you get what you pay for.
You don't have to pay for MySQL.
I'll learn the Microsoft SQL Server, since there are more decent paying jobs in it.
And you can learn MySQL on your own time, since you can get a practice version for free.
Only if it is literally worth my while.
Microsoft's SQL Server has a big market share because it was shipped with MS servers, and it had a good graphical user interface compared to other databases.
That's like saying I should learn Microsoft Office because it is on 90% of all computers. Well, 80% today.
In the 1990s, SQL Server was one of the best database servers around.
Just because it was big in the pre-internet era doesn't mean I should learn it today, except in history class.
MySQL is better at handling multiple instances of a database kept on the same machine. MySQL runs on far more platforms, such as Solaris, MacOS and SCO.
Where did SCO go? I never hear about it anymore.
It's like LISP - only whispered and practiced by a small but dedicated core of devotees. MySQL came out with a pluggable storage engine architecture back in 2008, beating out Windows then and in some areas today.
They are both high availability. Both have stored procedures, triggers and distributed processing.
MySQL is free, so there are literally millions of instances of it to be supported.
And millions of Microsoft SQL Server installations, all of them at companies that can afford Microsoft SQL Server. That implies they can pay an admin well, too.
MySQL can run on a Windows machine, Microsoft just doesn't advertise it.
icrosoft has built in the functionality to their database.
For what you pay for it, it shouldn't need an admin. Conversely, if you have REDCap or another non-Microsoft server package, you already have MySQL because it is built into the tool.
Which one is easier to support?
Both systems have replication schemes, but MySQL's replication is limited. SQL Server has a lot more reports, but MySQL has minimal reports.
So you get what you pay for.
You don't have to pay for MySQL.
I'll learn the Microsoft SQL Server, since there are more decent paying jobs in it.
And you can learn MySQL on your own time, since you can get a practice version for free.
Only if it is literally worth my while.
0:24:25
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
0:02:23
SQL Explained in 100 Seconds
0:07:02
Should you learn SQL?
0:04:26
What is SQL? [in 4 minutes for beginners]
0:05:46
Complete Roadmap To Learn SQL Properly
0:02:33
Should I Learn SQL Server or MySQL?
0:05:49
SQL Job Options | Career Paths After Learning SQL
0:27:20
How to learn SQL for free | Roadmap to learning SQL
0:23:41
SQL Tutorial for Beginners
0:16:05
MySQL vs Postgresql vs Microsoft SQL Server Management Tools | Which Option is Best?
0:00:43
BEST Websites to Learn SQL FAST 🏃🏽♂️💨
0:02:16
Should I Learn SQL or Access?
0:05:25
STOP Learning These Programming Languages (for Beginners)
0:00:46
You Have to Learn SQL in 2023! Here's Why #shorts
0:15:30
How I use SQL as a Data Analyst
0:04:10
I learned SQL for data analytics in 15 days | From Scratch
0:02:17
Should I Learn Oracle or SQL Server?
0:07:40
Should you learn SQL in 2016-17
0:12:30
How I Would Learn to be a Data Analyst
0:02:05
Should I Learn VBA or SQL?
0:06:12
What is SQL? Future Career Scope & Resources
0:44:57
SQL Tutorial for Beginners
0:05:57
Secret To Optimizing SQL Queries - Understand The SQL Execution Order
0:05:30
MySQL vs MongoDB
Комментарии