Structured Query Language(SQL)

Introduction

Full from of SQL – Structured Query Language.

Writing in a structured format is called Structured.

Writing queries in a structured format is called Structured Query.

Structured Query Language – Language with query in a structured format.

What is SQL ?

It is used to access and to manipulate database.

  • It’s used to retrieve the data from the data base.
  • It can insert, delete, update the records in the data base.

DATA BASE

Basic Statements Of SQL

  • DDL (Data definition language)
  • DML (Data manipulation language)
  • DCL (Data control language)
  • DRL (Data retrieval language)
  • What is Data definition language (DDL) ?

DDL will create, Alter and drop the data.

Example table statement for Create:

Create Table _ Student table

Id Name

create table student _Table

CTd int, Name varchar (100)

Example table statement for Alter:

Alter Table

Id Name Age

Alter table student _ Table

add column age int

Example table statement for drop:

Drop Table

Id Name Age

drop table student_Table

What is Data manipulation language (DML) ?

List of statements in DML

  • Insert statement
  • Update statement
  • delete statement

Example table statement for Insert query:

Id Name Age

1 Hema 20

Insert into student_Table

(Id, Name, Age )

Values (1, ‘Hema’ , 20)

Example table statement for Updated Query:

Id Name Age

1 Hema 20

2 Thiya 21

Update student _ Table

set age = 20 where id = 1

Example table statement for Delete Query:

Id Name Age

1 Hema 20

2 Thiya 21

delete student _ Table

where id = 2

What is Data control language (DCL) ?

Data granting the statement and revoke the statement is called DCL.

Example table statement for Grant Query:

Grand Query

Id Name Age

1 Hema 20

Grant insert on student _ Table to hema

Example statement for Revoke Query

Revoke Query

Id Name Age

1 Hema 20

Revoke Insert on student _ Table to hema

What is Data retrieval language (DRL) ?

Example statement for Select Query:

Id Name Age

1 Hema 20

select * from

Student _ Table

We will be happy to hear your thoughts

Leave a reply

Edusera
Logo
Open chat
1
Scan the code
Hello!👋
Can we help you?