SQL Server VS SQL ?

Question

we learned SQL for our database management systems class but when i go through the jobs most of them need SQL server

how different or how similar they are and should I start learning sql server as well

do you have any other recommendation in this field

that was oracle SQL

Answer 1

What did you learn on? MySQL? Oracle? Sybase? MS SQL? Access?

SQL is a GENERIC term for a Structured Query Language database system. In general they are all similar, though there are some differences. For example,

SELECT * FROM MyTable WHERE SomeNumericField = 1

will work in all SQL systems.

But,

SELECT TOP 5 * FROM MyTable
will not work in MySQL but will work in Microsoft SQL (MSSQL)

In MySQL, the above command would look like this:
SELECT * FROM MyTable LIMIT 5


In short - if you know one version well, adapting to another shouldn't be too difficult.

Answer 2

SQL is the language of databases. There are several different versions of the SQL Language, (T-SQL, PL-SQL, ANSI-92 to name a few).
ANSI is the "core" of the language, if you will, and then the others build upon the base. T-SQL for SQL Server and PL-SQL for Oracle are probably the most common however there are many others.
SQL Server is the database from Microsoft.

That said, what you have learned is the language of how to insert, update, delete and query information contained in a database. Believe me when I say this, it is a very powerful language and takes significant time to master. You certainly will not grasp it all in a single class.
As for learning SQL Server. That is your option and really depends on what you are trying to get out of it. If you are a developer, it certainly doesn't hurt to know something about the db server however basic SQL skills will certainly get you where you want to go.
If you wish to become a Database Administrator, then you will first need to decide if you wish to be a "development dba" or a "production dba". Development dba's must have a very strong understanding of the SQL language whereas a production dba doesn't need to have the same level of skill. Their job is primarily to make sure the database continues to run, troubleshoot it when it doesn't and most importantly, make sure the data is backed-up regularly and can be restored in the event of a disaster.

Answer 3

SQL server is a software that runs on a server computer to hold massive amount of data. It is a database.

SQL is the language you use to talk to the system I just described.

By the way, there are many database programs. SQL server is a Microsoft product. Oracle also makes Oracle server.

They both use SQL (which is actually a standarized language). Oracle server also has an advanced version of SQL called PL/SQL.

My recommendation to you is this: keep expanding your horizon and venture into other parts of the IT technology. You seem to lack some very basic understanding. You have time to learn this if you are still in school. Keep on going.