SQL Overview

Structured Query Language (SQL)

SQL stands for Structured Query Language; SQL interacts with the database on the server-side.

SQL is a standard language for accessing and manipulating databases; it includes database creation, deletion, updating, 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 Server Commands

SQL commands can be classified into the following types:

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

SQL Commands Description

Command_Types Command_Descriptions
DDL Allows working 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 retrieve the data. SQL Commands: SELECT
DCL Controls the data. SQL Commands: GRANT, REVOKE, DENY
TCL Deals with transaction management. SQL Commands: COMMIT, ROLLEBACK, SAVE

Policy

GDATAMART.COM is optimized for learning & job information; The users try to improve your knowledge and practical experience through this site but we cannot warrant full correctness of all content... Learn More → | Sitemap →

© 2020 GDATAMART | All Rights Reserved