+ 1

Differentiate between SQL, MySQL & Oracle ?

Please describe it...

12th Dec 2019, 8:20 AM
Farhan Ellahi
Farhan Ellahi - avatar
7 odpowiedzi
+ 4
MySql belongs to RDBMS(Relation DataBase Management System) - Where each table will relate to each othet eg. Employee table will have a unique id from which we can get his personal details. Oracle is Also falls under RDBMS category. SQL- Structured Query Language -NoSQL(not only SQL) is the one which doesnt have tables instead it has collections(similar to JavaScript Objects).
13th Dec 2019, 9:59 PM
Vignesh Rathnam
Vignesh Rathnam - avatar
+ 3
Since you mentioned "language". You should have asked for difference between SQL (in general) T-SQL (Microsoft SQL) PL/SQL (Oracle SQL) I know little of the difference. Each DBMS vendor have added and developed features in their product, what is available in one DBMS may not be in another (or is available with different way/syntax). The basic commands are the same in most DBMS however.
12th Dec 2019, 9:28 AM
Ipang
+ 2
Firstly, can you clarify whether you meant SQL or SQL Server, Oracle or Oracle database. I ask this because I had seen a lot of people mix the terms, while they mean different things. SQL is a language developed for data definition and manipulation. SQL Server is a DBMS product built, owned and mostly used on Microsoft products. MySQL is a DBMS product that was developed by MySQL. Oracle corporation now owns the brand and product through acquisition. Oracle is a software corporation. More about it, if it interests you, are available on the net, you can easily search for it. Oracle database is a DBMS product developed by Oracle, whose core functionality equals SQL Server and MySQL. These are database server softwares, with features each unique to their own.
12th Dec 2019, 9:12 AM
Ipang
+ 2
Difference between SQL, mysql, Oracle languages
12th Dec 2019, 9:16 AM
Farhan Ellahi
Farhan Ellahi - avatar
+ 2
I am sorry but just started to get into SQL, and everything related is most commonly in english I dont know it well. So what you all mean with DBMS? And if you know of example tables easy to use, and practice to manage data, to download, please share it. Cheers
13th Dec 2019, 7:04 PM
Sklau
Sklau - avatar
+ 2
Sklau Here's an intro to DBMS https://beginnersbook.com/2015/04/dbms-introduction/ I don't understand what you mean in the second paragraph. But perhaps somebody can help on that parts.
13th Dec 2019, 11:30 PM
Ipang
+ 1
I'll post a sql quries after a week if you wnat these quries you can follow me for notification...
13th Dec 2019, 7:36 PM
Farhan Ellahi
Farhan Ellahi - avatar