Users can provide particular grant access to some particular users using the SQL.Users can delete or alter the properties of the table.Users can create some tables in some database.Some of the operations that can be performed with the help of SQL are: Some of the Relational Database Management Systems like Oracle, MS Access, MySQL, etc uses SQL for all the operations on the database.
Non-Structured databases can't be managed by SQL. all the database related operations are performed using this Structured Query Language.Īs the name suggests, SQL is used to manage the structured databases like RDBMS. SQL or Structured Query Language is simply a computer language that is used to establish a communication between the user and the database i.e. Similarly, SQL is used to have communication between the user and the database. So, in order to have communication between you and that guy, you need some kind of interpreter in between that will convert English to french and vice-versa. For example, if you know English and you want to communicate with someone that knows French only.
The question that arises here is that how data is being stored in the database? You might be using some programming language like Java or Kotlin to develop your application, but in order to store the data in the database, you need some kind of interface or language that will help in the communication between the user and the database. In order to handle a large volume of data we use some Database Management System and this Database Management System, the most popular DBMS is the Relational Database Management System that stores the data in the form of tables containing rows and columns.
0 kommentar(er)
