Tuesday, 27 August 2024

SQL Commands

 SQL:- full form (structured Query language

Developer:- Donald D. Chamberlin and Raymond F.Boyce at IBM in the year 1974.


Initial Name :- sequel

It is the 4th generation language

It is not programing language/query/Coding based.

Used for managing database in Rdbms.

Not -procedural language ( Not required any step like  others language .c ,c++,

Java etc. 

इसकी सभी कमांड case sensitive नही होती है।


SQL - SQL is a standard language used for storing manipulating and retrieving data from relational database.

SQl Commands 

DDL(data dafining language)
Command DDL:- Create ,Drop,Alter,Rename 

DML(data manipulation language)

Command :- Insert,Update, Delete 

DCL(data control language)

Command:- grand ,revoke 

TCL(transaction control language)

Command:- commit, rollback, savepoint 

DQl (data quary language)

Command:- select 


1 comment:

 How to earn money from computer  Hello दोस्तो में आज आपको कंप्यूटर के बारे में कुछ बातें बताना चाहता हु । और कंप्यूटर के जरिए कोई भी स्किल ...