SQL Tutorial for Beginners | Command Types in SQL | SQL Full Course

SQL Tutorial for Beginners | Command Types in SQL | SQL Full Course

Hello friends welcome back to TEK Solutions and Welcome to our sequel tutorials for beginners session I have already shown you how to install the mySQL database and how to use MySQL workbench to execute the queries for your practice if you haven't watched that video and want to install MySQL then please refer our video I have provided the link in the description below also if you don't want to install MySQL for for your practice then it's fine you can use Oracle live which is a cloud version of Oracle you just need to create a account and start using it and start executing your queries for the practice that is mainly designed for SQL practice I have created a video on how to create a Oracle Live account and how to access it please refer the link in the description below now in this video we are going to see the next chapters of SQL for beginners so what is X expected from this video in this video we will see what is SQL and SQL command types so let's start what is SQL structured query language SQL is a structured query language which is used to access the data from the database whatever whatever dbms tool you are using either it's a MySQL Oracle or a SQL Server the data can only be accessed by the SQL query is nothing but a set of commands to access the data and the SQL commands are divided into four different types we will see those different types in our next slide but SQL is the language which is designed to talk to the dbms tool to the database so whenever you want to talk to the database you want to extract the data you want to add the data you want to delete the data you need to know the SQL language that is structured query language so let's go and see what are the different types of SQL commands types of SQL commands there are four types of SQL commands those are divided into four different types number one data definition language it is called as ddl as well what we do in ddl so data definition means a definition of a data so creating a table or altering a table that is changing a table dropping or truncating the table so whenever you want to create a table or you want to alter the table drop the table translate the table we have to use the ddl commands which is data definition language these are the few examples of the ddl commands then next type is data manipulation language which is called as DML as well in a DML we do the manipulation data manipulation statements so for example select where we are selecting the data from the database update so we are updating the existing data or insert we are inserting the new record into the database or delete where we are deleting the existing record from the database so these are the bmls these are the example of DML next we have data control language BCL Grant and revoke where we are going to Grant the access to the users so if you created one user and you want to give a particular access to the users or you want to restrict the user you can grant access using the grant statement or revoke you want to revoke those permissions you have given to the user so these are nothing but a example of data control language and this is DCL finally transaction control language which is TCL it's called as a TCL as well what are all the types what are the examples for that commit and roll back so whichever action you do you need to commit on the database so for example you have updated a record or you inserted the record it is not a permanent until or unless you are running the commit statement and that is the commit and it is a TCL transaction control language same thing with the rollback if you want to roll back the changes you have done in the previous stage you don't want to save the update updated record in that case you can run the rollback that's an example of TCL so friends these are the types of SQL commands so that's it from this particular video friends in the next video we will continue our learning on SQL for beginners if you haven't subscribed to our Channel Please Subscribe and keep supporting us thank you

CHAPTERS
0:00 | Introduction
01:18 | Command Types

SQL Tutorial for Beginners | Command Types in SQL | SQL Full Course