SQL Overview

Structured Query Language (SQL):

SQL stands for Structured Query Language; SQL interacts with the database on the server-side. It is a standard language for accessing and manipulating databases; it includes database creation, deletion, updation, fetching rows, modifying rows, tables, stored procedures (SP’s), execute queries, retrieve, insert data against a database. SQL is an American National Standard Institute (ANSI) standard.

Client and Server side Database

Relational Database System

  • SQL keywords are not case sensitive.
  • MS SQL Server using T-SQL
  • Oracle using PL/SQL
  • MS Access version of SQL is called JET SQL etc.

SQL commands to interact with relational databases system are presented like - CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. SQL commands can be classified into the following types:

SQL commands

  • DDL – Data Definition Language
  • DML – Data Manipulation Language
  • DQL – Data Query Language
  • DCL – Data Control Language
  • TCL – Transaction Control Language

Check out the SQL Interview Questions - SQL Interview Questions
Interview Questions - C Programming Interview Questions

SQL Commands Description

Type Description & Commands
DDL Allows to work with the Structure or Definition of the data. SQL commands: CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME
DML To deal with the data itself directly. And SQL Commands: INSERT, UPDATE, DELETE
DQL Deals with the data but to retrive the data. SQL Commands: SELECT
DCL Controls the data. SQL Commands: GRANT, REVOKE, DENY
TCL Deals with the transaction management. SQL Commands: COMMIT, ROLEBACK, SAVE

Email Us: advertise@gdatamart.com

Donate Us: Support to GDATAMART

© 2023 GDATAMART.COM (All Rights Reserved)