The Ultimate Guide of SQL Commands

Posted By : Harish Kalra | 31-Jul-2018

SQL Commands :

The accompanying segments talk about the fundamental classifications of commands utilized as a part of SQL to perform different capacities. These capacities incorporate building database objects, manipulating objects, populating database tables with data, refreshing existing data in tables, erasing data, performing database queries, controlling database access, and general database organization.

The principle classes are-

1. DDL (Data Definition Language)

2. DML (Data Manipulation Language)

3. DQL (Data Query Language)

4. DCL (Data Control Language)

5. Data administration commands

6. Transactional control commands


Defining Database Structures: 

Data Definition Language, DDL, is the piece of SQL that enables a database client to make and rebuild database objects, for example, the creation or the deletion of a table. 

The absolute most basic DDL orders talked about amid following hours incorporate the accompanying:

-> CREATE TABLE
-> ALTER TABLE
-> DROP TABLE
-> CREATE INDEX
-> ALTER INDEX
-> DROP INDEX
-> CREATE VIEW
-> DROP VIEW

Manipulating Data : 

Data Manipulation Language, DML, is the piece of SQL used to control data inside objects of a relational database. 

There are three essential DML orders:

-> INSERT
-> UPDATE
-> DELETE

Selecting Data : 


Despite the fact that involved just a single command, Data Query Language (DQL) is the most thought focal point of SQL for present day social database clients. The base command is as per the following: 

SELECT 

This command, joined by numerous alternatives and provisos, is utilized to form inquiries against a social database. Questions, from easy to complex, from ambiguous to particular, can be effortlessly made. 

A query is a request to the database for data. A query is typically issued to the database through an application interface or by means of a command line prompt.


Data Control Language : 

Data control commands in SQL enable you to control access to data inside the database. These DCL commands are regularly used to make objects identified with client get to and furthermore control the circulation of benefits among clients. A few data control commands are as per the following:

-> ALTER PASSWORD
-> GRANT
-> REVOKE
-> CREATE SYNONYM

About Author

Author Image
Harish Kalra

He is active in his work, as well as a quick learner. He has been a good resource to our company.

Request for Proposal

Name is required

Comment is required

Sending message..