Skip to content Skip to sidebar Skip to footer

SQL Definition and Functions - simple blogger tutorial


SQL Definition and Functions - simple blogger tutorial


simplebloggertutorial.com- maybe some of you have studied or are wondering what is SQL

 really fitting we will discuss what is the meaning of SQL functions and basic commands you need to know about SQL what do you want to know


 What is SQL {structured query language} or commonly known as SQL


 Is a programming language that is used to access, modify and manage relational-based data. Until now, there have been many servers in the database and software capable of interpreting the SQL language.


 that's why Escape is very important to learn Then who needs to master SQL there are many jobs that need to have as far as understanding SQL such as data scientist, data engineers, business online database administrators and quality assurance testers, if you work as one of these professions, surely KMU must sharpen  your skills


 then what are the basic commands contained in SQL, there are at least three types of basic commands in SQL, the first is the data definition language or DDL, which is the command used to define data such as creating database tables.  DL is still further divided into at least five types of commands, namely:


 create command to create a new table in a database

 not only for new cables but also for new databases and columns, you can make a query with an example of a database script, the name of the database under score, then there is the Alter command which is commonly used when someone wants to change the structure of a previously existing table, such as table names, adding columns, changing or deleting columns.  and add other attributes Then there is the Line m command you can use to change a name In or column if you use this command then the query becomes Rin intable, the name under score table is the old underscore, the name is under score Beladas victim then drop command you can use in  delete either in the form of a database


 table or column until the last index show private deal this command is used to display a table the second basic command is data manipulation language or abbreviated emailed to the SQL database dml commands are divided into 4 types, namely Insert select update and delete ordered Insert


 you can enter a new record in a database table then there is a select command that you can use. To manipulate data with the aim of displaying or retrieving data in a table there is also an update command that you can use when you want to update data called table


 for example, if there is an error when entering a chord, you do not need to delete it and can be corrected using this command. Finally, there is a delete command that can be used when you want to delete a record that is in a command table.



 Finally, the data control language or abbreviated as dcl band psgl is used specifically to regulate what rights a user has, be it rights to a database or to existing tables or fields through this command, a database admin can maintain the confidentiality of a database, especially important data.  based on the basic command in bad luck, it is divided into two main commands, namely the Grant command, this command is usually used when the database admin wants to give other users access rights, of course, granting these access rights can be limited or regulated by the government. Ribo is the opposite of Grand tribox, sometimes it is often used to revoke or remove someone's rights.  the user initially granted access by the database admin


 through the previous Grand love then what are the SQL functions for an admin SQL database can help access or change the database admin can also run a query or retrieve the required data including updating or inserting data in the database


 SQL can also be used to delete data in the database. Another function SQL is to create a new procedure and this will be stored in a database. In addition, SQL can also set access rights in the procedure table and other important things so it can be concluded that the SQL function is as follows:  a special language used when creating or processing databases on a website.

Post a Comment for "SQL Definition and Functions - simple blogger tutorial"