07.Types of SQL Languages/Types of SQL commands/Types of SQL statements|DDL,DML,DQL,DCL,TCL,DQL
Download Complete SQL Training Materials: https://imojo.in/sqlpandeyguruji
------------------------------------------------------------------------------------------------------------------------------------------
Are you someone who is looking for Real-time training, visit https://pandeyguruji.graphy.com/ and join for free training materials, Link: https://bit.ly/30vrk1W
For any query Contact me on social media:
Facebook : / mpandeyguruji
Instagram: / pandey_guruji
Linkedin: / mukesh-pandey-1a151634
-------------------------------------------------------------------------------------------------------------------
SQL Tutorial for Beginners in Hindi: https://bit.ly/3CwfnGB
SQL Tutorial for Beginners in English: https://bit.ly/3qVI3GQ
SQL Live Training: https://bit.ly/3kXqOl1
Crack SQL Interview: https://bit.ly/3caxIyb
SQL Interview Questions: http://bit.ly/2CR6wCZ
Advance SQL Interview Questions: https://bit.ly/3HnMrnN
Career Guidance: https://bit.ly/3FffkRf
IT Technology News & Updates: https://bit.ly/3FeNQvc
--------------------------------------------------------------------------------------------------------------------
In this video discussed in details Types of SQL Languages/Types of SQL commands/Types of SQL.
Data Definition Language (DDL): The commands of SQL that are used to create database objects, alter the structure of the database objects and delete database objects from database are collectively called as DDL. Examples include Create, Alter , Drop, Truncate, Rename and Comment Command. Note: This impact the object Structure.
Data Manipulation Language (DML): The commands of SQL that are used to insert data into the database, modify the data of the database and to delete data from the database are collectively called as DML. Examples include Insert, Update and Delete.Note: This impact the Data structure.
Data Query Language (DQL): The commands of SQL that are used to retrieve data from the database are collectively called as DQL. So all Select statements comes under DQL.* Select: To retrieve data from the database table.
Select
Where clause
Order by Clause
Distinct Keyword
Isnull() function
Column aliases
Between … And
In
Like
Is Null
Data Control Language (DCL):The commands of SQL that are used to control the access to data stored in the database are collectively called as DCL and examples include Grant and Revoke.
GrantAll users access previleges to database.RevokeWithdraw users access previleges given by using the Grant command.
Transaction Control Language (TCL): The commands of SQL that are used to control the transactions made against the database are collectively called as TCL and examples include Commit & Rollback.CommitCommit is used for the permanent changes. When we use Commit in any query then the change made by that query will be permanent and visible. We can't Rollback after the Commit.RollbackRollback is used to undo the changes made by any command but only before a commit is done. We can't Rollback data which has been committed in the database with the help of the commit keyword.
#Realtime_Personal_Training_Call_Now_8309569513
