Top SQL Commands you should know about
Its all Here >>>
Why do we use SQL?
1. Give access to data in RDBMS.
2. Allows data manipulation in database.
3. Allows to create/delete tables and databases with SQL statements.
4. Builds views, stored procedures, and functions in database.
Types of SQL Commands
Used to design the database structure, like creating, modifying, and deleting it. Commands are auto-committed, so all changes are stored permanently.
Data Definition Language(DDL) commands
It is used to manipulate data in a database. DML command is not auto-committed, so all modifications cannot be preserved.
Data Manipulation Language (DML)
It is used to retrieve and edit data held in databases.
Data Control Language(DCL)
It is used to manage transactions in database. Also, handles DML statements modifications.
Transaction Control Language(TCL)
It is used to query data contained in schema objects. It allows you to get data from a database and arrange it in order.
Data Query Language(DQL)
Find out how to use these SQL commands with syntax and examples…